Tworzenie tabel, Tworzy tylko 11 tabel Opcje

[Gibcio2009]

Witam !

Posiadam WebServ 2.0, za pomocą PHP tworzę tabele, lecz tworzonych jest tylko 11 z 13, czy ktoś wie jaka jest przyczyna?

Dzięki z góry.

Oto za pomocą czego chcę stworzyć tabele:

[PHP] pobierz, plaintext 
function CreateTable($DBPrefix)
{
        mysql_query("CREATE TABLE ".$DBPrefix."articles (
         `id` INT(11) NOT NULL auto_increment,
         `title` VARCHAR(150) NOT NULL,
         `go` VARCHAR(255) NOT NULL,
         `content` text NOT NULL,
         `author` VARCHAR(25) NOT NULL,
         `read` INT(11) NOT NULL,
         `keywords` VARCHAR(255) NOT NULL,
         PRIMARY KEY(`id`)
         ) TYPE=MyISAM;");
 
         mysql_query("CREATE TABLE ".$DBPrefix."ban (
        `id` INT(11) NOT NULL auto_increment,
        `value` VARCHAR(255) NOT NULL,
        `what` CHAR(1) NOT NULL,
        PRIMARY KEY(`id`)
        ) TYPE=MyISAM;");
 
        mysql_query("CREATE TABLE ".$DBPrefix."banip (
        `id` INT(11) NOT NULL auto_increment,
        `ip` VARCHAR(15) NOT NULL,
        PRIMARY KEY(`id`)
        ) TYPE=MyISAM;");
 
        mysql_query("CREATE TABLE ".$DBPrefix."block (
        `id` INT(11) NOT NULL auto_increment,
        `name` VARCHAR(20) NOT NULL,
        `view` VARCHAR(255) NOT NULL,
        `page` CHAR(1) NOT NULL,
        `position` int(11) NOT NULL,
        `activ` CHAR(1) NOT NULL,
        PRIMARY KEY (`id`)
        ) TYPE=MyISAM;");
 
        mysql_query("CREATE TABLE ".$DBPrefix."config (
        `id` INT(11) NOT NULL auto_increment,
        `name` VARCHAR(20) NOT NULL,
        `value` VARCHAR(255) NOT NULL,
        PRIMARY KEY(`id`)
        ) TYPE=MyISAM;");
 
        mysql_query("CREATE TABLE ".$DBPrefix."download (
         `id` INT(11) NOT NULL auto_increment,
         `title` VARCHAR(255) NOT NULL,
         `info` text NOT NULL,
         `url` VARCHAR(45) NOT NULL,
         `count` INT(11) NOT NULL,
         `file` VARCHAR(255) NOT NULL,
         PRIMAR KEY(`id`)
         ) TYPE=MyISAM;");
 
        mysql_query("CREATE TABLE ".$DBPrefix."langtemp (
        `id` INT(11) NOT NULL auto_increment,
        `name` VARCHAR(255) NOT NULL,
        `type` CHAR(1) NOT NULL,
         PRIMARY KEY(`id`)
         ) TYPE=MyISAM;");
 
         mysql_query("CREATE TABLE ".$DBPrefix."menu (
         `id` INT(11) NOT NULL auto_increment,
         `title` VARCHAR(35) NOT NULL,
         `info` VARCHAR(255) NOT NULL,
         `to` VARCHAR(255) NOT NULL,
         `pozition` INT(11) NOT NULL,
         PRIMARY KEY(`id`)
         ) TYPE=MyISAM;");
 
         mysql_query("CREATE TABLE ".$DBPrefix."modules (
         `id` INT(11) NOT NULL auto_increment,
         `name` VARCHAR(20) NOT NULL,
         PRIMARY KEY(`id`)
         ) TYPE=MyISAM;");
 
         mysql_query("CREATE TABLE ".$DBPrefix."news (
         `id` INT(11) NOT NULL auto_increment,
         `title` VARCHAR(150) NOT NULL,
         `go` VARCHAR(255) NOT NULL,
         `content` text NOT NULL,
         `author` VARCHAR(25) NOT NULL,
         `read` INT(11) NOT NULL,
         `time` VARCHAR(10) NOT NULL,
         PRIMARY KEY(`id`)
         ) TYPE=MyISAM;");
 
         mysql_query("CREATE TABLE ".$DBPrefix."page (
         `id` INT(11) NOT NULL auto_increment,
         `title` VARCHAR(255) NOT NULL,
         `content` VARCHAR(255) NOT NULL,
         `kewords` VARCHAR(255) NOT NULL,
         `description` VARCHAR(255) NOT NULL,
         PRIMARY KEY(`id`)
         ) TYPE=MyISAM;");
 
         mysql_query("CREATE TABLE ".$DBPrefix."team (
         `id` INT(11) NOT NULL auto_increment,
         `name` VARCHAR(25) NOT NULL,
         `email` VARCHAR(255) NOT NULL,
         PRIMARY KEY(`id`)
         ) TYPE=MyISAM;");
 
         mysql_query("CREATE TABLE ".$DBPrefix."users (
         `id` INT(11) NOT NULL auto_increment,
         `name` VARCHAR(255) NOT NULL,
         `login` VARCHAR(255) NOT NULL,
         `password` VARCHAR(255) NOT NULL,
         `email` VARCHAR(255) NOT NULL,
         `gg` VARCHAR(10) NOT NULL,
         `o2` VARCHAR(200) NOT NULL,
         `skype` VARCHAR(200) NOT NULL,
         `city` VARCHAR(200) NOT NULL,
         `site` CHARCHAR(200) NOT NULL,
         `level` CHAR(1) NOT NULL,
         `activ` CHAR(1) NOT NULL,
         `template` VARCHAR(20) NOT NULL,
         `language` VARCHAR(20) NOT NULL,
         `key` VARCHAR(30) NOT NULL,
         PRIMARY KEY(`id`)
         ) TYPE=MyISAM;"); 
}
[PHP] pobierz, plaintext 

Ten post edytował Gibcio2009 15.03.2010, 08:56:17

[phpion]

tworzonych jest tylko 11 z 20, czy ktoś wie jaka jest przyczyna?

20 to ci nigdy nie zrobi, bo masz 13 instrukcji tworzących tabele. Po każdym mysql_query() daj sobie wyświetlenie ewentualnego błędu:

[PHP] pobierz, plaintext 
mysql_query('...') or die(mysql_error());
[PHP] pobierz, plaintext