Thread

This error happens when you update EE and not the forums. You need to keep them in sync, so please update the Discussion Forum module to the latest version. =)

I have updated the forums already and this error remains.

I have the latest forum version.

Have you visited the Discussion Forum module in the CP? Or just uploaded the files?

In control panel its already installed, shows as 2.0.

The only issue I have is it wont login properly but I noticed it still logs me in - but shows the error signing out and in.

Did you actually click on the Discussion Forum module link in the Modules section?  I know it says it’s installed, but did you go into the module’s control panel?

Yes I went in. I’m on the forum management menu now.

Michele, you say you receive this error when logging in and out of the forums?  On the front end?  Or when accessing the Forum Module in your control panel?

Let’s say I’m logged into my control panel and then I go to the forums:

(outside the cp) http://www.hollywoodrag.com/index.php?/forums/

Im already logged in and can post.

Then when I’m on that page and click the link “logout” I get that error.

MySQL ERROR:

Error Number: 1146

Description: Table ‘bery7ski_hollywoodrag.exp_forum_prefs’ doesn’t exist

Query: SELECT pref_forum_url, pref_forum_name FROM exp_forum_prefs WHERE pref_id=‘1’

If I go back to the main page and click on a forum topic, I see I have been logged out.

Odd.

That query only executes in the 1.3.2 forum update, which is why I’m looking for clarification there, Michele, as that is only triggered when visiting the Forum module in the control panel.  If you could, please email me (not PM) Super Admin and FTP access and I’ll see what’s going on.

You have a number of issues with this installation, Michele which I highly recommend addressing.

* Your themes are out of date, indicating that an update(s) was performed incompletely.  Your control panel is using the old theme, and not even an up to date version of it, so there are many display errors, as well as missing images.

* You are running a live site in Debug mode 2 (errors displayed to everyone).  This is highly insecure for a public site.

* The error you reported happening when logging out is not what you are actually getting, which is why I was dumbfounded as to how you could be seeing that error when logging out.  The query error for the actual error you are getting is:

Query: SELECT pref_forum_url, pref_forum_name FROM exp_forum_prefs WHERE pref_id='1'

It is imperative when seeking assistance that any error messages are carefully and precisely communicated in order for us to be able to assist you.  This error relates to the updates not having being completed properly.  Your member module files are out of date, and is the source of the error.  So I’m recommending that you:

1) Change your Debug setting to 1 (show errors only to logged in Super Admins)
2) Download a fresh copy of ExpressionEngine and the Forum Module.  Since your database is in good shape, you do not need to perform a full upgrade, but the instructions for updating to the latest build.
3) Then go back to the upgrade instructions and at the bottom of the page, view and take action on each of the version specific instructions from the oldest version of EE that you were running up through version 1.6.2.  For your themes, you may find it simplest to simply overwrite them with the current themes from the new download, and work any modifications you have made back into these known good files.

It might be a good idea to hire an experienced ExpressionEngine user to help you with this process if you are not comfortable with handling the above course of action on your own.