Announcement

Collapse
No announcement yet.

MySQL Strict Mode and Database Errors

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL Strict Mode and Database Errors

    Ok, hi all
    i decided to start posting in this forum.

    i have vb site and i have a lot of problems with my new box.
    site running under apache at win2003 web. the mysql version is 5.1.30-community and php is 5.2.6.
    the first problem is when i turned the Strict Mode at the MySQL on i will receive DB errors in the site.

    Code:
    Database error in vBulletin 3.8.0:
    Invalid SQL:
         UPDATE vb_session
         SET lastactivity = 1233017869, location = '/showthread.php?goto=newpost&t=1374', loggedin = 2, inforum = 195, inthread = 1374, incalendar = 0, badlocation = 0, useragent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB5; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)'
         WHERE sessionhash = 'ca237d82d03de04acc313ca1f3167950';
    MySQL Error   : Data too long for column 'useragent' at row 1
    Error Number  : 1406
    Request Date  : Monday, January 26th 2009 @ 04:57:49 PM
    Error Date    : Monday, January 26th 2009 @ 04:57:49 PM
    Script        : [URL]http://www.freezmobile.com/showthread.php?goto=newpost&t=1374[/URL]
    Referrer      : [URL]http://www.freezmobile.com/[/URL]
    IP Address    : *.*.*.*
    Username      : Rakhsh
    Classname     : vB_Database
    MySQL Version : 5.1.30-community
    and when i turned strict mode off, the site is working perfect but i received hundreds of Database Error Emails. i have copy paste some of them:

    Code:
    Database error in vBulletin :
     
    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to MySQL server on 'localhost' (10061)
    D:\websites\freezmobile\includes\class_core.php on line 311
     
    MySQL Error : 
    Error Number : 
    Request Date : Sunday, January 25th 2009 @ 04:16:46 AM
    Error Date : Sunday, January 25th 2009 @ 04:16:47 AM
    Script : [URL="http://www.freezmobile.com/showthread.php?t=12851"][COLOR=#0068cf]http://www.freezmobile.com/showthread.php?t=12851[/COLOR][/URL]
    Referrer : [URL="http://www.freezmobile.com/forumdisplay.php?f=252"][COLOR=#0068cf]http://www.freezmobile.com/forumdisplay.php?f=252[/COLOR][/URL]
    IP Address : *.*.*.*
    Username : 
    Classname : vB_Database
    MySQL Version :
    there is nothing in front of MySQL Error or Error Number. i only removed the IP.
    Code:
    Database error in vBulletin :
     
    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to MySQL server on 'localhost' (10061)
    D:\websites\freezmobile\includes\class_core.php on line 311
     
    MySQL Error : 
    Error Number : 
    Request Date : Sunday, January 25th 2009 @ 04:16:24 AM
    Error Date : Sunday, January 25th 2009 @ 04:16:25 AM
    Script : [URL="http://www.freezmobile.com/admincp/options.php?null=0"][COLOR=#0068cf]http://www.freezmobile.com/admincp/options.php?null=0[/COLOR][/URL]
    Referrer : [URL="http://www.freezmobile.com/admincp/index.php?do=nav"][COLOR=#0068cf]http://www.freezmobile.com/admincp/index.php?do=nav[/COLOR][/URL]
    IP Address : *.*.*.*
    Username : 
    Classname : vB_Database
    MySQL Version :
    Code:
    Database error in vBulletin :
     
    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to MySQL server on 'localhost' (10061)
    D:\websites\freezmobile\includes\class_core.php on line 311
     
    MySQL Error : 
    Error Number : 
    Request Date : Sunday, January 25th 2009 @ 04:18:37 AM
    Error Date : Sunday, January 25th 2009 @ 04:18:37 AM
    Script : [URL="http://www.freezmobile.com/attachment.php?attachmentid=24154&d=1211338139"][COLOR=#0068cf]http://www.freezmobile.com/attachment.php?attachmentid=24154&d=1211338139[/COLOR][/URL]
    Referrer : [URL="http://www.freezmobile.com/showthread.php?t=10145"][COLOR=#0068cf]http://www.freezmobile.com/showthread.php?t=10145[/COLOR][/URL]
    IP Address : *.*.*.*
    Username : 
    Classname : vB_Database
    MySQL Version :
    The strange thing is that the option at Error Handling & Logging under vboptions to turn the emails off does not work! even turned on or off i received 2 emails per second. is there any solution to solve these database errors?

  • #2
    Assuming the db info in your config.php file is correct, this is a server issue. Please see this page for the causes of this error:

    http://www.vbulletin.com/docs/html/cantconnect
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

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