Joomla Extensions Club 20,483 posts

[psairon Friend psaironJoin date: July 2011Posts: 1Downloads:0Uploads:0]

#166456

hi,
try to installed jacomment and get this

• JInstaller: :Install: Error SQL 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 COLLATE=utf8_general_ci AUTO_INCREMENT=18’ at line 26 SQL=– phpMyAdmin SQL Dump — version 2.10.3 — http://www.phpmyadmin.net — — Host: localhost — Generation Time: Dec 10, 2009 at 02:36 PM — Server version: 5.0.51 — PHP Version: 5.2.6 — — Database: `ja_comment` — — ——————————————————– — — Table structure for table `icd_jacomment_configs` — CREATE TABLE IF NOT EXISTS `icd_jacomment_configs` ( `id` int(11) NOT NULL auto_increment, `group` varchar(100) COLLATE utf8_general_ci COLLATE utf8_general_ci default NULL, `data` text COLLATE utf8_general_ci, PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=18 ;
SQL =
• — phpMyAdmin SQL Dump
• — version 2.10.3
• — http://www.phpmyadmin.net
• —
• — Host: localhost
• — Generation Time: Dec 10, 2009 at 02:36 PM
• — Server version: 5.0.51
• — PHP Version: 5.2.6
•
• —
• — Database: `ja_comment`
• —
•
• — ——————————————————–
•
• —
• — Table structure for table `#__jacomment_configs`
• —
•
•
• CREATE TABLE IF NOT EXISTS `#__jacomment_configs` (
• `id` int(11) NOT NULL auto_increment,
• `group` varchar(100) COLLATE utf8_general_ci COLLATE utf8_general_ci default NULL,
• `data` text COLLATE utf8_general_ci,
• PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=18 ;

[Stork11 Friend Stork11Join date: March 2011Posts: 2273Downloads:0Uploads:142 Thanks: 55 Thanked: 431 times in 393 posts]

#401969

Hello,

You should extract the installation file (the zip file), then replace all strings “TYPE=MyISAM” by “ENGINE=MyISAM” in “admininstallersqlinstall.jacomment.sql” file of installation file.

After that, re-install the JA Component.

Best regards.

[Author]

Posts