Joomla Templates Club 406,261 posts

[heyray Friend heyrayJoin date: September 2011Posts: 6Downloads:0Uploads:4 Thanks: 2]

#169891

This site based on
———————————–
Joomla 1.5.23 stable
SQL 5.5.8
PHP 5.35
Apache 2.2.17
———————————–
when Ｉ　install the ja-comment component it showed as below :

JInstaller::install: 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 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 `ayd_jacomment_configs` — CREATE TABLE IF NOT EXISTS `ayd_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 `ayd_jacomment_configs`
—

CREATE TABLE IF NOT EXISTS `ayd_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 or missing or unreadable SQL 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 `ayd_jacomment_configs` — CREATE TABLE IF NOT EXISTS `ayd_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 `ayd_jacomment_configs`
—

CREATE TABLE IF NOT EXISTS `ayd_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 ;

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#420611

Hi,
Could you please provide us your backend access and phpmyadmin information ?
Please edit your first post and fill these information into the private place.
Thanks
Viet Vu.

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#420613

Hi
Actually you can ref this video tut : http://www.joomlart.com/forums/showthread.php?goto=newpost&t=63958-How%20to%20solve%20JA%20Voice%20install%20with%20mysql%20errors
By this way you can solve your issue by self 🙂

[Author]

Posts