1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Forum just started failing

Discussion in 'Troubleshooting and Problems' started by Simon R, Jul 9, 2011.

  1. Simon R

    Simon R Member


    Forum was working fine and has just started to break ....

    Loads of errors on the error log like

    Mysqli prepare error: Unknown column 'thread.username' in 'field list'    
    All in the same library

    I can still access the admin

    From the forum if you try and do anything you get the following

    Screen shot 2011-07-09 at 23.34.59.png
  2. Simon R

    Simon R Member

    Any help would be appreciated
  3. Brogan

    Brogan XenForo Moderator Staff Member

    Everything I've read on this seems to indicate the problem is with using incorrect single quotes in a query, assuming of course thread.username and thread.thread_id still exist (they're both fields in the thread table).

    Did you do anything/make any changes prior to this error appearing?
    Install any add-ons?
  4. Simon R

    Simon R Member

    nope .... I was watching TV :)
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  6. Brogan

    Brogan XenForo Moderator Staff Member

    As Jake has pointed out, it could be related to the chat add-on.
    So try disabling that first.

    Curiously though I've had that installed for months but have never had that error.
    Do you use the archive feature?

    A quick look shows that a thread ID and member ID are required for the archive.
    Did you perhaps delete the thread and/or user?

    Even so, try setting both to 0 to see if that resolves it.
  7. Simon R

    Simon R Member

    Chat has been in since day one

    I haven't myself deleted a thread or user

    Borbole is looking at it and says "I have missing fields at th ethread table"
  8. Simon R

    Simon R Member

    As you can see I'm a technical luddite
  9. Brogan

    Brogan XenForo Moderator Staff Member

    I did mention that above, but it would be highly unusual for some fields to suddenly disappear from the thread table.

    You will need to restore from a recent backup if that's the case.
  10. Simon R

    Simon R Member

    Thanks for the help ..... I'm on to hostgator to see if they had a server issue ... but they aren't very forthcoming
  11. Digital Doctor

    Digital Doctor Well-Known Member

    Working now ?
    What was the cause ?
  12. Floris

    Floris Guest

    For a host it is horrible to figure out on a per customer basis what was the previous state, the current one, what the software is, how it works, and what potentially the problem could be. That said: HostGator is usually not forthcoming when it comes to getting information about what's going on with the box your site resides on. Like many hosts they are the GoDaddy of hosting.

    I recommend to report the issue to the author of the plugin you have installed, and run check/optimize on your database to find potential issues if it is hosting related. Temp fix: uninstall the chat plugin.

Share This Page