1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

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

Discussion in 'Web Design & Development' started by Distance, Jul 15, 2006.

Thread Status:
Not open for further replies.
Advertisement
  1. Distance

    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
     
  2. Distance

    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! :(
     
  3. Chicon

    Chicon

    Joined:
    Jul 29, 2004
    Messages:
    6,650
    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.
     
  4. Distance

    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
     
  5. Chicon

    Chicon

    Joined:
    Jul 29, 2004
    Messages:
    6,650
    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 ?
     
  6. Distance

    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
     
  7. Sponsor

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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/483418

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice