PDA

View Full Version : Getting this error


crazyrockerz
06-04-2009, 08:51 PM
Database error in vBulletin 3.8.2:

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 = '58')
OR
(s.s_private <> -1 AND s.s_user = '58')
)


order by s.s_time desc
limit 20;

MySQL Error : Table 'XXXX.infernoshout' doesn't exist
Error Number : 1146
Request Date : Wednesday, June 3rd 2009 @ 12:16:40 PM
Error Date : Wednesday, June 3rd 2009 @ 12:16:47 PM
Script : http://www.XXXX.com/infernoshout.php
Referrer : http://www.XXXX.com/index.php
IP Address : 117.197.212.XXXX
Username : XXXX
Classname : vB_Database
MySQL Version :










Database error in vBulletin 3.8.2:

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 = '39')
OR
(s.s_private <> -1 AND s.s_user = '39')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced <> '0' AND u.userid = '39')
)

order by s.s_time desc
limit;

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 '' at line 22
Error Number : 1064
Request Date : Wednesday, June 3rd 2009 @ 12:18:54 PM
Error Date : Wednesday, June 3rd 2009 @ 12:19:00 PM
Script : http://www.XXXX.com/infernoshout.php
Referrer : http://www.XXXX.com/index.php
IP Address : 69.XXXX.89.XXXX
Username : XXXX
Classname : vB_Database
MySQL Version :



Database error in vBulletin 3.8.2:

Invalid SQL:

select s.sid, u.username, u.userid, u.displaygroupid, u.usergroupid
from infernoshoutsessions s
left join user u on (u.userid = s.s_user)
where s.s_activity > 1244045474
group by s_user;

MySQL Error : Table 'XXXX.infernoshoutsessions' doesn't exist
Error Number : 1146
Request Date : Wednesday, June 3rd 2009 @ 12:16:14 PM
Error Date : Wednesday, June 3rd 2009 @ 12:16:18 PM
Script : http://www.XXXX.com/infernoshout.php
Referrer : http://www.XXXX.com/index.php
IP Address : 69.112.89.54
Username : XXXX
Classname : vB_Database
MySQL Version :



there are repeating errors i am getting and i am new to this. can any one help me

Thanks in advance

Lynne
06-04-2009, 09:12 PM
The table infernoshoutsessions is not a default vbulletin table. You need to ask for help in the modification thread as that is where support for modifications is supposed to be given.