Phoca Forum

Hello

I've got a problem to create a new guestbook. I Have read already the information to create some items in the sql Database but the creation of the items failed.

#1064 - You have an error in your SQL syntax near 'CHARACTER SET `utf8`' at line 20

Hier die entsprechende Auszug:

CREATE TABLE `jos_phocaguestbook_items` (

`id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`catid` int( 11 ) NOT NULL default '0',
`sid` int( 11 ) NOT NULL default '0',
`username` varchar( 100 ) NOT NULL default '',
`userid` int( 11 ) NOT NULL default '0',
`email` varchar( 50 ) NOT NULL default '',
`homesite` varchar( 50 ) NOT NULL default '',
`ip` varchar( 20 ) NOT NULL default '',
`title` varchar( 200 ) NOT NULL default '',
`content` text NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint( 1 ) NOT NULL default '0',
`checked_out` int( 11 ) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int( 11 ) NOT NULL default '0',
`params` text NOT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `published` ( `published` )
) TYPE = MYISAM CHARACTER SET `utf8`

Where is the problem. I've got no answer

hmm, I don't know because it works for me??? Which utility did you use for SQL query - phpMyAdmin ?

Which version of database do you have?

I used as written in the user manual the php admin sql, once wirth copy an d once withe the sql install file via uoload.

My databse version is 3.23.58 mysql 3 but I have the possibility to convert it in version 4

Please try it to upgrade to 4 and try it... I added this code in phpMyAdmin (MySQL 5) and everything works ...

Jan

Thanks for the great support. After the upgrade it works!