Elxis CMS Forum
Extensions => Components => Topic started by: StefanSultanov on January 25, 2012, 18:54:45
-
:)
I've been trying to install a marketplace extension for one of my Elxis sites.
There are currently 2 plugins available and both show the same SQL ERROR message:
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 'TYPE=MyISAM DEFAULT CHARSET=utf8' at line 37
SQL =
CREATE TABLE IF NOT EXISTS `elx_marketplace_categories` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`parent` INTEGER UNSIGNED DEFAULT '0',
`namedialect1` VARCHAR(180) DEFAULT NULL,
`namedialect2` VARCHAR(180) DEFAULT NULL,
`namedialect3` VARCHAR(180) DEFAULT NULL,
`namedialect4` VARCHAR(180) DEFAULT NULL,
`descriptiondialect1` VARCHAR(250) DEFAULT NULL,
`descriptiondialect2` VARCHAR(250) DEFAULT NULL,
`descriptiondialect3` VARCHAR(250) DEFAULT NULL,
`descriptiondialect4` VARCHAR(250) DEFAULT NULL,
`image` VARCHAR(250) DEFAULT NULL,
`image2` VARCHAR(250) DEFAULT NULL,
`has_entries` TINYINT(4) DEFAULT '0',
`sort_order` INTEGER DEFAULT '0',
`use_paid_ads` TINYINT(1) DEFAULT '-1',
`overwrite_paid_ads_price_basic` TINYINT(1) DEFAULT '0',
`paid_ads_price_basic` FLOAT( 9,2) DEFAULT 0,
`overwrite_paid_ads_price_top` TINYINT(1) DEFAULT '0',
`paid_ads_price_top` FLOAT( 9,2) DEFAULT 0,
`overwrite_paid_ads_price_featured` TINYINT(1) DEFAULT '0',
`paid_ads_price_featured` FLOAT( 9,2) DEFAULT 0,
`overwrite_paid_ads_price_commercial` TINYINT(1) DEFAULT '0',
`paid_ads_price_commercial` FLOAT( 9,2) DEFAULT 0,
`ad_default` TINYINT(1) DEFAULT '-1',
`published` TINYINT(1) DEFAULT 0,
PRIMARY KEY (`id`),
KEY `marketplace_categories_parent` (`parent`),
KEY `marketplace_categories_sort_order` (`sort_order`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
Now I'm sure, that there is nothing wrong with the plugins, because they both display the same SQL Error number.
Just called my hosting support and they suggested that I should replace
'TYPE=MyISAM DEFAULT CHARSET=utf8' with 'ENGINE=MyISAM DEFAULT CHARSET=utf8'
I opened all PHP files inside com_marketplace_0_4_6_21_elxis.zip and I couldn't findany portion of that in the code.
I'm not a coder, but if someone can give me instructions I can follow.
Thanks!
What can I do to work around this?
-
you find the code in the
martketplace.xml
unpack in local the zip file,
open marketplace.xml and replace TYPE with ENGINE at the lines: 145, 230, 308, 409, 449, 489
when y finished zip all files and reinstall.
before to reinstall, make sure to uninstall marketplace and after check on server if exist these folders:
administrator/components/com_marketplace
components/com_marketplace
if yes, delete them
after install the package
tell me if works and wich version of mysql u have, so i try on my pc and i fix the package.
-
:)
There is one more instance on line 463.
I'll replace it too.
Will be back with the required info after installing the component.
Thank you!
-
:)
Currently running on PHP 5.3 and MySQL 5.1
Installed OK after changes in marketplace.xml
I tried to install Primezilla and I got the following error:
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 'TYPE=MYISAM' at line 10
SQL =
CREATE TABLE IF NOT EXISTS `elx_primezilla_preferences` (
`id` INTEGER UNSIGNED NOT NULL,
`msgs_per_page` INTEGER UNSIGNED NOT NULL DEFAULT 20,
`use_signature` TINYINT(1) DEFAULT 0,
`use_signature_for_replies` TINYINT(1) DEFAULT 0,
`signature` TEXT,
`use_email_notification` TINYINT(1) DEFAULT 1,
PRIMARY KEY (`id`)
) TYPE=MYISAM;
This is the same error (same number) and I did the same replace:
'TYPE=MYISAM' to 'ENGINE=MYISAM'
Lines 286, 323 and 424.
And it worked.
Thank you very much!
Cheers!