-
AuthorPosts
-
May 28, 2011 at 5:31 pm #164553
i have this error while installing ja_comment_component_j16
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 `gp_jacomment_configs` — CREATE TABLE IF NOT EXISTS `gp_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 ;
Component Install: SQL error file 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 `gp_jacomment_configs` — CREATE TABLE IF NOT EXISTS `gp_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 FriendStork11
- Join date:
- March 2011
- Posts:
- 2273
- Downloads:
- 0
- Uploads:
- 142
- Thanks:
- 55
- Thanked:
- 431 times in 393 posts
May 30, 2011 at 10:27 am #393586Hello,
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.
-
AuthorPosts
This topic contains 2 replies, has 2 voices, and was last updated by Stork11 13 years, 6 months ago.
We moved to new unified forum. Please post all new support queries in our New Forum