I am trying to update to our letoDMS 3.2.0 to a newer version (to get the multifile upload working), but I'm stuck already at 3.3.0 database update... I have the 3.4.2 package downloaded to the server.
I can open the install dir ok, and get the "database update to 3.3.0 needed" message. When I try the update I get an SQL Syntax error, stating that the "UPDATE tblVersion SET major=3, minor=3, subminor=3" command is invalid.
If I try to run that sql script in MySQL Workbench I also get an error message, that the command can not run because there is no WHERE statement. If I turn the safemode off in Workbench preferences, it runs ok. Problem of course is, if I do that, the 3.3.0 update script thinks I'm already at 3.3.0 and don't do what it is supposed to do (in addition to the sql statement), but only proceeds to 3.4.0 database update. Tested proceeding with that, and 3.4.0 update goes through ok, but when trying to open our DMS, I get "database need to be updated" message.
After resettign everything to a new update try, I added "SET SQL_SAFE_UPDATES=0" to the update script, but no help. Also, SHOW VARIABLES LIKE 'sql_safe_updates' is OFF.
Any ideas, why is the script not working, but gives "SQL syntax" error?
MySQL is 5.5.9, Windows Server 2008 R2. I know, old stuff, old versions, completely new server is already running, but would be good to have this one working as well.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am trying to update to our letoDMS 3.2.0 to a newer version (to get the multifile upload working), but I'm stuck already at 3.3.0 database update... I have the 3.4.2 package downloaded to the server.
I can open the install dir ok, and get the "database update to 3.3.0 needed" message. When I try the update I get an SQL Syntax error, stating that the "UPDATE tblVersion SET major=3, minor=3, subminor=3" command is invalid.
If I try to run that sql script in MySQL Workbench I also get an error message, that the command can not run because there is no WHERE statement. If I turn the safemode off in Workbench preferences, it runs ok. Problem of course is, if I do that, the 3.3.0 update script thinks I'm already at 3.3.0 and don't do what it is supposed to do (in addition to the sql statement), but only proceeds to 3.4.0 database update. Tested proceeding with that, and 3.4.0 update goes through ok, but when trying to open our DMS, I get "database need to be updated" message.
After resettign everything to a new update try, I added "SET SQL_SAFE_UPDATES=0" to the update script, but no help. Also, SHOW VARIABLES LIKE 'sql_safe_updates' is OFF.
Any ideas, why is the script not working, but gives "SQL syntax" error?
MySQL is 5.5.9, Windows Server 2008 R2. I know, old stuff, old versions, completely new server is already running, but would be good to have this one working as well.