MySql error.. vB shoutbox error ***HELP PLEASE!!!***

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Distance

Thread Starter
Joined
Apr 15, 2006
Messages
319
www.hullchat.co.uk... my website

i have got a shoutbox on there (vBshout 2-0 (AJAX))

When i went on it today it came up with the following message...



There seems to have been a problem with the Hull Chat database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.5.4:

Invalid SQL:

select s.*, u.username, u.usergroupid from shout s
left join user u on (u.userid = s.s_by)
order by s.sid desc limit 25;

MySQL Error : Table 'spyboy_hullchat.shout' doesn't exist
Error Number : 1146
Date : Saturday, July 15th 2006 @ 12:40:10 PM
Script : http://www.hullchat.co.uk/vbshout.php
Referrer :
IP Address : 17*removed by me*33
Username : JoshLeafe
Classname : vb_database




what do i need?? :S
 

Distance

Thread Starter
Joined
Apr 15, 2006
Messages
319
if its so obvious then please can you tell me


EDITED:
oops i posted this message in the wrong forum.. i tried posting in vbulletin.org, they said its obvious so i said if its obvious then please tell me.. they didnt! :(
 
Joined
Jul 29, 2004
Messages
6,650
joshleafe said:
if its so obvious then please can you tell me
There's nothing wrong in your SQL statement. You should check the permissions granted for the shout table.

I got once this kind of error on my server because users were not granted a SELECT permission on a table.
 

Distance

Thread Starter
Joined
Apr 15, 2006
Messages
319
its not that, i tried it and no joy.. could it be the table missing?

if so what can i do
 
Joined
Jul 29, 2004
Messages
6,650
joshleafe said:
its not that, i tried it and no joy.. could it be the table missing?

if so what can i do
In my previous reply, I've supposed the table shout already existed in the spyboy_hullchat database. You should connect to the database and type the Show tables command to check if the table is present.
What interface are you using to manage your MySQL server ?
 

Distance

Thread Starter
Joined
Apr 15, 2006
Messages
319
i have sorted the shoutbox out now, i edited the xml file to make a new name for vBshout

uninstalled old one now table present, disabled this new one and then installed normal vbshout again

working :D
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top