No announcement yet.

All members now guest + more trouble

  • Filter
  • Time
  • Show
Clear All
new posts

  • All members now guest + more trouble

    Hi all,

    I am fixing a friends database that was corrupted and I have retrieved all information, down to a tee.

    I am having these issues and I'm pretty good with mySQL , so if somebody can just give me a hedas up or some ledas on how to fix this.

    1 - all users all 1500 are now showing as guest, when I go into llist members or modify group list members (acp)or just find member(acp). I get none listed. It seems all user ids are set to guests.

    2 - Admin posted a announments it is now showing a different name, that is a regular user.

    3 - I notice on update counters / Update Thread Info I get an error, I believe this to be global since it is happening with three other boards on my server, I believe the new server confiq with the new PHP, might have stopped it. But need advice

    Database error in vBulletin Control Panel 2.2.9:

    Invalid SQL: UPDATE thread SET lastpost=1056492933,replycount=1,postusername='paijo_anelka', postuserid='3231', lastposter='humphry',attach= WHERE threadid=1999
    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 'WHERE threadid=1999' at line 1

    mysql error number: 1064

    Date: Sunday 29th of June 2003 07:52:57 PM

    Thank you very much, I am most concerned with fixing this nice persons DB with the final part of it I am guseeing during the move I missed some tables that relate to userids


    midnightz Have a good day

  • #2
    Tell your freind to fill out a support ticket at:

    Be sure to include the login info to your Admin CP, phpMyAdmin and FTP.
    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.