Thread

When I attempt to login into my forums this error appears:

MySQL ERROR:

Error Number: 1146

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

Query: SELECT pref_forum_name FROM exp_forum_prefs WHERE pref_id=‘1

Is this a brand new forum or was it working before?  If it’s new- you’ll want to go to the control panel- and in ‘Modules’ got to the Forum module and set things up for the first time.

Actually Ive had it for a while, it happened during the update to the newest version.

Hm- any problems when you upgraded?  You visited the forum control panel after you uploaded the files- and followed all of the Forum upgrade docs?  Also- what version and build of EE are you running- should see both in the cp footer.

Yes I followed that. Also, I must note that anytime I have done forum updates/ee updates I always have some issues with the forums.

ver 2.0.0

Wonder if the old files didn’t get replaced properly.  In 2.0- that table should have been dropped- and it was, hence the error message.  However- the fresh files shouldn’t be calling that table.

What I’d do- ftp in, delete the system/modules/forum folder and upload a fresh copy of it- make sure all of the files are new.  See if that does the trick.  Only other thing I can think of would be some customization in the themes where you’re using a query to pull from the table- so fresh themes wouldn’t hurt either.  Or- a plugin/extension that calls the table?  Any of that sound likely?

I just upgraded to EE 1.6.1 and am getting a similar error:

MySQL ERROR:

Error Number: 1146

Description: Table 'nefarious.exp_forum_boards' doesn't exist

Query: SELECT f.forum_id, f.forum_name, b.board_label FROM exp_forums f, exp_forum_boards b WHERE f.forum_is_cat = 'n' AND b.board_id = f.board_id ORDER BY b.board_label asc, forum_order asc

I’m still using an older version of the Forum 1.3.1 and accessing the forum module through the control panel shows no apparent problems.

However, I cannot create or publish any new blog entries. That is how I discovered the problem. I clicked on “Publish”, selected the blog, and got the above error. I don’t see why there would be a call to the forum SQL from the Publish page???

After doing the update of EE I uploaded the older lang.forum.php and lang.forum_cp.php files to the system/language/english directory.

You will need to upgrade your forums to 2.0, R.K.  The Discussion Forum is integrated into the main application, so it’s important that you update simultaneously.

Okay, yes that solved the problem. Money is tight right now so I didn’t want to renew the forum license but I went ahead anyway. Thanks for keeping things affordable. 😊

Excellent, glad we could help!  Incidentally, your license never expires, only the download account must be renewed annually for a minimal fee.

I’m having the same problem as the people above. Getting the same error message. I don’t use the forums and don’t even have them installed. Do I have to renew my (long expired) license in order for EE to work? I’d rather not as my site just doesn’t need them. Thanks.

Did you ever have them installed?  This error would only occur in the Publish section if EE thinks you have the forum module installed, from a variable in your config.php folder.  Perhaps step back and give us more details.  When did you start seeing this error?

Found the problem: Had Yes selected for “Display Forum Topic Submission Field” in the blog preferences. Sorry about that.

Thanks for the help.

No problemo, glad you got it resolved!