I tried to create the table, following the precise instructions in the taxonomy_block.mysql file and received the following error.

CREATE TABLE `taxonomy_block` (
`description` VARCHAR( 100 ) DEFAULT 'Default' NOT NULL ,
`teaser` INT( 10 ) UNSIGNED DEFAULT 'Default ''0''' NOT NULL ,
`name` VARCHAR( 100 ) DEFAULT 'Default' NOT NULL ,
`length` INT( 10 ) UNSIGNED DEFAULT 'Default ''1''' NOT NULL ,
`bid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`type` ENUM DEFAULT 'Default' NOT NULL ,
`tid` INT( 10 ) UNSIGNED DEFAULT 'Default' NOT NULL ,
PRIMARY KEY ( `bid` )
) COMMENT = 'SELECT * FROM taxonomy_block'

MySQL said: Documentation
#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 'DEFAULT 'Default' NOT NULL, `tid` INT(10) UNSIGNED DEFAULT 'Def

I tried entering variants, such as changing the "Default '0'" to "Default". When that didn't work, I tried leaving the field blank. All attempts gave me the same results.

Deborah

Comments

crunchywelch’s picture

crunchywelch commented
Assigned: Unassigned » crunchywelch

I've updated the mysql file in the 4.5 branch, you can use the version in cvs or wait for the new tarball to be built (probably 24 hours).

Thanks!

Mad Maks’s picture

Mad Maks commented

i got still a error...

 SQL-query : 

CREATE TABLE taxonomy_block(
description varchar( 100 ) NOT NULL default '',
teaser int( 10 ) unsigned NOT NULL default '0',
name varchar( 100 ) NOT NULL default '',
length int( 10 ) unsigned NOT NULL default '1',
bid int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
TYPE enum( 'vocabulary', 'term' ) NOT NULL default 'vocabulary',
tid int( 10 ) unsigned NOT NULL default '0',
PRIMARY KEY ( 'bid' )
)

MySQL retourneerde:
#1064 - You have an error in your SQL syntax near ''bid'  )  )' at line 8
shane birley’s picture

shane birley commented

I just attempted it with the CVS version and received this error. I don't see anything wrong with the code, so, I am mystified. But, no expert either..

#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 ''bid')
)' at line 9

shane birley’s picture

shane birley commented

Ah-ha!

Quotes are wrong on 'bid'.

CREATE TABLE taxonomy_block (
description varchar(100) NOT NULL default '',
teaser int(10) unsigned NOT NULL default '0',
name varchar(100) NOT NULL default '',
length int(10) unsigned NOT NULL default '1',
bid int(10) unsigned NOT NULL auto_increment,
type enum('vocabulary','term') NOT NULL default 'vocabulary',
tid int(10) unsigned NOT NULL default '0',
PRIMARY KEY ( `bid` )
);

crunchywelch’s picture

crunchywelch commented

Yes, sorry, it is true. Fixed in cvs now....

Mad Maks’s picture

Mad Maks commented

The tabel is fixed now, thanks. but now i have this error:

user error: You have an error in your SQL syntax near ') AND n.status = 1 ORDER BY sticky DESC, created DESC LIMIT 10' at line 1 query: SELECT DISTINCT(n.nid), n.title, n.body FROM node n INNER JOIN term_node r ON n.nid = r.nid WHERE r.tid IN () AND n.status = 1 ORDER BY sticky DESC, created DESC LIMIT 10 in /var/www/floor/includes/database.mysql.inc on line 125.

:-(

Anonymous’s picture

(not verified) commented