JInstaller: :Install: Error SQL DB function failed with error number 1064

22.03.2011 21:02
#1
Buttitta
Joomshopping forum user no avatar
Name: Michael
22.03.2011
Posts: 2
Quote
JInstaller: :Install: Error SQL DB function failed with error number 1064

This is a completely stock standard Joomla install and after logging into the backend for the first time, the first thing I do is try to install JoomShopping.

When I click "Upload and Install" I get a screen of 2 SQL errors (screenshot included).

The only thing I can think that would be different is I have MySQL running on a different server (192.168.1.31 as opposed to apche/php/joomla on 192.168.1.21) instead of the usual default of localhost

I am evaluating this with other cart solutions for joomla 1.6, so thank you for any help.

~Michael Buttitta


Joomla: 1.6.1
JoomShopping: 3.0.0
PHP: 5.3.5
MySQL: 5.0.7
Website Url: internal (not accessable publicly
 
22.03.2011 21:14
#2
spabrai
Joomshopping forum user no avatar
Name: S P
22.03.2011
Posts: 1
Quote
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
 
23.03.2011 07:49
#3
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16514
Quote
Aw: JInstaller: :Install: Error SQL DB function failed with error number 1064

The problem in version MySql.
The in new version of the store, we will correct the error.

now available 2.8.0 Beta for Joomla 1.5
http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/downloads/betaversion.html


Letzte Ă„nderung: 23.03.2011 07:52
 
23.03.2011 18:16
#4
Buttitta
Joomshopping forum user no avatar
Name: Michael
22.03.2011
Posts: 2
Quote
Aw: JInstaller: :Install: Error SQL DB function failed with error number 1064

Yes, that seems to work very well, thank you!

 
29.03.2011 20:38
#5
Baranov
Joomshopping forum user no avatar
Name: Aleksei
28.03.2011
Posts: 1
Quote
Aw: JInstaller: :Install: Error SQL DB function failed with error number 1064

This is not Joomla or MySQL bug.

MySQL 5.5 not support TYPE, use ENGINE
In admin/install/install.sql replace all TYPE -> ENGINE (ENGINE = MyISAM)

And i converted this file from UTF encoding to ANSI.
(in UTF first few bytes have invisible garbage, view it in HEX. And function trim in php, not cleared it.)


I'm sorry, for my bad english:-)

 
Copyrights MAXXmarketing GmbH. All Rights Reserved