|
|
|
Error SQL
|
|
Date: 2007/10/02 08:35
|
By: hnamnd
|
Status: User
|
|
|
Karma: 0
|
|
Small Heart
| Posts: 5 |   |
|
|
Error
SQL query:
-- --------------------------------------------------------
--
-- Table structure for table 'fnl_profile_general'
--
CREATE TABLE fnl_profile_general(
id int( 7 ) unsigned zerofill NOT NULL AUTO_INCREMENT ,
`timestamp` varchar( 14 ) NOT NULL default '',
`user` int( 7 ) unsigned zerofill NOT NULL default '0000000',
sex int( 1 ) NOT NULL default '0',
country int( 3 ) unsigned zerofill NOT NULL default '000',
city varchar( 255 ) NOT NULL default '',
interested_meet varchar( 50 ) NOT NULL default '',
join_for varchar( 50 ) NOT NULL default '',
ages_between varchar( 50 ) NOT NULL default '',
birthdate varchar( 14 ) NOT NULL default '',
profession varchar( 255 ) NOT NULL default '',
height int( 3 ) unsigned zerofill NOT NULL default '000',
body_type int( 3 ) unsigned zerofill NOT NULL default '000',
ethnic int( 3 ) unsigned zerofill NOT NULL default '000',
hair_color int( 3 ) unsigned zerofill NOT NULL default '000',
hair_style int( 3 ) unsigned zerofill NOT NULL default '000',
eyes int( 3 ) unsigned zerofill NOT NULL default '000',
scene int( 3 ) unsigned zerofill NOT NULL default '000',
out int( 3 ) unsigned zerofill NOT NULL default '000',
dick_size int( 3 ) unsigned zerofill NOT NULL default '000',
circumcision int( 3 ) unsigned zerofill NOT NULL default '000',
body_hair int( 3 ) unsigned zerofill NOT NULL default '000',
orientation int( 3 ) unsigned zerofill NOT NULL default '000',
role int( 3 ) unsigned zerofill NOT NULL default '000',
safe_sex int( 3 ) unsigned zerofill NOT NULL default '000',
smoke int( 3 ) unsigned zerofill NOT NULL default '000',
drink int( 3 ) unsigned zerofill NOT NULL default '000',
drug int( 3 ) unsigned zerofill NOT NULL default '000',
hide_empty int( 3 ) unsigned zerofill NOT NULL default '000',
hide_rather int( 3 ) unsigned zerofill NOT NULL default '000',
view_count int( 7 ) NOT NULL default '0',
PRIMARY KEY ( id ) ,
UNIQUE KEY `user` ( `user` )
) ENGINE = MYISAM ;
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 'out int(3) unsigned zerofill NOT NULL default '000',
dick_size int(3) unsigne' at line 20
Admin Help me now ??
|
|
The administrator has disabled public write access. |
|
 |
|
Re:Error SQL
|
|
Date: 2007/10/27 00:38
|
By: admin
|
Status: Admin
|
|
|
Karma: 1
|
|
Admin
| Posts: 42 | |
|
|
|
please check your mysql version if it's support by our script.
|
|
|
The administrator has disabled public write access. |
|
|
