I keep getting the following messages when I try to restore from 2 different databases:

1st DB Message:
MySQL-ERROR
Error in Query:

CREATE TABLE xoops2_bb_posts_text ( post_id int(10) unsigned DEFAULT '0' NOT NULL, post_text text, post_edit text, PRIMARY KEY (post_id), KEY search (post_text) );
MySQL says:

Couldn't create table: xoops2_bb_posts_text

2nd DB Message:
MySQL-ERROR
Error in Query:

CREATE TABLE `xoops2_art_artcat` ( `ac_id` int(11) unsigned NOT NULL auto_increment, `art_id` int(11) unsigned NOT NULL default '0', `cat_id` mediumint(4) unsigned NOT NULL default '0', `uid` mediumint(8) unsigned NOT NULL default '0', `ac_register` int(10) unsigned NOT NULL default '0', `ac_publish` int(10) unsigned NOT NULL default '0', `ac_feature` int(10) unsigned NOT NULL default '0', PRIMARY KEY (ac_id), KEY `cat_id` (cat_id), KEY `art_id` (art_id) )TYPE=MyISAM;
MySQL says:

Couldn't create table: xoops2_art_artcat



The only database not being restored is the actual posts in the forums. All members post counts and forum topics are there....Can someone explain why this is happening and how I can fix it.

You could also try installing the modules, so the database is established and then removing the head information and just inserting the data alone into it.....

I really didnt understand what you suggested...

I already have the module installed (newbb). Are you saying re-install it?

What is the head information and how do I remove it?



Also... when I go to the foum and select a topic this appears over the header of the site:

NewbbTopicHandler::getAllPosts error:SELECT p.*, t.* FROM xoops2_bb_posts p, xoops2_bb_posts_text t WHERE p.topic_id=72 AND p.post_id = t.post_id AND p.approved = 1 ORDER BY p.post_id ASC