Ramses
22.10.2005, 00:37
Wenn ich einen User auf die Harvey Liste setzte, gibt es massenhafte Database errors, woran kann das liegen? Hier 2 Fehlermeldungen:
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT COUNT(*) AS threads,
SUM(IF(lastpost >= 1129925326 AND open <> 10, 1, 0)) AS newthread
FROM vb3_thread AS thread
WHERE forumid = 2
AND sticky = 0
AND visible = 1
AND postuserid NOT IN (xxx);
MySQL Error : Unknown column 'xxx' in 'where clause'
Error Number : 1054
Date : Friday, October 21st 2005 @ 10:37:04 PM
Script : http://www.modell-chat.de/forum/forumdisplay.php?f=2
Referrer : http://www.modell-chat.de/forum/
IP Address : xxx
Username : xxx
Classname : vb_database
-------------------------------------------------------------------------
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT imageid, images.title, filename, thumbname, originalname, extension, images.catid ,images.userid, images.username, images.title, images.views, votenum, votetotal, categories.title AS cattitle
FROM vb3_adv_gallery_images AS images
LEFT JOIN vb3_adv_gallery_categories AS categories USING (catid)
WHERE images.catid NOT IN(78) AND valid = 1 AND images.userid NOT IN(blmn)
ORDER BY dateline DESC
LIMIT 20;
MySQL Error : Unknown column 'xxx' in 'where clause'
Error Number : 1054
Date : Friday, October 21st 2005 @ 10:56:37 PM
Script : http://www.modell-chat.de/gallery/
Referrer : http://www.modell-chat.de/gallery
IP Address : xxx
Username : xxx
Classname : vb_database
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT COUNT(*) AS threads,
SUM(IF(lastpost >= 1129925326 AND open <> 10, 1, 0)) AS newthread
FROM vb3_thread AS thread
WHERE forumid = 2
AND sticky = 0
AND visible = 1
AND postuserid NOT IN (xxx);
MySQL Error : Unknown column 'xxx' in 'where clause'
Error Number : 1054
Date : Friday, October 21st 2005 @ 10:37:04 PM
Script : http://www.modell-chat.de/forum/forumdisplay.php?f=2
Referrer : http://www.modell-chat.de/forum/
IP Address : xxx
Username : xxx
Classname : vb_database
-------------------------------------------------------------------------
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT imageid, images.title, filename, thumbname, originalname, extension, images.catid ,images.userid, images.username, images.title, images.views, votenum, votetotal, categories.title AS cattitle
FROM vb3_adv_gallery_images AS images
LEFT JOIN vb3_adv_gallery_categories AS categories USING (catid)
WHERE images.catid NOT IN(78) AND valid = 1 AND images.userid NOT IN(blmn)
ORDER BY dateline DESC
LIMIT 20;
MySQL Error : Unknown column 'xxx' in 'where clause'
Error Number : 1054
Date : Friday, October 21st 2005 @ 10:56:37 PM
Script : http://www.modell-chat.de/gallery/
Referrer : http://www.modell-chat.de/gallery
IP Address : xxx
Username : xxx
Classname : vb_database