Joomla Extensions Club 20,483 posts

[Noemi Peli Friend Noemi PeliJoin date: September 2014Posts: 37Downloads:0Uploads:12]

#189072

Hi, I am trying ti install your K2 Search Filter extension. The modul and the plugin successfully installed, but while I installed the component (com_jak2filter.v1.0.7) the following error has accured. Do you have any idea how to solve this?
Thnx,
N

JInstaller: :Telepítés: Hiba SQL Sikertelen adatbázisfunkció, hibaszáma: 1064
A Szintaktikai hiba a ‘USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0’-hez kozeli a 9 sorban SQL=CREATE TABLE IF NOT EXISTS `lym7q_jak2filter_taxonomy` ( `id` int(10) NOT NULL AUTO_INCREMENT, `type` varchar(20) NOT NULL, `title` varchar(255) NOT NULL, `asset_id` int(11) NOT NULL, `option_id` int(5) NOT NULL DEFAULT ‘0’, `num_items` int(8) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `asset_idx` (`asset_id`,`option_id`,`type`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
SQL =

CREATE TABLE IF NOT EXISTS `#__jak2filter_taxonomy` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`type` varchar(20) NOT NULL,
`title` varchar(255) NOT NULL,
`asset_id` int(11) NOT NULL,
`option_id` int(5) NOT NULL DEFAULT ‘0’,
`num_items` int(8) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `asset_idx` (`asset_id`,`option_id`,`type`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

Komponens telepítése: SQL hibafájl Sikertelen adatbázisfunkció, hibaszáma: 1064
A Szintaktikai hiba a ‘USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0’-hez kozeli a 9 sorban SQL=CREATE TABLE IF NOT EXISTS `lym7q_jak2filter_taxonomy` ( `id` int(10) NOT NULL AUTO_INCREMENT, `type` varchar(20) NOT NULL, `title` varchar(255) NOT NULL, `asset_id` int(11) NOT NULL, `option_id` int(5) NOT NULL DEFAULT ‘0’, `num_items` int(8) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `asset_idx` (`asset_id`,`option_id`,`type`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
SQL =

CREATE TABLE IF NOT EXISTS `#__jak2filter_taxonomy` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`type` varchar(20) NOT NULL,
`title` varchar(255) NOT NULL,
`asset_id` int(11) NOT NULL,
`option_id` int(5) NOT NULL DEFAULT ‘0’,
`num_items` int(8) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `asset_idx` (`asset_id`,`option_id`,`type`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

[Thanh Nguyen Viet Friend Thanh Nguyen VietJoin date: September 2014Posts: 1461Downloads:0Uploads:44 Thanked: 258 times in 217 posts]

#499591

Hello marketinggroup,

To resolve this issue, please try to following these steps:

– extracting zip file of JA K2 filter component to one folder on your computer
– in that folder, navigate to the sub folder ‘admin/installer/sql/’, you then see some sql files there
– open the file install.jak2filter.sql file
– find the below sql snippet:

UNIQUE KEY `asset_idx` (`asset_id`,`option_id`,`type`) USING BTREE

– and replace it with

UNIQUE KEY `asset_idx` (`asset_id`,`option_id`,`type`)

once done, you can compress a folder that you extract in first step to zip file again for re-installing.

[Noemi Peli Friend Noemi PeliJoin date: September 2014Posts: 37Downloads:0Uploads:12]

#501777

Hi, unfortunately still doesn’ work, however I’ve tried the recommended steps above. Now the message is: JInstaller: :Installing: Doesn’t find XML install file…
Could you please have a look it or recommend sth else to solve it?
mg

[Thanh Nguyen Viet Friend Thanh Nguyen VietJoin date: September 2014Posts: 1461Downloads:0Uploads:44 Thanked: 258 times in 217 posts]

#501908

Hello marketinggroup,

If possible, send me a PM with Administrator account and FTP account of your site to my inbox. I’ll check and help you to resolve this issue.

[Thanh Nguyen Viet Friend Thanh Nguyen VietJoin date: September 2014Posts: 1461Downloads:0Uploads:44 Thanked: 258 times in 217 posts]

#506808

Hello marketinggroup,

I have just installed the latest version of K2 Filter (1.0.8) into your site, and everything seem works properly now.
Please have a look

[Author]

Posts