Database Error with new users logging in

Discussion in 'Troubleshooting' started by kallell, Feb 11, 2011.

  1. kallell

    kallell New Member

    Joined:
    Jun 7, 2010
    Messages:
    5
    We just updated vbulletin 4.1.1 and it seems that now when new users are created, they are ported over to vbulletin, and start to log in, but after the page "Thank you for logging in, you will be redirected...." they are then taken to a generic database error page.

    I've tried rebuilding all the vbulletin tables already, with no luck. I also created a new user via admin cp of vbulletin, and that worked fine.

    ANy ideas?
  2. kallell

    kallell New Member

    Joined:
    Jun 7, 2010
    Messages:
    5
    More info my host figured out:

    The SQL generated by vbulletin is indeed wrong:
    AND userlist.userid = *******);

    The ******* cannot be blank - there has to be something there else the SQL is invalid. You will need to follow this up with your coders / vbulletin.

    You guys know of anything that could be causing this with the new version of vb 4.1.1?
  3. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Please contact us in helpdesk and provide a way to recreate issue. We will check what can be wrong.

Share This Page