Hi,

I am really impressed with what I have read about the NextBBS on this web site. Being a newbie, I was encouraged by the Easy install highlight outlined in the feature part, and decidede to try it out. Everything seemed fine untll about halfway through the intstallation. I get the following error message;

Inserting all required data in the database.
Failure! - Reported Error:
Sorry, unable to run query:
CREATE TABLE `bb_rssarticles` ( `art_id` int(11) NOT NULL auto_increment, `art_title` varchar(255) NOT NULL default '', `art_source` varchar(10) default NULL, `art_guid` varchar(255) default NULL, `art_link` varchar(255) default NULL, `art_description` text, `art_topic_id` int(11) default '0', `art_time` timestamp NOT NULL default CURRENT_TIMESTAMP, `server` int(10) default '1', `art_content` text, PRIMARY KEY (`art_id`), KEY `art_topic_id` (`art_topic_id`), KEY `art_source` (`server`,`art_source`)) ENGINE=MyISAM;

Any ideas? Grateful for any help  

---

Could you try installing again?
Let me know if the same error happens again: you have the "privilege" of being the first to have this issue (sorry!)

---

Hi Chris,

Tried again just now - same error. Just to clarify;
I have previously installed Joomla on two different directories on the same server (using different table prefixes), and this worked ok. I did the Nextbbs installation on a separate directory (same server), and thought this would work. I am using a hosting provider (B-One, www.b-one.net).

Sorry if this seems a bit trivial, but it is all new to me...

---

I tried this query locally and it worked for me.
Please check your database. Does it already contain a table called 'bb_rssarticles'?

---

I as well received the same error, i entered the sql command into phpmyadmin...

it errored on "`art_time` timestamp NOT NULL default CURRENT_TIMESTAMP ,"

MySQL said:

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP, `server` int(10) default '1', `art_content`

---

Ah, thanks, this should help.
It is possible that your version of MySql is slightly older than the one used for development.
Could you try running the same query without "default CURRENT_TIMESTAMP"?

Cheers,
-C.

---

chris wrote:

Ah, thanks, this should help. It is possible that your version of MySql is slightly older than the one used for development. Could you try running the same query without "default CURRENT_TIMESTAMP"? Cheers, -C.

It worked like a charm droping the default CURRENT_TIMESTAMP

edit: MySQL version: 4.0.27

Last edit by tenjin on Sep 7, 2006, 7:21 pm

---

OK, cool                                                    

---