Announcement

Collapse
No announcement yet.

mysql error on two user accounts

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

  • mysql error on two user accounts

    I am useless with MySQL and don't know what to do when an error occurs. Now I've been getting these reports. Any clue to what they're on about is greatly appreciated




    Database error in vBulletin Mod Control Panel 2.3.0:

    Invalid SQL: SELECT userid,usergroupid,username,password,email,parentemail,coppauser,homepage,icq,aim,yahoo,si gnature,adminemail,showemail,styleid,invisible,usertitle,customtitle,FROM_UNIXTIME(joindat e) AS joindate,cookieuser,daysprune,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,posts,timezoneoffset,emailnotification,emailonpm,receivepm,ipaddress FROM user WHERE userid=
    mysql error: You have an error in your SQL syntax near '' at line 1

    mysql error number: 1064

    Date: Wednesday 10th of December 2003 07:13:51 PM
    Script: http://mb.corrsonline.com/mod/user.p...er&userid=6769
    Referer: http://mb.corrsonline.com/mod/index....6userid%3D6769


    ----------------------------------------------------------------


    Database error in vBulletin Mod Control Panel 2.3.0:

    Invalid SQL: SELECT userid,usergroupid,username,password,email,parentemail,coppauser,homepage,icq,aim,yahoo,si gnature,adminemail,showemail,styleid,invisible,usertitle,customtitle,FROM_UNIXTIME(joindat e) AS joindate,cookieuser,daysprune,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,posts,timezoneoffset,emailnotification,emailonpm,receivepm,ipaddress FROM user WHERE userid=
    mysql error: You have an error in your SQL syntax near '' at line 1

    mysql error number: 1064

    Date: Wednesday 10th of December 2003 07:14:31 PM
    Script: http://mb.corrsonline.com/mod/user.p...er&userid=6764
    Referer: http://mb.corrsonline.com/mod/index....6userid%3D6764

  • #2
    Reupload the original 2.3.0 user.php file to the mod directory. Make sure you upload in ASCII and overwritwe the one on the server.
    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


    • #3
      Originally posted by Steve Machol
      Reupload the original 2.3.0 user.php file to the mod directory. Make sure you upload in ASCII and overwritwe the one on the server.
      Ok will try that, just need to find the original file somewhere

      Comment

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