I had the same problem and this is how we fixed it:

open safedump.sql
go to line 3586

And replace this:
 INSERT INTO `chris_users` (userid, password, fullname, email, server, mgroup, checker, skinid, avatar) VALUES ('[your_name]',[your_password],'Chris F R','webmaster@clicdev.com'..........   --->

with this:
INSERT INTO `chris_users` (userid, password, fullname, email, server, mgroup, checker, skinid, avatar) VALUES ('[your_name]','[your_password]','Chris F R','webmaster@clicdev.com'..............

the single quotes are missing here [your_password] should be '[your_password]'

hope this helps

---

in my safedump.sql file its line 3686, I'm installing version 0.4.6. Should I try the nightly build?
Also, I changed what you said (put the quotes) but no luck, same error

Last edit by shaiss on Mar 15, 2007, 12:12 pm

---

Shaiss, I am going to have to verify the nightly build first.
The problems you are seeing are fixed but dahmak reported a very real issue. I suspect it's a side effect of my fixing password generation in newinstall

---

Let us know what you find Chris. I've searched high, low, and everywere in between and nextbbs is by far the best BB out there. I've used PHPbb but would much rather use this. Let me know what you guys find.
Thank you!!!

---

Thanks!

OK guys, I double-checked and of course I totally ignored a couple single quotes when I modified newinstall. Next nightly build should be all right.

Sorry about that!

---

when should we download?

---

The new nightly build must be ready by now...therefore: now!

---

download, tried to install, now I get this

Inserting all required data in the database.
Failure! - Reported Error:
Sorry, unable to run query:
CREATE TABLE `bb_folders` ( `folder_ID` int(11) NOT NULL auto_increment, `owner_id` int(10) NOT NULL default '0', `folder_name` varchar(255) default NULL, `folder_icon_id` int(10) default NULL, `server` int(10) default NULL, PRIMARY KEY (`owner_id`,`folder_ID`), KEY `server` (`server`)) ;

---

I get the same error as shaiss with the nightly build.

I ran the offending query in MySQL Query Browser and got:

Error 1075
Incorrect table definition; there can be only one column and it must be defined as a key.

Does that help?

---

chris wrote:

Shaiss: you have an old version. Please download the nightly build. It will fix other issues as well.

Chris,

How old is old?  I am trying to install 0.4.6 and am receiving the same problem.  I'm on PHP 5.0.4 and MySQL 4.1.12.  This is a Fedora Core 4 box that I administer myself.  Thanks in advance for any help.

Kind regards,
Justis

---

Ouch*

Yes it looks like all your issues could be addressed by downloading the nightly build.
So much time has been spent working on php5 compatibility and performance, lately, that we have not had a chance to release 0.4.7 yet.

The nightly build can be found here: www.nextbbs.com/do_page_n_downloads

---