Marketplace SQL problem [SOLVED]

[StefanSultanov]

 
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?

[speck]

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.

[StefanSultanov]

 
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!

[StefanSultanov]

 
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!