1
iolai
DB error
  • 2007/1/7 15:53

  • iolai

  • Quite a regular

  • Posts: 206

  • Since: 2004/6/26


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?
- Eli Baskin.
Dune MUD
AtomsWorld.com

2
jensclas
Re: DB error

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.

3
iolai
Re: DB error
  • 2007/1/7 20:53

  • iolai

  • Quite a regular

  • Posts: 206

  • Since: 2004/6/26


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?
- Eli Baskin.
Dune MUD
AtomsWorld.com

4
jensclas
Re: DB error

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

5
iolai
Re: DB error
  • 2007/1/7 21:36

  • iolai

  • Quite a regular

  • Posts: 206

  • Since: 2004/6/26


I did it, it returned that everything is ok, but the error is still there... Other things I can do?
- Eli Baskin.
Dune MUD
AtomsWorld.com

6
jensclas
Re: DB error

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

7
Dave_L
Re: DB error
  • 2007/1/7 23:42

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


In addition to what jensclas said:

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

Quote:
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


2) Post the results of this query:

Quote:
SHOW COLUMNS FROM xoops_bb_forums

8
iolai
Re: DB error
  • 2007/1/8 8:05

  • iolai

  • Quite a regular

  • Posts: 206

  • Since: 2004/6/26


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?
- Eli Baskin.
Dune MUD
AtomsWorld.com

9
Dave_L
Re: DB error
  • 2007/1/8 19:05

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


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.

Login

Who's Online

325 user(s) are online (209 user(s) are browsing Support Forums)


Members: 0


Guests: 325


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits