Announcement

Collapse
No announcement yet.

Invalid SQL errors.

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

  • Invalid SQL errors.

    here's 4 of them, two before upgrading to 3.0.1

    what's doing this?

    *****************************************************


    Database error in vBulletin 3.0.1:

    Invalid SQL:

    SELECT NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,

    deletionlog.username AS del_username, deletionlog.reason AS del_reason,

    NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,

    thread.*

    FROM thread AS thread

    LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')

    LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 4)



    WHERE thread.threadid = 7165



    mysql error: Lost connection to MySQL server during query



    mysql error number: 2013

    *****************************************************

    Database error in vBulletin 3.0.1:



    Invalid SQL:

    SELECT avatardata, dateline, filename

    FROM customavatar

    WHERE userid = 606 AND visible = 1



    mysql error: Lost connection to MySQL server during query



    mysql error number: 2013


    *****************************************************



    Database error in vBulletin 3.0.0:



    Invalid SQL:

    INSERT INTO post

    (threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,

    showsignature, ipaddress, iconid, visible, attach)

    VALUES

    (7172, , '',

    'Hawaiiannights', 474, 1081990509,

    '???????????', 1, 1,

    '208.25.198.231', 0, 1, 0)



    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 ' '',

    'Hawaiiannights', 474, 1081990509,

    '???????????'



    mysql error number: 1064





    *****************************************************






    Database error in vBulletin 3.0.0:



    Invalid SQL:

    SELECT *

    FROM session

    WHERE sessionhash = 'c2e4b8b698824cb5732ade8f6407fa69'

    AND lastactivity > 1081990402

    AND host = '64.12.117.13'

    AND idhash = 'd0ca337e818560dea1d1217d9387a631'



    mysql error: Lost connection to MySQL server during query



    mysql error number: 2013



    \

  • #2
    in the past 48 hours, i have:
    run repair on the database, re-uploaded a full clean copy of vbulletin
    gone through options... etc.

    i'm open to ideas.....

    Comment

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