No announcement yet.

database error mysql error 1054

  • Filter
  • Time
  • Show
Clear All
new posts

  • brendak555
    No, noone has messed with the site in some time. And no I dont have a backup.

    Leave a comment:

  • Zachery
    Did you do anything to your site? It seems an important column is missin gfrom your database, do you have a backup?

    Leave a comment:

  • brendak555
    started a topic database error mysql error 1054

    database error mysql error 1054

    My website & forum has been running perfectly fine. Was on the site around noon today came home from an appt and all my other pages of the site work, except the forum. I was getting this:
    Database errorThe TMTW Forums database has encountered a problem.Please try the following:
    • Load the page again by clicking the Refresh button in your web browser.
    • Open the home page, then try to open another page.
    • Click the Back button to try another link.
    The forum technical staff have been notified of the error, though you may contact them if the problem persists.
    We apologise for any inconvenience.

    I called my host and they ran some test they said everything should be working & they dont know what is going on.

    Now in addition to the above at the bottom of the ERROR page I am getting this:

    SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid

    FROM forum AS forum;

    MySQL Error : Unknown column 'lastposter' in 'field list'
    Error Number : 1054
    Request Date : Saturday, August 14th 2010 @ 06:22:45 PM
    Error Date : Saturday, August 14th 2010 @ 06:22:45 PM
    Script :
    Referrer :
    IP Address : xxxxx
    Username : xxxx
    Classname : vb_database
    MySQL Version : 4.1.24-max-log

    Can someone please help! I have no knowledge of databases, mysql or anything. We had someone build our site for us, I have no way of contacting the person any longer.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.