
11-28-2004, 04:40 PM
|
|
|
Join Date: Feb 2002
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
oh, in my vbb 3.0.0 it writes "could not find 'vbindex_settings_saved' after i want to save the options with vbioptions.php.
in vbindex.php it states
Quote:
Datenbankfehler in vBulletin 3.0.0:
Ungueltige SQL-Abfrage:
## GET NEWS ##
SELECT thread.*,thread.iconid AS threadiconid, threadpost.pagetext AS pagetext,
threadpost.attach AS attachcount,
avatarpath, NOT ISNULL(avatardata) AS customavatar, user.avatarrevision, customavatar.dateline AS customdateline,
NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
LEFT JOIN post AS threadpost ON (thread.firstpostid = threadpost.postid)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 2)
WHERE forumid IN ()
AND deletionlog.primaryid IS NULL
AND forumid NOT IN (0)
AND thread.open <> 10
AND thread.visible = '1'
AND thread.postuserid NOT IN (7681,7681)
ORDER BY thread.sticky DESC, thread.dateline DESC
LIMIT 0
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 deletionlog.primaryid IS NULL
AND forumid NOT IN (0
mysql error number: 1064
Datum: 28.11.2004 19:36:14
Skript: http://www.testboard.planet-oliwood.to/vbb/vbindex.php
|
|