data base error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sevo
    New Member
    • Dec 2007
    • 29

    data base error

    I keep getting this data base error sent to my email. I have optimized and repaired the tables.. any idea what this means

    Database error in vBulletin 3.7.3:

    Invalid SQL:

    UPDATE session
    SET lastactivity = 1223667039, inforum = 0, inthread = 0, badlocation = 0, useragent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)'
    WHERE sessionhash = 'dd8d877f2edcbbe5c7afe1bc9d897662';

    MySQL Error : Data too long for column 'useragent' at row 1
    Error Number : 1406


    thank you for your input
  • Sevo
    New Member
    • Dec 2007
    • 29

    #2
    Found this on the boards.. just set it to "true".. lets see if that fixed it

    Originally posted by Freddie Bingham
    What version of MySQL are you using? Have you enabled the following option in includes/config.php:
    Code:
    $config['Database']['force_sql_mode'] = true;

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...