PDA

Archiv verlassen und diese Seite im Standarddesign anzeigen : Datenbankfehler



MotMann
16.12.2009, 10:18
Hohohohooo..... ihr vBler :)

Seit einiger Zeit habe ich, wenn die Blogseite aufgerufen wird, folgende Datenbankfehler:


Datenbankfehler in vBulletin 3.8.1:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_wol AS phrasegroup_wol,
language.phrasegroup_user AS phrasegroup_user,
language.phrasegroup_messaging AS phrasegroup_messaging,
language.phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
language.phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
language.phrasegroup_infractionlevel AS phrasegroup_infractionlevel,
language.phrasegroup_posting AS phrasegroup_posting,
language.phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
language.phrasegroup_gxbl AS phrasegroup_gxbl,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
, blog_user.bloguserid, blog_user.entries, blog_user.options AS blog_options, blog_user.subscribeown AS blog_subscribeown,
blog_user.subscribeothers AS blog_subscribeothers, blog_user.title AS blog_title, blog_user.description AS blog_description, blog_user.allowsmilie AS blog_allowsmilie, blog_user.draft AS blog_draft, blog_user.pending AS blog_pending, blog_user.options_everyone, blog_user.options_buddy, blog_user.options_ignore, blog_user.uncatentries, blog_user.moderation AS blog_moderation, blog_user.deleted AS blog_deleted, blog_user.akismet_key AS blog_akismet_key, isblogmoderator, blog_user.comments_moderation AS blog_comments_moderation, blog_user.lastblog, blog_user.lastblogid, blog_user.lastblogtitle, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight
FROM vb_user AS user
LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb_language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

LEFT JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = user.userid)
LEFT JOIN vb_customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
WHERE user.userid = 1433;

MySQL-Fehler : Unknown column 'blog_user.options_everyone' in 'field list'
Fehler-Nr. : 1054

Ich denke mal, dass es was mit den Phrasen/Sprache zu tun hat? Auch im Menü im header fehlt die Schrift unter dem Blog-Icon.

Nun habe ich laufend Blog neu installiert, es passiert aber nichts.

http://www.xboxgamertag.de

Need help ...... :o

Mystics
16.12.2009, 15:58
Entweder das:
http://www.vbulletin-germany.com/forum/showpost.php?p=253476&postcount=2

Oder du verwendest veraltete Blog-Dateien.

MotMann
17.12.2009, 01:18
Das FTP Programm hatte Dateien gelöscht. Ich habe die Blog Version von vB geladen und installiert...

Vorher lief alles easy, daher denke ich mal, dass der Tipp vom Link nicht nötig ist...

Trotzdem klappt es nicht.

Mystics
17.12.2009, 11:29
Erstelle bitte ein Support-Ticket mit Admin-Zugang (alle Rechte), FTP- und phpMyAdmin-Daten, einem Link zu phpMyAdmin sowie einem Link zu diesem Thema:

Support-Ticket erstellen (http://members.vbulletin-germany.com/membersupport_contactform.php)

MotMann
18.12.2009, 10:58
Sie haben Post... Danke :)