aparently the IF NOT EXISTS is not doing its job
$vbulletin->db->hide_errors();
$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX ."data_name
(id int(4) NOT NULL auto_increment, table1 varchar(120) NOT NULL, table2 varchar(100)NOT NULL, PRIMARY KEY (id))");
$vbulletin->db->show_errors();
thats how i would run the table..
but also noticed the install code version is 4.0
but your product code is 1.0
im quite sure the the product code needs to be same version or higher to run
the install code, other way around the product ignores the install code higher than
the product version.
try it, its not sure it will work since the IF NOT EXISTS dont check,
it should if the table exist then skip the step.
|