The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 8 posts ] 
Author Message
PostPosted: Thu Feb 17, 2011 2:08 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Feb 17, 2011 5:54 am
Posts: 13
hello,
when trying to install easybookreloaded_v2.0.8.1 onto my Joomla 1.5.22 CN version I get the following DB error message and installation is aborted.

Details:(i use wampserver2)
PHP version: 5.2.11
Web Server: Apache/2.2.17
mySQL 5.5.8
Joomla version: 1.5.22 (has been translated into Chinese)
Quote:

* 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' at line 20 SQL=CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL auto_increment, `gbip` varchar(15) NOT NULL default '', `gbname` varchar(40) NOT NULL default '', `gbmail` varchar(60) default NULL, `gbmailshow` tinyint(1) NOT NULL default '0', `gbloca` varchar(50) default NULL, `gbpage` varchar(150) default NULL, `gbvote` int(10) default NULL, `gbtext` text NOT NULL, `gbdate` datetime default NULL, `gbcomment` text, `published` tinyint(1) NOT NULL default '0', `gbicq` varchar(20) default NULL, `gbaim` varchar(50) default NULL, `gbmsn` varchar(50) default NULL, `gbyah` varchar(50) default NULL, `gbskype` varchar(50) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_easybook` (
`id` int(10) NOT NULL auto_increment,
`gbip` varchar(15) NOT NULL default '',
`gbname` varchar(40) NOT NULL default '',
`gbmail` varchar(60) default NULL,
`gbmailshow` tinyint(1) NOT NULL default '0',
`gbloca` varchar(50) default NULL,
`gbpage` varchar(150) default NULL,
`gbvote` int(10) default NULL,
`gbtext` text NOT NULL,
`gbdate` datetime default NULL,
`gbcomment` text,
`published` tinyint(1) NOT NULL default '0',
`gbicq` varchar(20) default NULL,
`gbaim` varchar(50) default NULL,
`gbmsn` varchar(50) default NULL,
`gbyah` varchar(50) default NULL,
`gbskype` varchar(50) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;

