Sql script errors on upgrades from latest version about dnn.survey HOT 2 CLOSED

Daniel,
the only install package for DNN Survey 04.70.01 I found was marked as an RC. Version 04.70.00 was released with DNN 06.00.00, there was no official release of the Survey module later.
Anyway, when you upgrade from from Survey 04.60.00 to 04.70.xx (in any DNN version from 06.00.00!), you get a configuration error, because someone "forgot" to remove the code subdirectory from the web.config (I wonder how this could pass the quality checks!):

Line 188: <codeSubDirectories>
Line 189: <add directoryName="Survey" />
Line 190: </codeSubDirectories>

There was no new SQL script in any Survey 04.70.xx version, and I could upgrade from Survey 04.70.00 and 04.70.01 to 09.00.00 without a problem (except the one mentioned above that appears when you upgrade to DNN 04.07.xx).
I then tried to upgrade from a fresh install of 04.70.01 - also there, no problem.

Which installation pack did you try? I took the RC5 that I included in the pull request on April 11th ( see also https://github.com/MaiklT/DNN.Survey/releases )

from dnn.survey.

OK, got it. The ViewOrder column in the Surveys table can contain NULL values, and if there are some the script fails. Solution: change file 09.00.00.SqlDataProvider, line 32 from
ViewOrder,
to
ROW_NUMBER() OVER (PARTITION BY ModuleID ORDER BY ViewOrder, SurveyID) AS [ViewOrder]

Also check line 75 and line 180 - the column name in the old Surveys table was "CreatedByUser", not "CreatedByUserID"

(just as a reminder for myself...)

from dnn.survey.