I didn't touch my site in ages, and all the sudden I couldn't post in the forum (newbb) - got an error.

I turned the site off and turned on MySQL debug. This is the problematic line:

SELECT forum_type, forum_name, forum_access, allow_html, allow_sig, posts_per_page, hot_threshold, topics_per_page FROM xoops_bb_forums WHERE forum_id = 3
Error number: 1054
Error message: Unknown column 'forum_access' in 'field list'

Obviously, something happened to the db. What happened? How db structure can change? And, how to fix it?

Your web host most likely gave youa ccess to your database through phpmyadmin - log in to your website hosts management (not xoops) and click on the phpMyAdmin - you should be able to simply click on a 'check and repair database' for your XOOPS tables. Give this a try.

I do have access from phpmyadmin and directly as well. I don't find a 'repair' link... Do you know where is it? Are you sure it exists?

Go to the MySQL Manager in your control panel
- Click on the phpMyAdmin link at the bottom
- Select the database you wish to check or repair
- Click on the Select All link
- Pull down the With Selected: drop down menu and
choose Check Table or Repair Table

Visual tutorial here

HTH

I did it, it returned that everything is ok, but the error is still there... Other things I can do?

hmm...we need more information - please list your site setup as listed in the read before you post below. (Xoops version, modules etc) Once you do this those more clever than me may be able to help. Sorry - what we have done is a first step...now need to dig deeper and thats over my head

In addition to what jensclas said:

1) Try doing that same query in phpMyAdmin, and see if you get an error:

Quote:

2) Post the results of this query:

Quote:

SQL query:

SELECT forum_type, forum_name, forum_access, allow_html, allow_sig, posts_per_page, hot_threshold, topics_per_page
FROM xoops_bb_forums
WHERE forum_id =3
LIMIT 0 , 30

MySQL said:
#1054 - Unknown column 'forum_access' in 'field list'

-----------------------------------

SQL query: SHOW COLUMNS FROM xoops_bb_forums

Field Type Null Key Default Extra
forum_id smallint(4) unsigned NO PRI NULL auto_increment
forum_name varchar(150) NO
forum_desc text YES NULL
parent_forum int(10) NO 0
forum_moderator text NO
forum_topics int(8) NO 0
forum_posts int(8) NO 0
forum_last_post_id int(5) unsigned NO 0
cat_id int(2) NO 0
forum_type int(1) NO 0
allow_html int(1) NO 1
allow_sig int(1) NO 1
allow_subject_prefix int(1) NO 0
hot_threshold tinyint(3) unsigned NO 10
forum_order int(8) NO 0
allow_attachments int(1) NO 1
attach_maxkb int(10) NO 1000
attach_ext text NO
allow_polls int(1) NO 0
subforum_count int(10) unsigned NO 0


Edit:
Further details:
The site is running on XOOPS 2.0.16 (upgraded two days ago), but the problem occured when it was 2.0.13.a.
Newbb 2.0.1

Anything else you need me to post?

My guess is that the version of the forum module doesn't match what's in the database. Or it could be a newbb bug.

newbb 2.0.1 is old and no longer supported.

I suggest you make a complete backup (files and database), and then upgrade to the current forum module "cbb". I don't have a link handy, but you should be able to find it by searching here.