CREATE TABLE content_type_storminvoiceitem (
`vid` INT unsigned NOT NULL DEFAULT 0,
`nid` INT unsigned NOT NULL DEFAULT 0,
`field_field1_value` DECIMAL(, ) DEFAULT NULL,
PRIMARY KEY (vid),
INDEX nid (nid)
) DEFAULT CHARACTER SET UTF8

shows me

#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 NULL, PRIMARY KEY (vid), INDEX nid (nid) ) DEFAULT CHARACTER SE' at line 4

how to do?

thank you

CommentFileSizeAuthor
#6 INSTALL.mysql_.txt1.34 KBolobank

Comments

yched’s picture

yched commented
Status: Active » Postponed (maintainer needs more info)

Can you be more specific on the exact steps that lead to this error ?

oib’s picture

oib commented

schema module reports a mismatch
i deleted the table to recreate the table with phpmysql
this was the error message from phpmysql

karens’s picture

karens commented
Status: Postponed (maintainer needs more info) » Closed (won't fix)

Not enough info to do anything with this.

fourmi4x’s picture

fourmi4x commented

Really sorry, I didn't see it was in the CCK category. So I deleted this post.

yched’s picture

yched commented
Issue tags: +upload MySQL

@fourmi4x: this error doesn't seem to be related to CCK in any way.

olobank’s picture

olobank commented
Priority: Normal » Critical
Status: Closed (won't fix) » Active
StatusFileSize
new INSTALL.mysql_.txt1.34 KB

#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 '// $Id: INSTALL.mysql.txt,v 4.1.22 2007/11/19 19:53:51 goba Exp $ CREATE THE ' at line 1

can you help me with the above error that generated while trying to upload my database to phpmyadmin?
i have attached the INSTALLMsql file for your perusal.

yched’s picture

yched commented
Priority: Critical » Normal
Status: Active » Closed (won't fix)

@olobank : it looks like you're trying to run INSTALL.mysql.txt through MySQL. That file is an instruction text file, not an SQL command file.

Your issue is also not in any way related to CCK or the orignal post in this thread, so please don't reopen :-)