Hi,

I have some trouble with NewBB / CBB 1.14 when I upgrade XOOPS from 2.0.13.1 to 2.0.13.2. When I did the upgrade, newbb would simply display a blank page.

I decided to backup all database tables, uninstalled completely newbb, made a clean install of it , updated the module through the System panel and re-imported the tables one by one.

Everything works fine except that I cannot import the table xoops_bb_posts_text.gz !

-------------------------------------------------------
When I try to import it I always get the following message:
-------------------------------------------------------

Starting at the line: 1

Error at the line 16: );

Query: CREATE TABLE xoops_bb_posts_text ( post_id int(8) unsigned DEFAULT '0' NOT NULL, post_text text, post_edit text, PRIMARY KEY (post_id), KEY search (post_text) );

MySQL: BLOB/TEXT column 'post_text' used in key specification without a key length

Stopped on error


-------------------------------------------------------
This is what I see when I open xoops_bb_posts_text.gz
-------------------------------------------------------

# Backup for MySQL
#
# --------------------------------------------------------

#
# Table structure for table xoops_bb_posts_text
#

DROP TABLE IF EXISTS xoops_bb_posts_text;
CREATE TABLE xoops_bb_posts_text (
post_id int(8) unsigned DEFAULT '0' NOT NULL,
post_text text,
post_edit text,
PRIMARY KEY (post_id),
KEY search (post_text)
);

#
# Dumping data for table xoops_bb_posts_text
#

INSERT INTO xoops_bb_posts_text VALUES.....



-------------------------------------------------------
You can see the forum here:
-------------------------------------------------------
http://www.msxcafe.org/modules/newbb/


-------------------------------------------------------
If you click on a category, it returns the following error message:
-------------------------------------------------------
SELECT t.*, u.name, u.uname, u2.uid, u2.name as last_post_name, u2.uname as last_poster, p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon, p.post_id, p.post_karma, p.require_reply, pt.post_text FROM xoops_bb_topics t LEFT JOIN xoops_users u ON u.uid = t.topic_poster LEFT JOIN xoops_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN xoops_bb_posts_text pt ON pt.post_id = t.topic_last_post_id LEFT JOIN xoops_users u2 ON u2.uid = p.uid WHERE (p.post_time > 1122713308 OR t.topic_sticky=1) AND t.forum_id = 1 AND t.approved = 1 AND p.approved = 1 ORDER BY t.topic_sticky DESC, p.post_time DESC



Unfortunately I know very little about databases and so on, I have tried to import the faulty table through phpMyAdmin but without success!
From the above, can someone spot the problem and explain me step-by-step what I should do.

I thank you very much in advance for your help!