[MySQL][PHP]Skrypt nie tworzy mi tabel Opcje

[Raven1122]

Witam, mam taki kod:

[PHP] pobierz, plaintext 
<?php
connect();
$sql = "CREATE TABLE  `" . $prefix . "settings`(
`title` varchar(500) NOT NULL,
`keywords` LONGTEXT NOT NULL,
`description` LONGTEXT NOT NULL,
`newsperpage` int(11) NOT NULL,
`newstitlecolor` varchar(255) NOT NULL,
`newscontentcolor` varchar(255) NOT NULL,
`newsseparator` varchar(255) NOT NULL,
)";
$query = mysql_query($sql) or die(mysql_error());
echo("Dodawanie tabeli " . $prefix . "settings .....Wykonano");
 
$sql = "CREATE TABLE `" . $prefix . "news`(
`id` int(11) NOT NULL auto_increment,
`title` varchar(1000) NOT NULL,
`info` varchar(500) NOT NULL,
`content` LONGTEXT NOT NULL,
PRIMARY KEY(id))";
$query = mysql_query($sql) or die(mysql_error());
echo("Dodawanie tabeli " . $prefix . "news .....Wykonano");
 
 
$sql = "CREATE TABLE  `" . $prefix . "menubar`(
`position` int(3) NOT NULL,
`title` varchar(500) NOT NULL,
`link` varchar(1000) NOT NULL,
)";
$query = mysql_query($sql) or die(mysql_error());
echo("Dodawanie tabeli " . $prefix . "menubar .....Wykonano");
 
 
$sql = "CREATE TABLE  `" . $prefix . "views`(
`views` int(11) NOT NULL
)";
$query = mysql_query($sql) or die(mysql_error());
echo("Dodawanie tabeli " . $prefix . "views .....Wykonano");
 
$sql = "CREATE TABLE  `" . $prefix . "users`(
`id` int(11) NOT NULL auto_increment,
`login' varchar(255) NOT NULL,
`password` varchar(1000) NOT NULL,
`email` varchar(500) NOT NULL,
`joindate` DATETIME NOT NULL,
`lastlogin` DATETIME NOT NULL,
`lastactivity` DATETIME NOT NULL,
`activated` int(1) NOT NULL,
`activationkey` varchar(255) NOT NULL,
`rights` int(2) NOT NULL,
PRIMARY KEY(id))";
$query = mysql_query($sql) or die(mysql_error());
echo("Dodawanie tabeli " . $prefix . "users .....Wykonano");
?>
[PHP] pobierz, plaintext 

i nie tworzy mi on tabel,
Funkcja connect to :

[PHP] pobierz, plaintext 
<?php
require_once("../config.php");
 
function connect(){
	$link = @mysql_connect ($host, $user, $password);
    @mysql_select_db($name);
    @mysql_query('SET NAMES \'utf8\'');
    @mysql_query("SET NAMES utf8");
    @mysql_query("SET CHARACTER SET utf8");
    @mysql_query("SET collation_connection = utf8_polish_ci");
}
?>
[PHP] pobierz, plaintext 

no i plik config:

[PHP] pobierz, plaintext 
<?php
$host = "localhost";
$user = "xxx";
$name = "xxx";
$password = "xxx";
$prefix = "tabela_";
?>
[PHP] pobierz, plaintext 

polaczenie na pewno jest nawiazane, wyskakuja mi komunikatu o wykonaniu, a ponad to nie dodaje tabeli, dlaczego?

Ten post edytował Raven1122 9.04.2012, 14:12:17

[Raven1122]

var dump wyplul:

[PHP] pobierz, plaintext 
string 'CREATE TABLE  `guestbook_settings`(
 
`title` varchar(500) NOT NULL,
 
`keywords` LONGTEXT NOT NULL,
 
`description` LONGTEXT NOT NULL,
 
`newsperpage` int(11) NOT NULL,
 
`newstitlecolor` varchar(255) NOT NULL,
 
`newscontentcolor` varchar(255) NOT NULL,
 
`newsseparator` varchar(255) NOT NULL,
 
)' (length=291)
[PHP] pobierz, plaintext 

wiec ze zmienna prefix wszystko ok


prefix to guestbook poniewaz mam instalator skryptu i w configu sie zapisuje to co wpisze w pola

no i blad z phpmyadmin
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 17

Ten post edytował Raven1122 9.04.2012, 18:02:57