Aw: JInstaller: :Install: Error SQL DB function failed with error number 1064
I am hitting a similar error too! Error message is as follows. (Stock Joomla 1.6 version installed & this was my first time installing JoomShopping v3.0).
JDatabaseMySQL::query: 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 'TYPE=MyISAM' at line 16 SQL=CREATE TABLE IF NOT EXISTS `jos_jshopping_categories` ( `category_id` int(11) NOT NULL auto_increment, `category_image` varchar(255) default NULL, `category_parent_id` int(11) NOT NULL default '0', `category_publish` tinyint(1) unsigned NOT NULL default '1', `category_ordertype` tinyint(1) unsigned NOT NULL default '1', `category_template` varchar(64) default NULL, `category_ordering` int(3) NOT NULL default '0', `products_sorting` varchar(32) default NULL, `products_sorting2` varchar(32) default NULL, `category_add_date` datetime default '0000-00-00 00:00:00', `products_page` int(11) NOT NULL default '10', `products_row` int(11) NOT NULL default '0', PRIMARY KEY (`category_id`), KEY `sort_add_date` (`category_add_date`) ) TYPE=MyISAM;
Return to Control Panel
Call stack
# Function Location
1 JAdministrator->dispatch() C:\wamp\www\monsterkhoj\administrator\index.php:47
2 JComponentHelper::renderComponent() C:\wamp\www\monsterkhoj\administrator\includes\application.php:154
3 require_once() C:\wamp\www\monsterkhoj\libraries\joomla\application\component\helper.php:152
4 JController->execute() C:\wamp\www\monsterkhoj\administrator\components\com_installer\installer.php:24
5 InstallerControllerInstall->install() C:\wamp\www\monsterkhoj\libraries\joomla\application\component\controller.php:649
6 InstallerModelInstall->install() C:\wamp\www\monsterkhoj\administrator\components\com_installer\controllers\install.php:31
7 JInstaller->install() C:\wamp\www\monsterkhoj\administrator\components\com_installer\models\install.php:114
8 JInstallerComponent->install() C:\wamp\www\monsterkhoj\libraries\joomla\installer\installer.php:390
9 JInstaller->parseSQLFiles() C:\wamp\www\monsterkhoj\libraries\joomla\installer\adapters\component.php:344
10 JDatabaseMySQL->query() C:\wamp\www\monsterkhoj\libraries\joomla\installer\installer.php:784
11 JError::raiseError() C:\wamp\www\monsterkhoj\libraries\joomla\database\database\mysql.php:208
12 JError::raise() C:\wamp\www\monsterkhoj\libraries\joomla\error\error.php:179
Joomla: 1.6.1
JoomShopping: 3.0