2
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
