Database error emails regularly sent + need of cache purge

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vb_nils
    Member
    • Jul 2012
    • 59
    • 4.2.X

    Database error emails regularly sent + need of cache purge

    Good evening,

    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 :
    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...