Hi:
I'm running vBulletin 4.2.5 with PHP5
I needed to switch from one server to another. PHP version is the same with the same modules, and Apache too. The only change was with MySQL that changed to MySQL8.
The first error i found is that new MySQL server was configured to use utf8 as default so in includes/config.php i set the charset as my database is in latin1:
Apart from that i didn't noticed any other error until today that i tried to add a subscription and system fails with message:
Seems that the error is that rank is a reserved word and should be marked as that right?
I'm running vBulletin 4.2.5 with PHP5
I needed to switch from one server to another. PHP version is the same with the same modules, and Apache too. The only change was with MySQL that changed to MySQL8.
The first error i found is that new MySQL server was configured to use utf8 as default so in includes/config.php i set the charset as my database is in latin1:
PHP Code:
$config['Mysqli']['charset'] = 'latin1';
PHP Code:
Invalid SQL:
UPDATE vb_usertextfield SET
rank = '<img src="images/ranks/usuario_VIP.png" alt="" border="" />'
WHERE userid = 26;
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 'rank = '<img src="images/ranks/usuario_VIP.png" alt="" border="" />'
WHER' at line 2
Error Number : 1064
Request Date : Tuesday, April 6th 2021 @ 07:36:44 AM
Error Date : Tuesday, April 6th 2021 @ 07:36:45 AM
Comment