No announcement yet.

PM Database Error?

  • Filter
  • Time
  • Show
Clear All
new posts

  • PM Database Error?

    I'm not sure how this came up, but I got it this morning:

    Database error in vBulletin 2.2.8:

    Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=
    mysql error: You have an error in your SQL syntax near '' at line 1

    mysql error number: 1064

    Date: Wednesday 09th of October 2002 10:09:23 AM

    I don't know what this means, can someone explain it?

  • #2
    I'm not quite sure why you got this error either. Nonetheless, upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:


    [Of course change the exact URL as appropriate for your forums.]

    If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok. See if this fixes the problem.
    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.


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