* 组件 安装: SQL error or lost or SQL cannot be read 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 20 SQL=CREATE TABLE IF NOT EXISTS `jos_easybook` ( `id` int(10) NOT NULL auto_increment, `gbip` varchar(15) NOT NULL default '', `gbname` varchar(40) NOT NULL default '', `gbmail` varchar(60) default NULL, `gbmailshow` tinyint(1) NOT NULL default '0', `gbloca` varchar(50) default NULL, `gbpage` varchar(150) default NULL, `gbvote` int(10) default NULL, `gbtext` text NOT NULL, `gbdate` datetime default NULL, `gbcomment` text, `published` tinyint(1) NOT NULL default '0', `gbicq` varchar(20) default NULL, `gbaim` varchar(50) default NULL, `gbmsn` varchar(50) default NULL, `gbyah` varchar(50) default NULL, `gbskype` varchar(50) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_easybook` (
`id` int(10) NOT NULL auto_increment,
`gbip` varchar(15) NOT NULL default '',
`gbname` varchar(40) NOT NULL default '',
`gbmail` varchar(60) default NULL,
`gbmailshow` tinyint(1) NOT NULL default '0',
`gbloca` varchar(50) default NULL,
`gbpage` varchar(150) default NULL,
`gbvote` int(10) default NULL,
`gbtext` text NOT NULL,
`gbdate` datetime default NULL,
`gbcomment` text,
`published` tinyint(1) NOT NULL default '0',
`gbicq` varchar(20) default NULL,
`gbaim` varchar(50) default NULL,
`gbmsn` varchar(50) default NULL,
`gbyah` varchar(50) default NULL,
`gbskype` varchar(50) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;




Do you have an idea what is wrong?


Top
 Profile  
 
PostPosted: Thu Feb 17, 2011 2:11 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Thu Aug 18, 2005 7:13 am
Posts: 16539
Mysql version is too high for the sql in that extension. If you exchange TYPE=MyISAM by ENGINE=MyISAM in the extension sql file, then try again. You will have to open the extension zip file for that, find the sql file, edit it and save the zip file again.

_________________
Joomla forum global moderator.

Have fun


Top
 Profile  
 
PostPosted: Thu Feb 17, 2011 2:30 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Feb 17, 2011 5:54 am
Posts: 13
Tonie wrote:
Mysql version is too high for the sql in that extension. If you exchange TYPE=MyISAM by ENGINE=MyISAM in the extension sql file, then try again. You will have to open the extension zip file for that, find the sql file, edit it and save the zip file again.



thank you for your suggestion
i got your point, this must be right
but i am still fail when amend both sql files install.nonutf8.sql, install.sql
let me check again


Top
 Profile  
 
PostPosted: Wed Dec 21, 2011 3:26 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Mar 28, 2011 2:43 pm
Posts: 12
Hi,

Thanks, Tonie.

I searched far and wide for a solution. This one worked like charm.

:)

_________________
Francois du Toit
Webpreneur
Latest Niche Site: http://www.health2u.co.za/during-pregnancy
http://www.ezywebsites.co.za


Top
 Profile  
 
PostPosted: Mon Nov 05, 2012 1:30 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Sep 17, 2009 11:30 am
Posts: 4
Winner.
That worked perfectly.

Thanks Tonie.


Top
 Profile  
 
PostPosted: Thu Jul 25, 2013 1:53 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Jul 15, 2007 7:28 pm
Posts: 23
Want to run an extension designed for PHP for on a server with PHP 5? This is the fix for you!


Top
 Profile  
 
PostPosted: Sun Jan 26, 2014 2:40 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Jan 26, 2014 2:24 pm
Posts: 3
Hello, getting error while trying to install component in joomla 2.5 What is wrong with syntax??Please help Friends. :(
versions:
php : 5.4.12
MySql : 5.6.12
Apache : 2.4.4

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 ''id' INT(11), 'user_id' int(10) not null, 'msg' text, 'date_time' timestamp n' at line 2 SQL=create table if not exists #_openchat_msg( 'id' INT(11), 'user_id' int(10) not null, 'msg' text, 'date_time' timestamp not null default CURRENT_TIMESTAMP)ENGINE = MyISAM;
SQL =
create table if not exists #_openchat_msg(
'id' INT(11),
'user_id' int(10) not null,
'msg' text,
'date_time' timestamp not null default CURRENT_TIMESTAMP)ENGINE = MyISAM;
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 ''id' INT(11), 'user_id' int(10) not null, 'msg' text, 'date_time' timestamp n' at line 2 SQL=create table if not exists #_openchat_msg( 'id' INT(11), 'user_id' int(10) not null, 'msg' text, 'date_time' timestamp not null default CURRENT_TIMESTAMP)ENGINE = MyISAM;
SQL =
create table if not exists #_openchat_msg(
'id' INT(11),
'user_id' int(10) not null,
'msg' text,
'date_time' timestamp not null default CURRENT_TIMESTAMP)ENGINE = MyISAM;


Top
 Profile  
 
PostPosted: Sun Jan 26, 2014 9:48 pm 
User avatar
Joomla! Champion
Joomla! Champion

Joined: Sat Aug 16, 2008 1:46 pm
Posts: 5835
Location: the Bat Cave
@ Preet1991
I note in your query;
Code:
create table if not exists #_openchat_msg(
'id' INT(11),
'user_id' int(10) not null,
'msg' text,
'date_time' timestamp not null default CURRENT_TIMESTAMP)ENGINE = MyISAM;

this is in caps;
Code:
'id' INT(11),

whereas this is not;
Code:
'user_id' int(10)

Could the INT in caps be the problem?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 



Who is online

Users browsing this forum: avatiatelecom, Google [Bot] and 21 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group