phoenixgold
New Member
Hi,
Can someone pleeeeeeeeeeaaaase tell me why I am getting this error. I have followed every direction.
I see many having this problem. Why?
Help
Thanks
Database error in vBulletin 3.6.8:
Invalid SQL:
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '2')
OR
(s.s_private <> -1 AND s.s_user = '2')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced <> '0' AND u.userid = '2')
)
order by s.s_time desc limit 20;
MySQL Error : Unknown column 's.s_private' in 'where clause'
Error Number : 1054
Date : Friday, October 3rd 2008 @ 01:17:36 AM
Script : XSGaming.com Video Game Forum Play Games Database Error
Referrer : XSGaming.com Video Game Forum Play Games - Powered by vBulletin
IP Address : 98.148.217.46
Username : admin
Classname : vb_database
Can someone pleeeeeeeeeeaaaase tell me why I am getting this error. I have followed every direction.
I see many having this problem. Why?
Help
Thanks
Database error in vBulletin 3.6.8:
Invalid SQL:
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '2')
OR
(s.s_private <> -1 AND s.s_user = '2')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced <> '0' AND u.userid = '2')
)
order by s.s_time desc limit 20;
MySQL Error : Unknown column 's.s_private' in 'where clause'
Error Number : 1054
Date : Friday, October 3rd 2008 @ 01:17:36 AM
Script : XSGaming.com Video Game Forum Play Games Database Error
Referrer : XSGaming.com Video Game Forum Play Games - Powered by vBulletin
IP Address : 98.148.217.46
Username : admin
Classname : vb_database