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
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
Comment