Hello,
We recently updated our site (in test environment) from 4.2.5 to 5.3.4.
I have had some errors that I managed to correct by doing another upgrade (again from original 4.2.5 installation) and deleting all plugins/products installed before upgrade, but I enabled VB Blogs and VB CMS (as recommended by Joe D. in other post).
I have error if I try to change banner for all styles, so I tried to run option in AdminCP -> Maintenance -> General Update Tools -> Rebuild styles. If I only check the first option, everything runs fine, but when I check option "Renumber all templates from 1" the following error occurs:
Database error in vBulletin 5.3.4:
Invalid SQL:
INSERT INTO template_temp
(styleid, title, template, template_un, templatetype, dateline, username, version, product, mergestatus, textonly)
SELECT {styleid, title, template, template_un, templatetype, dateline, username, version, product, mergestatus, textonly}
FROM template
ORDER BY styleid, templatetype, title
/**template_table_query_insert**/;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' title, template, template_un, templatetype, dateline, username, version, produc' at line 3
Error Number : 1064
Request Date : Sunday, March 4th 2018 @ 05:50:37 PM
Error Date : Sunday, March 4th 2018 @ 05:50:37 PM
Script : xxxxx/vb5/admincp/misc.php?do=rebuildstyles
Referrer : xxxx/admincp/misc.php?do=chooser&
IP Address : xxx
Username : xxxx
Classname : vB_Database_MySQLi
MySQL Version : 5.7.14
I'm using wamp, and PHP version 7.0.10.
Thanks.
We recently updated our site (in test environment) from 4.2.5 to 5.3.4.
I have had some errors that I managed to correct by doing another upgrade (again from original 4.2.5 installation) and deleting all plugins/products installed before upgrade, but I enabled VB Blogs and VB CMS (as recommended by Joe D. in other post).
I have error if I try to change banner for all styles, so I tried to run option in AdminCP -> Maintenance -> General Update Tools -> Rebuild styles. If I only check the first option, everything runs fine, but when I check option "Renumber all templates from 1" the following error occurs:
Database error in vBulletin 5.3.4:
Invalid SQL:
INSERT INTO template_temp
(styleid, title, template, template_un, templatetype, dateline, username, version, product, mergestatus, textonly)
SELECT {styleid, title, template, template_un, templatetype, dateline, username, version, product, mergestatus, textonly}
FROM template
ORDER BY styleid, templatetype, title
/**template_table_query_insert**/;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' title, template, template_un, templatetype, dateline, username, version, produc' at line 3
Error Number : 1064
Request Date : Sunday, March 4th 2018 @ 05:50:37 PM
Error Date : Sunday, March 4th 2018 @ 05:50:37 PM
Script : xxxxx/vb5/admincp/misc.php?do=rebuildstyles
Referrer : xxxx/admincp/misc.php?do=chooser&
IP Address : xxx
Username : xxxx
Classname : vB_Database_MySQLi
MySQL Version : 5.7.14
I'm using wamp, and PHP version 7.0.10.
Thanks.
Comment