SQL query:

CREATE TABLE `review` (
`nid` int( 10 ) NOT NULL default '0',
`review_rate` mediumint( 9 ) default '1',
KEY `nid` ( `nid` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1

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 CHARSET=latin1' at line 5

In case anyone else runs across this...

Comments

drewish’s picture

drewish commented

Try deleting the "ENGINE = MYISAM DEFAULT CHARSET = latin1" from the end and re-running it. If that works I'll update the file.

dgeilhufe@yahoo.com’s picture

dgeilhufe@yahoo.com commented

That is exactly how I corrected the error. :)

drewish’s picture

drewish commented
Assigned: Unassigned » drewish
Status: Active » Fixed

Thanks for the bug report. This has been corrected in CVS.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)