Announcement

Collapse
No announcement yet.

database error mysql error 1054

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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 www.teachmetheway.com home page, then try to open another page.
    • Click the Back button to try another link.
    The www.teachmetheway.com 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 :
    http://www.teachmetheway.com/forums.php
    Referrer : http://www.teachmetheway.com/
    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.

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

    Comment


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

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X