FANTASTIC!!! I'm sooo glad you figured it out. That is so strange though how the XOOPS scripts caused the problem.

Ah, well, thankfully you're up and running.

Cheers
dkeir

Quote:

Hi Deepy,

Xoops rolls back quite nicely after a failed install so any tables that are created will automatically get removed.

I have been able to get my hands on MySql-4.0.20 and everything installed perfectly. I have been unable to find 4.0.18 however I cannot imagine that it's too different from 4.0.20.

Is it possible for you to upgrade your MySql, preferrably to 4.1 or higher?

Cheers

Hi Deepy,

I've tried XOOPS 2.2.3 and on 2.2.4 and everything installed fine for me. I've have a couple of servers with MySql 3.23 and 4.1 and have had no problems with either. I still need to try MySql 4.0.

I'm still sure it's MySql coz the error you've got happens at around line 197 or 198 of the ./zentrack/sql/mysql.sql which means that at least another 11 tables have already been created.

It's weird, this is the CREATE statement that you're experiencing problems with:


create table zentrack_preferences (
user_id int(12) not null default '0',
prefname varchar(25),
prefval varchar(50),
index (user_id)
) type=myisam;


but there's nothing wrong with it as far as I can see (maybe someone else out there knows something different???)

As I said, I'll try and test 4.0 MySQL just to make sure something isn't different about that particular version.

If you are able, could you please try creating that table manually using the syntax above (using phpmyadmin or something), and also remove that section from ./zentrack/sql/mysql.sql and rerun the install to see if anything else falls over.

Cheers
Duncs