Good evening,
I'm regularly receiving emails with database error message as this one
vt_new is the name of the database, and I'm very surprised of this SQL query "UPDATE vt_new SET lastcontentid = 0, textcount = 3, lastcontent = 0, prefixid = 2058540820 WHERE id = 689360;" because I should have a table name after the UPDATE and not the database name.
Notice, the server uses MariaDB 5.5.41
Second point, is that I've noticed that I need to regularly purge the cache in order to avoid some error message when using the SiteBuilder.
If you have any advice, they are very welcome.
I'm regularly receiving emails with database error message as this one
Database error in vBulletin 5.1.7:
Invalid SQL:
UPDATE vt_new SET lastcontentid = 0, textcount = 3, lastcontent = 0, prefixid = 2058540820 WHERE id = 689360;
MySQL Error : index vt_new: attribute 'prefixid' can not be updated (must be boolean, integer, bigint, float, timestamp, MVA or JSON)
Error Number : 1064
Request Date : Sunday, May 24th 2015 @ 07:42:10 PM
Error Date : Sunday, May 24th 2015 @ 07:42:10 PM
Script : http:///create-content/text/
Referrer : http://www.xxxxxxx.fr/forum/m%...ent-broutement
IP Address : <hidden IP address>
Username : dragon31
Classname : vB_Database_MySQLi
MySQL Version :
Invalid SQL:
UPDATE vt_new SET lastcontentid = 0, textcount = 3, lastcontent = 0, prefixid = 2058540820 WHERE id = 689360;
MySQL Error : index vt_new: attribute 'prefixid' can not be updated (must be boolean, integer, bigint, float, timestamp, MVA or JSON)
Error Number : 1064
Request Date : Sunday, May 24th 2015 @ 07:42:10 PM
Error Date : Sunday, May 24th 2015 @ 07:42:10 PM
Script : http:///create-content/text/
Referrer : http://www.xxxxxxx.fr/forum/m%...ent-broutement
IP Address : <hidden IP address>
Username : dragon31
Classname : vB_Database_MySQLi
MySQL Version :
Notice, the server uses MariaDB 5.5.41
Second point, is that I've noticed that I need to regularly purge the cache in order to avoid some error message when using the SiteBuilder.
If you have any advice, they are very welcome.