par romantica » 01 nov. 2014, 20:59
par xTG » 01 nov. 2014, 20:53
par romantica » 01 nov. 2014, 20:51
$sqls[$t_areas] = "CREATE TABLE `$t_areas` ( `areaid` smallint unsigned NOT NULL auto_increment, `areaname` varchar(50) NOT NULL default '', `cityid` smallint unsigned NOT NULL default '0', `pos` smallint unsigned NOT NULL default '0', `enabled` enum('0','1') NOT NULL default '0', `timestamp` timestamp(6) NOT NULL, PRIMARY KEY (`areaid`), KEY `pos` (`pos`), KEY `cityid` (`cityid`), KEY `enabled` (`enabled`) ) ENGINE=MyISAM;";
par xTG » 01 nov. 2014, 19:33
par romantica » 01 nov. 2014, 18:33
par xTG » 01 nov. 2014, 18:14
par romantica » 01 nov. 2014, 11:06
par xTG » 31 oct. 2014, 21:34
par romantica » 31 oct. 2014, 21:15
Erreur cr�ation table phpas_adpics - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_ads - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_adxfields - (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 19) Erreur cr�ation table phpas_areas - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_cats - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_cities - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_countries - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_events - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_featured - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_imgcomments - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_imgs - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_ipblock - (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 10) Erreur cr�ation table phpas_ipns - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_online - (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 4) Erreur cr�ation table phpas_options_extended - (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 6) Erreur cr�ation table phpas_options_featured - (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 6) Erreur cr�ation table phpas_payments - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_promos_extended - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_promos_featured - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_subcats - (Too big precision 14 specified for 'timestamp'. Maximum is 6.) Erreur cr�ation table phpas_subcatxfields - (Too big precision 14 specified for 'timestamp'. Maximum is 6.)
par xTG » 31 oct. 2014, 17:08
foreach ($sqls as $t=>$sql) { mysql_query($sql); if(mysql_error()) { if($debug) { echo "<div class=\"err\">Erreur création table $t - (".mysql_error().")</div>"; } $error = 1; } }
par romantica » 31 oct. 2014, 14:28
par xTG » 31 oct. 2014, 14:14
par romantica » 31 oct. 2014, 14:08
par xTG » 31 oct. 2014, 13:52
par romantica » 31 oct. 2014, 12:43