Hello,
I have installed Gary's Cookbook (Version 2.0) for the first time.
During the install-process I get the error message:
SQL Error DB-Funktion fehlgeschlagen mit Fehler Nummer 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 AUTO_INCREMENT=3' at line 13 SQL=CREATE TABLE `jos_GKB_voting_log` ( `id` int(11) NOT NULL auto_increment, `type` tinyint(3) unsigned NOT NULL default '0', `date` datetime NOT NULL default '2000-01-01 00:00:00', `userid` mediumint(9) NOT NULL default '0', `fileid` int(11) NOT NULL default '0', `value` int(11) NOT NULL default '0', `ipaddress` char(15) NOT NULL default '', UNIQUE KEY `id` (`id`), KEY `userid` (`type`, `userid`), KEY `fileid` (`type`,`fileid`), KEY `ipaddress` (`type`,`ipaddress`,`date`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3
SQL =
CREATE TABLE `jos_GKB_voting_log` (
`id` int(11) NOT NULL auto_increment,
`type` tinyint(3) unsigned NOT NULL
default '0', `date` datetime NOT NULL
default '2000-01-01 00:00:00', `userid`
mediumint(9) NOT NULL default '0',
`fileid` int(11) NOT NULL default '0',
`value` int(11) NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
UNIQUE KEY `id` (`id`), KEY `userid` (`type`,
`userid`), KEY `fileid` (`type`,`fileid`),
KEY `ipaddress` (`type`,`ipaddress`,`date`))
ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=3
The components directories for backend and frontend are created.
I install from a directory from my homepage, because upload & install is not possible, because of safe-mode on.
Can you help me?
Mike
