I have allmost the same problem. Centos 5.0 latest mysql.
SQL-query:
CREATE TABLE ubbt_links_links(
lid int( 11 ) NOT NULL AUTO_INCREMENT ,
cat_id int( 11 ) default NULL ,
approved tinyint( 4 ) NOT NULL default '1',
title varchar( 100 ) NOT NULL default '',
url varchar( 100 ) NOT NULL default '',
description text NOT NULL ,
date_added int( 11 ) unsigned NOT NULL default '0',
name varchar( 100 ) NOT NULL default '',
email varchar( 100 ) NOT NULL default '',
hits int( 11 ) NOT NULL default '0',
user_number int( 11 ) NOT NULL default '0',
memberchar( 2 ) NOT NULL default '',
linkratingsummary double( 6, 4 ) NOT NULL default '0.0000',
totalvotes int( 11 ) NOT NULL default '0',
PRIMARY KEY ( lid )
) CREATE TABLE ubbt_links_categories(
cat_id int( 11 ) NOT NULL AUTO_INCREMENT ,
parent_id int( 11 ) default NULL ,
title varchar( 50 ) NOT NULL default '',
cat_desc varchar( 60 ) default NULL ,
cat_order tinyint( 10 ) NOT NULL default '0',
PRIMARY KEY ( cat_id )
) CREATE TABLE ubbt_links_favorites(
num int( 9 ) unsigned NOT NULL AUTO_INCREMENT ,
lid int( 9 ) unsigned NOT NULL default '0',
uid int( 9 ) unsigned NOT NULL default '0',
PRIMARY KEY ( num ) ,
KEY FAV_indx1( uid )
)
MySQL retourneerde:
#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 'CREATE TABLE ubbt_links_categories
(
cat_id int(11) NOT NULL auto_inc' at line 21
Last edited by mikey81; 09/25/2007 1:22 PM.