I was trying to install getting the following notice in Joomla-Backend:
QUOTE:
SQL Error DB function failed with error number 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=238' at line 16 SQL=CREATE TABLE IF NOT EXISTS `hin_aw_ext` ( `id` int(11) NOT NULL auto_increment, `extension` varchar(10) NOT NULL, `price` varchar(10) NOT NULL, `server` varchar(50) NOT NULL, `notfound` varchar(30) NOT NULL, `incomponent` tinyint(1) NOT NULL default '0', `checkedc` tinyint(1) NOT NULL default '0', `orderingc` int(11) NOT NULL default '0', `inmodule` tinyint(1) NOT NULL default '0', `checked` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `registerP` tinyint(1) NOT NULL default '1', `published` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=238;
SQL =
CREATE TABLE IF NOT EXISTS `hin_aw_ext` (
`id` int(11) NOT NULL auto_increment,
`extension` varchar(10) NOT NULL,
`price` varchar(10) NOT NULL,
`server` varchar(50) NOT NULL,
`notfound` varchar(30) NOT NULL,
`incomponent` tinyint(1) NOT NULL default '0',
`checkedc` tinyint(1) NOT NULL default '0',
`orderingc` int(11) NOT NULL default '0',
`inmodule` tinyint(1) NOT NULL default '0',
`checked` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`registerP` tinyint(1) NOT NULL default '1',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=238;
The Database Prefix is different from _jos. Might that be the problem?
- Joomla 1.0.15
Thanks for an answer,
Carbonero