Lightwizzard
17.06.2009, 19:20
bezugnehmnd auf diesen thread (http://www.vbulletin-germany.com/forum/showthread.php?p=259088#post259088)hatte ich gedacht es liegt am Forum, dem scheint aber nicht so zu sein.
also komplett neu instaliertes VB 3.8
dann alle uploads hochgeschoben für das Blog system
dann wie beschrieben :
5. Geben Sie im Feld "ODER die XML-Datei von Ihrem Server importieren"
./includes/xml/addon-vbblog.xml
ein.
Setzen Sie "Add-on überschreiben" auf Ja.danach bekomme ich folgendes:
Importiere Add-on, Bitte warten...
[:]
Style-Information neu erstellen
Updating style information for each style
Standard-Style ... (Templates) (Stylevariablen) (Replacement Variables) (CSS) (Einstellungen) Erledigt.
er bleibt hier nun auch stehn.
aber weder im ACP noch in der Navbar bekomme ich den Blog angezeigt.
nun hab ich festgestellt wenn ich in die Crons gehe und folgenden cron aufrufe blog_cleanup ich diesen Fehler bekomme:
Datenbankfehler in vBulletin 3.8.3:
Invalid SQL:
SELECT
user.username,
blog.userid, blog.title, blog.blogid, blog.categories, blog.postedby_username, blog.postedby_userid,
bu.title AS blogtitle, bu.options_guest & AS guestcanview
FROM blog AS blog
LEFT JOIN blog_user AS bu ON (blog.userid = bu.bloguserid)
LEFT JOIN user AS user ON (blog.userid = user.userid)
WHERE
state = 'visible' AND
dateline <= 1245258664 AND
blog.pending = 0 AND
~blog.options & AND
bu.options_buddy & AND
bu.options_member &
ORDER BY dateline DESC
LIMIT 1;
MySQL-Fehler : 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 'AS guestcanview
FROM blog AS blog
LEFT JOIN blog_user AS bu ON (blog.userid ' at line 4
Fehler-Nr. : 1064
Fehler-Zeit : Wednesday, 17.06.2009 @ 19:11:04
Datum : Wednesday, 17.06.2009 @ 19:11:04bei dem cron blog_pneding bekomme ich folgendes:
blog_pending
Schwerer Fehler: Please check the $bitfields array in the vB_DataManager_Blog_Firstpost class definition - $vbulletin->bf_misc_vbblogoptions is not a valid bitfield.
in [path]/includes/class_dm.php (Zeile 192)
#0 vb_error_handler(256, Please check the $bitfields array in the vB_DataManager_Blog_Firstpost class definition - $vbulletin->bf_misc_vbblogoptions is not a valid bitfield.
, /var/kunden/webs/andreas/forum/includes/class_dm.php, 192, Array ([this] => vB_DataManager_Blog_Firstpost Object ([validfields] => Array ([firstblogtextid] => Array ([0] => 3,[1] => 2),[lastcomment] => Array ([0] => 6,[1] => 2),[lastcommenter] => Array ([0] => 13,[1] => 0),[lastblogtextid] => Array ([0] => 3,[1] => 0),[comments_visible] => Array ([0] => 3,[1] => 2),[comments_moderation] => Array ([0] => 3,[1] => 0),[comments_deleted] => Array ([0] => 3,[1] => 0),[attach] => Array ([0] => 3,[1] => 0),[views] => Array ([0] => 3,[1] => 0),[trackback_visible] => Array ([0] => 3,[1] => 0),[trackback_moderation] => Array ([0] => 3,[1] => 0),[pending] => Array ([0] => 3,[1] => 0),[postedby_userid] => Array ([0] => 3,[1] => 0,[2] => _-_mEtHoD_-_),[postedby_username] => Array ([0] => 3,[1] => 0),[blogid] => Array ([0] => 3,[1] => 3,[2] => _-_mEtHoD_-_,[3] => verify_nonzero),[userid] => Array ([0] => 3,[1] => 0,[2] => _-_mEtHoD_-_),[bloguserid] => Array ([0] => 3,[1] => 0),[dateline] => Array ([0] => 6,[1] => 2),[title] => Array ([0] => 13,[1] => 1,[2] => _-_mEtHoD_-_),[state] => Array ([0] => 7,[1] => 0),[username] => Array ([0] => 13,[1] => 0,[2] => _-_mEtHoD_-_),[pagetext] => Array ([0] => 7,[1] => 1,[2] => _-_mEtHoD_-_),[allowsmilie] => Array ([0] => 3,[1] => 0),[ipaddress] => Array ([0] => 7,[1] => 2,[2] => _-_mEtHoD_-_)),[bitfields] => Array ([options] => bf_misc_vbblogoptions),[table] => blog,[blog] => Array (),[blog_text] => Array (),[condition_construct] => Array ([0] => blogid = %1$d,[1] => blogid),[setfields] => Array (),[rawfields] => Array (),[registry] => vB_Registry Object ([datastore] => vB_Datastore Object ([defaultitems] => Array ([0] => options,[1] => bitfields,[2] => attachmentcache,[3] => forumcache,[4] => usergroupcache,[5] => stylecache,[6] => languagecache,[7] => products,[8] => pluginlist,[9] => cron,[10] => profilefield,[11] => loadcache,[12] => noticecache),[itemarray] => Array (),[registry] => vB_Registry Object ( *RECURSION*,[dbobject] => vB_Database Object ([functions] => Array ([connect] => mysql_connect,[pconnect] => mysql_pconnect,[select_db] => mysql_select_db,[query] => mysql_query,[query_unbuffered] => mysql_unbuffered_query,[fetch_row] => mysql_fetch_row,[fetch_array] => mysql_fetch_array, usw ziemlich viel was da dann so ensteht.
komplett neu aufgesetztes VB direkt nach der reinen neuinstalation vom Forum.
Wer nen tipp ?
Danke schonmal im Voraus für die Hilfe
also komplett neu instaliertes VB 3.8
dann alle uploads hochgeschoben für das Blog system
dann wie beschrieben :
5. Geben Sie im Feld "ODER die XML-Datei von Ihrem Server importieren"
./includes/xml/addon-vbblog.xml
ein.
Setzen Sie "Add-on überschreiben" auf Ja.danach bekomme ich folgendes:
Importiere Add-on, Bitte warten...
[:]
Style-Information neu erstellen
Updating style information for each style
Standard-Style ... (Templates) (Stylevariablen) (Replacement Variables) (CSS) (Einstellungen) Erledigt.
er bleibt hier nun auch stehn.
aber weder im ACP noch in der Navbar bekomme ich den Blog angezeigt.
nun hab ich festgestellt wenn ich in die Crons gehe und folgenden cron aufrufe blog_cleanup ich diesen Fehler bekomme:
Datenbankfehler in vBulletin 3.8.3:
Invalid SQL:
SELECT
user.username,
blog.userid, blog.title, blog.blogid, blog.categories, blog.postedby_username, blog.postedby_userid,
bu.title AS blogtitle, bu.options_guest & AS guestcanview
FROM blog AS blog
LEFT JOIN blog_user AS bu ON (blog.userid = bu.bloguserid)
LEFT JOIN user AS user ON (blog.userid = user.userid)
WHERE
state = 'visible' AND
dateline <= 1245258664 AND
blog.pending = 0 AND
~blog.options & AND
bu.options_buddy & AND
bu.options_member &
ORDER BY dateline DESC
LIMIT 1;
MySQL-Fehler : 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 'AS guestcanview
FROM blog AS blog
LEFT JOIN blog_user AS bu ON (blog.userid ' at line 4
Fehler-Nr. : 1064
Fehler-Zeit : Wednesday, 17.06.2009 @ 19:11:04
Datum : Wednesday, 17.06.2009 @ 19:11:04bei dem cron blog_pneding bekomme ich folgendes:
blog_pending
Schwerer Fehler: Please check the $bitfields array in the vB_DataManager_Blog_Firstpost class definition - $vbulletin->bf_misc_vbblogoptions is not a valid bitfield.
in [path]/includes/class_dm.php (Zeile 192)
#0 vb_error_handler(256, Please check the $bitfields array in the vB_DataManager_Blog_Firstpost class definition - $vbulletin->bf_misc_vbblogoptions is not a valid bitfield.
, /var/kunden/webs/andreas/forum/includes/class_dm.php, 192, Array ([this] => vB_DataManager_Blog_Firstpost Object ([validfields] => Array ([firstblogtextid] => Array ([0] => 3,[1] => 2),[lastcomment] => Array ([0] => 6,[1] => 2),[lastcommenter] => Array ([0] => 13,[1] => 0),[lastblogtextid] => Array ([0] => 3,[1] => 0),[comments_visible] => Array ([0] => 3,[1] => 2),[comments_moderation] => Array ([0] => 3,[1] => 0),[comments_deleted] => Array ([0] => 3,[1] => 0),[attach] => Array ([0] => 3,[1] => 0),[views] => Array ([0] => 3,[1] => 0),[trackback_visible] => Array ([0] => 3,[1] => 0),[trackback_moderation] => Array ([0] => 3,[1] => 0),[pending] => Array ([0] => 3,[1] => 0),[postedby_userid] => Array ([0] => 3,[1] => 0,[2] => _-_mEtHoD_-_),[postedby_username] => Array ([0] => 3,[1] => 0),[blogid] => Array ([0] => 3,[1] => 3,[2] => _-_mEtHoD_-_,[3] => verify_nonzero),[userid] => Array ([0] => 3,[1] => 0,[2] => _-_mEtHoD_-_),[bloguserid] => Array ([0] => 3,[1] => 0),[dateline] => Array ([0] => 6,[1] => 2),[title] => Array ([0] => 13,[1] => 1,[2] => _-_mEtHoD_-_),[state] => Array ([0] => 7,[1] => 0),[username] => Array ([0] => 13,[1] => 0,[2] => _-_mEtHoD_-_),[pagetext] => Array ([0] => 7,[1] => 1,[2] => _-_mEtHoD_-_),[allowsmilie] => Array ([0] => 3,[1] => 0),[ipaddress] => Array ([0] => 7,[1] => 2,[2] => _-_mEtHoD_-_)),[bitfields] => Array ([options] => bf_misc_vbblogoptions),[table] => blog,[blog] => Array (),[blog_text] => Array (),[condition_construct] => Array ([0] => blogid = %1$d,[1] => blogid),[setfields] => Array (),[rawfields] => Array (),[registry] => vB_Registry Object ([datastore] => vB_Datastore Object ([defaultitems] => Array ([0] => options,[1] => bitfields,[2] => attachmentcache,[3] => forumcache,[4] => usergroupcache,[5] => stylecache,[6] => languagecache,[7] => products,[8] => pluginlist,[9] => cron,[10] => profilefield,[11] => loadcache,[12] => noticecache),[itemarray] => Array (),[registry] => vB_Registry Object ( *RECURSION*,[dbobject] => vB_Database Object ([functions] => Array ([connect] => mysql_connect,[pconnect] => mysql_pconnect,[select_db] => mysql_select_db,[query] => mysql_query,[query_unbuffered] => mysql_unbuffered_query,[fetch_row] => mysql_fetch_row,[fetch_array] => mysql_fetch_array, usw ziemlich viel was da dann so ensteht.
komplett neu aufgesetztes VB direkt nach der reinen neuinstalation vom Forum.
Wer nen tipp ?
Danke schonmal im Voraus für die Hilfe