2005/6/11 22:46
Burnout-BR
Just popping in
Posts: 34
Since: 2004/6/15
Error SQL-query: CREATE TABLE lordem_avatar(avatar_id mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,avatar_file varchar( 30 ) collate utf8_general_ci NOT NULL default '',avatar_name varchar( 100 ) collate utf8_general_ci NOT NULL default '',avatar_mimetype varchar( 30 ) collate utf8_general_ci NOT NULL default '',avatar_created int( 10 ) NOT NULL default '0',avatar_display tinyint( 1 ) unsigned NOT NULL default '0',avatar_weight smallint( 5 ) unsigned NOT NULL default '0',avatar_type char( 1 ) collate utf8_general_ci NOT NULL default '',PRIMARY KEY ( avatar_id ) ,KEY avatar_type( avatar_type, avatar_display ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci
2005/6/11 22:49
jdseymour
Friend of XOOPS
Posts: 3782
Since: 2004/11/11
2005/6/11 22:53
2005/6/11 23:01
2005/6/11 23:02
wcrwcr
Home away from home
Posts: 1114
Since: 2003/12/12
2005/6/12 8:08
2005/6/13 6:21
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_general_ci NOT NULL default '', `avatar_name`
2005/6/13 7:50
2005/6/14 0:42
2005/6/14 2:42
Advanced Search
385 user(s) are online (90 user(s) are browsing Support Forums)
Members: 0
Guests: 385