No announcement yet.

I have a syntax problem

  • Filter
  • Time
  • Show
Clear All
new posts

  • I have a syntax problem


    First of all thanx for making life worthy

    Second I got this problem, below, when I was trying to modify a user profile to change his usergroup and his name through the CP

    Database error in vBulletin Control Panel: Invalid SQL: SELECT COUNT(*) AS users
    FROM user,usergroup WHERE user.usergroupid=usergroup.usergroupid AND
    usergroup.cancontrolpanel=1 AND user.userid<>
    mysql error: You have an error in your SQL syntax near '' at line 1
    mysql error number: 1064
    Date: Friday 27th of June 2003 03:37:12 AM
    Script: /

    Now can any one tell me how to fix this problem in 203 version??

  • #2
    This problem is caused by the latest versions of PHP which have broken some of the functions of older versions of vB. Your host must have recently upgraded PHP. To fix this you need to upgrade to vB 2.3.0.
    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.