L'aquarium de JMV

Reply to: Table creation failed error after initialising Weather_1.30

[quote=vedrine]Hello,
Did you check before installation that you did have any nuke_wthr_xxx table already in your database ? If yes I don't see what is the the problem.
Unfortunately I don't have mysql v5 installed on any site so I can't test  :( 
$subdivtable is the 4th table to be created in pninit.php. So apparently the 3 first don't give any trouble.
the lines are :
[code]   $sql = "CREATE TABLE $subdivtable (
            $subdivcolumn[subdiv_title] varchar(50),
            $subdivcolumn[subdiv_id] int(4) DEFAULT '0' NOT NULL auto_increment,
            $subdivcolumn[country_id] int(4) NOT NULL,
            PRIMARY KEY(subdiv_id))";
    $dbconn->Execute($sql);
[/code]
So the only diffrence with the other is the use of auto_increment but I fail to see why this could lead to a problem. I will see if I can find anything.
THe very annoying thing for you is that when pninit fails, you have to manualy suppress the tables created if you want to try again because the next time you run pninit it will fail because the tables are already there.[/quote]