Runtime error on upgrade when restoring at first time wizard

1

Upgrading from 1.7 to 1.8.6. When restoring the DB during first time wizard it just returns runtime error.

Query Error NULL not allowed for column “USER_LOGIN_NAME”; SQL statement: INSERT INTO users (user_id, user_login_name, user_email, user_pass, user_first_name, user_last_name, user_in_admin, user_create_date, user_active, user_in_dam) VALUES( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) [23502-191]

OpenBD:CFML RunTime Error
CFML Runtime Error
General SQL Error
Request /admin/index.cfm
File Trace /opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/admin/index.cfm
|
+-- /opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/fusebox5/corefiles/fusebox5.cfm
    |
    +-- /opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/fusebox5/corefiles/Application.cfc
        |
        +-- /opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/admin/parsed/c.first_time_database_restore_system.cfm
            |
            +-- /opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/cfc/hosts.cfc
Type Database
Function(s) onError (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/fusebox5/corefiles/Application.cfc, Line=267, Column=2)
|
+--onRequest (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/fusebox5/corefiles/Application.cfc, Line=218, Column=2)
    |
    +--setupdb (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/cfc/hosts.cfc, Line=32, Column=1)
        |
        +--add (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/cfc/hosts.cfc, Line=64, Column=1)
Query Error NULL not allowed for column "USER_LOGIN_NAME"; SQL statement: INSERT INTO users (user_id, user_login_name, user_email, user_pass, user_first_name, user_last_name, user_in_admin, user_create_date, user_active, user_in_dam) VALUES( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) [23502-191]
Datasource H2
Native Error Code 23502
SQL State 23502
SQL INSERT INTO users (user_id, user_login_name, user_email, user_pass, user_first_name, user_last_name, user_in_admin, user_create_date, user_active, user_in_dam) VALUES( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
Tag Context CFQUERY (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/cfc/hosts.cfc, Line=132, Column=5)
|
+-- CFIF (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/cfc/hosts.cfc, Line=126, Column=4)
    |
    +-- CFIF (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/cfc/hosts.cfc, Line=78, Column=2)
        |
        +-- CFFUNCTION (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/cfc/hosts.cfc, Line=64, Column=1)
            |
            +-- CFINVOKE (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/cfc/hosts.cfc, Line=39, Column=2)
                |
                +-- CFFUNCTION (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/cfc/hosts.cfc, Line=32, Column=1)
                    |
                    +-- CFSET (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/admin/parsed/c.first_time_database_restore_system.cfm, Line=109, Column=1)
                        |
                        +-- CFTRY (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/admin/parsed/c.first_time_database_restore_system.cfm, Line=5, Column=1)
                            |
                            +-- CFINCLUDE (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/fusebox5/corefiles/Application.cfc, Line=232, Column=6)
                                |
                                +-- CFLOCK (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/fusebox5/corefiles/Application.cfc, Line=231, Column=5)
                                    |
                                    +-- CFTRY (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/fusebox5/corefiles/Application.cfc, Line=226, Column=4)
                                        |
                                        +-- CFIF (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/fusebox5/corefiles/Application.cfc, Line=222, Column=3)
                                            |
                                            +-- CFFUNCTION (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/fusebox5/corefiles/Application.cfc, Line=218, Column=2)
                                                |
                                                +-- CFSET (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/fusebox5/corefiles/fusebox5.cfm, Line=57, Column=2)
                                                    |
                                                    +-- CFTRY (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/fusebox5/corefiles/fusebox5.cfm, Line=56, Column=1)
                                                        |
                                                        +-- CFPROCESSINGDIRECTIVE (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/global/fusebox5/corefiles/fusebox5.cfm, Line=55, Column=9)
                                                            |
                                                            +-- CFINCLUDE (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/admin/index.cfm, Line=32, Column=2)
                                                                |
                                                                +-- CFLOCK (/opt/razuna/razuna_tomcat_1_8_6/tomcat/webapps/razuna/admin/index.cfm, Line=31, Column=1)
Source 
129:         <cfset thepass = hash(arguments.thestruct.user_pass, "MD5", "UTF-8")>
130:         <!--- Insert the User into the DB --->
131:         <cfset newuserid = createuuid()>
132:         <cfquery datasource="#variables.dsn#">
133:         INSERT INTO users
^ Snippet from underlying CFML source

2

Tried to restore another backup of the 1.7 server to a fresh 1.8.1 server and it made it most of the way before complaining about missing tables and returning error. Only step forward was to continue with new DB and once setup I cannot even view the Backup & Restore tab.

On new 1.8.6 server I proceeded past start up wizard with fresh DB then tried to run the restore from there. Made it through some of the tables and returned OpenDB Internal Server Error.

Source	
976:         <!--- Drop Constraints --->
977:         <cfinvoke method="dropconst" theindex="#thetable#">
978:         <!--- Select records from the backup table --->
979:         <cfquery dataSource="razuna_backup" name="sourcedb">
980:         SELECT *

Afterwards the page become unresponsive. I refreshed and was prompted with razuna upgrade page so I clicked upgrade and it took me to the log in screen. After several failed attempts at logging in I modified and ran the SysAdminsReset.cfm and it returned no users. Had to modify the RestWizard.cfm to set the first time wizard flag to true just so I could get back in and clear the DB. Someone please help :cry:

I’d settle for a method of downloading all the assets and there directory structure.

3

Please try to clear the cookie and template cache from your browser and try again to see how.

Thanks

4

Looks like the same error occurs. Not exactly sure what the problem is. Seems like maybe the DB I’m trying to restore may be corrupted.