
01-29-2007, 02:51 PM
|
|
|
Join Date: Jun 2002
Location: New York
Posts: 367
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
sinister...i downloaded your version, but i still cannot see the categorys....any ideas?
if it turn off the option of categorys...and submit an issue, i get this error before the redirect:
Quote:
Warning: Invalid argument supplied for foreach() in /vbsupport.php on line 398
|
and after the redirect the following....I AM NOT USING TABLE PREFIXES....
Quote:
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
level,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM vbs_ticket_post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,1)
ORDER BY post.dateline;
MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Monday, January 29th 2007 @ 11:53:37 AM
Script : http://www.fsenyc.com/forum/vbsuppor...ewthread&tid=1
Referrer : http://www.fsenyc.com/forum/vbsupport.php
IP Address : xxx.xx.xx.xxx
Username : nymyth
Classname : vb_database
|
Peace
|