منتديات phpBBArabia

كود: تحديد الكل

Error
SQL query: 

CREATE TABLE `phpbb_present` (

`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`userid` int( 8 ) NOT NULL ,
`username` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`usercolor` varchar( 6 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`time` int( 11 ) NOT NULL ,
`text` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`show_or_no` tinyint( 1 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) 
) CHARACTER SET `utf8` COLLATE `utf8_bin` ;



MySQL said:  

#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 'collate utf8_bin NOT NULL,
  `usercolor` varchar(6) character 

كود: تحديد الكل

??? ???
SQL ERROR [ mysql4 ]

Table 'fadiaa_bb3.fadiaa_present' doesn't exist [1146]

SQL

SELECT * FROM fadiaa_present ORDER BY id DESC LIMIT 0,30

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/function_pts.php
LINE: 225
CALL: dbal_mysql->sql_query()

FILE: index.php
LINE: 111
CALL: get_presnts()

كود: تحديد الكل

CREATE TABLE `fadiaa_present` ( 
`id` int( 11 ) NOT NULL AUTO_INCREMENT , 
`userid` int( 8 ) NOT NULL , 
`username` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL , 
`usercolor` varchar( 6 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL , 
`time` int( 11 ) NOT NULL , 
`text` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL , 
`show_or_no` tinyint( 1 ) NOT NULL default '0', 
PRIMARY KEY ( `id` ) 
);

كود: تحديد الكل

Error
SQL query: 

CREATE TABLE `fadiaa_present` (

`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`userid` int( 8 ) NOT NULL ,
`username` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`usercolor` varchar( 6 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`time` int( 11 ) NOT NULL ,
`text` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
`show_or_no` tinyint( 1 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) 
) 

MySQL said:  

#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 'COLLATE utf8_bin NOT NULL , 
`usercolor` varchar( 6 ) CHARACTE 

كود: تحديد الكل

CREATE TABLE `fadiaa_present` ( 
`id` int( 11 ) NOT NULL AUTO_INCREMENT , 
`userid` int( 8 ) NOT NULL, 
`username` varchar( 255 ) NOT NULL , 
`usercolor` varchar( 6 )  NOT NULL , 
`time` int( 11 ) NOT NULL , 
`text` varchar( 255 ) NOT NULL , 
`show_or_no` tinyint( 1 ) NOT NULL default '0', 
PRIMARY KEY ( `id` ) 
)