Forum Login/Logout Error:  MySQL ERROR
Posted: 11 February 2008 01:25 PM   [ Ignore ]  
Grad Student
Rank
Total Posts:  58
Joined  05-21-2005

Hi there,

I been using EE for years for my gossip site http://www.hollywoodrag.com and my forums have some action.

(Forums )

I just upgraded to the newest verison and I still continue to have this same error with my forums.

I can’t figure it out.

When I or a member logins in out of the forums you get this error:

MySQL ERROR:

Error Number: 1146

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

Query
: SELECT pref_forum_name FROM exp_forum_prefs WHERE pref_id=’1’

 

Michele

[Mod edit: original thread - http://expressionengine.com/forums/viewthread/62867/][/url]

Profile
 
 
Posted: 11 February 2008 02:17 PM   [ Ignore ]   [ # 1 ]  
Moderator
Avatar
RankRankRankRankRankRankRankRank
Total Posts:  32910
Joined  05-14-2004

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. =)

 Signature 
Profile
MSG
 
 
Posted: 11 February 2008 02:58 PM   [ Ignore ]   [ # 2 ]  
Grad Student
Rank
Total Posts:  58
Joined  05-21-2005

I have updated the forums already and this error remains.

I have the latest forum version.

Profile
 
 
Posted: 11 February 2008 03:00 PM   [ Ignore ]   [ # 3 ]  
Moderator
Avatar
RankRankRankRankRankRankRankRank
Total Posts:  32910
Joined  05-14-2004

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

 Signature 
Profile
MSG
 
 
Posted: 11 February 2008 03:03 PM   [ Ignore ]   [ # 4 ]  
Grad Student
Rank
Total Posts:  58
Joined  05-21-2005

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.

Profile
 
 
Posted: 11 February 2008 03:10 PM   [ Ignore ]   [ # 5 ]  
Moderator
Avatar
RankRankRankRankRankRankRankRank
Total Posts:  32910
Joined  05-14-2004

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?

 Signature 
Profile
MSG
 
 
Posted: 11 February 2008 03:22 PM   [ Ignore ]   [ # 6 ]  
Grad Student
Rank
Total Posts:  58
Joined  05-21-2005

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

Profile
 
 
Posted: 11 February 2008 03:24 PM   [ Ignore ]   [ # 7 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15845
Joined  06-03-2002

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?

 Signature 
Profile
MSG
 
 
Posted: 11 February 2008 04:09 PM   [ Ignore ]   [ # 8 ]  
Grad Student
Rank
Total Posts:  58
Joined  05-21-2005

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.

Profile
 
 
Posted: 11 February 2008 04:14 PM   [ Ignore ]   [ # 9 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15845
Joined  06-03-2002

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.

 Signature 
Profile
MSG
 
 
Posted: 11 February 2008 06:04 PM   [ Ignore ]   [ # 10 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15845
Joined  06-03-2002

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.

 Signature 
Profile
MSG
 
 
   
 
 
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 1149, on July 16, 2007 09:33 AM
Total Registered Members: 65023 Total Logged-in Users: 30
Total Topics: 82109 Total Anonymous Users: 15
Total Replies: 441265 Total Guests: 226
Total Posts: 523374    
Members ( View Memberlist )