Announcement

Collapse
No announcement yet.

Database error in vBulletin 3.8.8

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

  • Database error in vBulletin 3.8.8

    A new user registered, but his account doesn't work and I can't delete the account either, when trying his URL, I get this error below.

    I actually just want to delete the account (he did register a new one, that works fine), how can I delete the old account?

    Thanks

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

    Database error in vBulletin 3.8.8:

    Invalid SQL:

    SELECT album.*,
    picture.pictureid, picture.extension, picture.idhash, album.moderation,
    picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height

    FROM album AS album
    LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)

    WHERE album.userid =
    AND album.state IN ('public', 'private', 'profile')
    AND (album.visible > 0 OR album.moderation > 0)

    ORDER BY album.lastpicturedate DESC
    LIMIT 2;

    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 'AND album.state IN ('public', 'private', 'profile')
    AND (album.visible > 0 O' at line 9
    Error Number : 1064
    Request Date : Wednesday, March 11th 2015 @ 03:45:51 AM
    Error Date : Wednesday, March 11th 2015 @ 03:45:51 AM
    Script :
    Referrer :
    IP Address :
    Username :
    Classname : vB_Database
    MySQL Version : 5.5.41-cll-lve

  • #2
    Are you able to edit the account at all in the admincp?
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.5.2 Demo
    AdminAmmo - My Cloud Demo

    Comment


    • #3
      I was able to ban the user, nothing else, can't edit any of the fields.

      Is there a query I can run, that can delete a specific user?

      Comment


      • #4
        There is not a single query to delete a user.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud customization and demonstration site.
        vBulletin 5 Documentation - Updated every Friday. Report issues here.
        vBulletin 5 API - Full / Mobile
        I am not currently available for vB Messenger Chats.

        Comment


        • #5
          Ok, any suggestions to what I can do?

          Comment


          • #6
            I think we will need a support ticket so that we can investigate this, as we'll need access to your system.

            http://www.vbulletin.com/go/techsupport.

            We'll need your admincp login, and ftp access. Also please include a link to this topic.
            MARK.B | vBULLETIN SUPPORT

            TalkNewsUK - My vBulletin 5.5.2 Demo
            AdminAmmo - My Cloud Demo

            Comment


            • #7
              Maybe too much work for a user that's not active, I'll ignore for now, thanks...

              Comment

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