Log in

View Full Version : Error Message with Inferno Vbshout


phoenixgold
10-03-2008, 05:34 AM
Hi,

I need help to fix this please,
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 : http://xsgaming.com/forums/infernoshout.php
Referrer : http://xsgaming.com/forums/index.php
IP Address : 98.148.217.46
Username : admin
Classname : vb_database

Can someone please help me fix this problem?

Thanks in advance

Marco van Herwaarden
10-03-2008, 08:09 AM
If you have questions/problems with a modification or style, then please post in the thread (or support forum/board) about that modification/style. Best chance to receive a reply from either the author or another member using the same modification/style.