Durch Blog SQL Fehler in vBCMS
Seit ich die neuste Blogversion habe, erhalte ich bei Aufruf xboxgamertag.de folgende Fehlermeldung, bei Aufruf des vBCMS:
Datenbankfehler in vBulletin 3.8.1:
Invalid SQL:
SELECT blog.*, user.*, blog_user.title AS blogtitle, blog_user.options_everyone, blog_user.options_buddy
, blog_read.readtime AS blogread, blog_userread.readtime AS bloguserread
, ignored.relationid AS ignoreid, buddy.relationid AS buddyid
FROM vb_blog AS blog
LEFT JOIN vb_blog_read AS blog_read ON (blog_read.blogid = blog.blogid AND blog_read.userid = 351)
LEFT JOIN vb_blog_userread AS blog_userread ON (blog_userread.bloguserid = blog.userid AND blog_userread.userid = 351)
LEFT JOIN vb_user AS user ON (blog.userid = user.userid)
LEFT JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = user.userid)
LEFT JOIN vb_userlist AS buddy ON (buddy.userid = blog.userid AND buddy.relationid = 351 AND buddy.type = 'buddy')
LEFT JOIN vb_userlist AS ignored ON (ignored.userid = blog.userid AND ignored.relationid = 351 AND ignored.type = 'ignore')
WHERE blog.state = 'visible' AND ((options_ignore & 1 AND ignored.relationid IS NOT NULL) OR (options_buddy & 1 AND buddy.relationid IS NOT NULL) OR (options_everyone & 1 AND (options_buddy & 1 OR buddy.relationid IS NULL) AND (options_ignore & 1 OR ignored.relationid IS NULL)))
ORDER BY dateline DESC
LIMIT 5;
MySQL-Fehler : Unknown column 'blog_user.options_everyone' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Friday, 13.02.2009 @ 00:31:14
Datum : Friday, 13.02.2009 @ 00:31:14
Skript : XXXXXXXXX
Referrer :
IP-Adresse : 87.158.106.20
Benutzername : XXXX
Klassenname : vB_Database
MySQL-Version : 5.0.45-max-log
EDIT: Erledigt. Der Fehler lag am Blog Modul.
__________________
Software: vB 3.8.1 * Style: Cyberhype, Tribe * Ansicht: Neues vB *
Last edited by MotMann : 13.02.2009 at 08:29.
|