Page 3 of 3

Re: Installation DB syntax error *SOLVED*

Posted: Sat Apr 16, 2011 6:18 am
by Leaf
Drakkheim's attached file worked for me as well! Thanks Tons!




:)

Re: Installation DB syntax error *SOLVED*

Posted: Tue Apr 26, 2011 5:08 pm
by oscarhf
Gracias pero se debe cambiar es en el joomla.sql!! y perfecto!!!!!

Re: Installation DB syntax error *SOLVED*

Posted: Tue Apr 26, 2011 7:40 pm
by Yuut
buh I guess it's absolutely necessary to run WAMP 2.0, I was running XAMPP didn't get it working

thanx for the solution btw

Re: Installation DB syntax error *SOLVED*

Posted: Mon May 02, 2011 9:30 pm
by Teclis16
I'm using Drakheims file, but still get this error:

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 AUTO_INCREMENT=5 COMMENT='Holds all the user groups'' at line 6 SQL=CREATE TABLE `jos_vm_auth_group` ( `group_id` int(11) NOT NULL auto_increment, `group_name` varchar(128) default NULL, `group_level` int(11) default NULL, PRIMARY KEY (`group_id`) ) TYPE=MyISAM AUTO_INCREMENT=5 COMMENT='Holds all the user groups'

any ideas

Re: Installation DB syntax error *SOLVED*

Posted: Tue May 10, 2011 1:37 pm
by dpacadmin
Change TYPE=MyISAM to ENGINE=MyISAM in your sql file.

Re: Installation DB syntax error *SOLVED*

Posted: Sat May 14, 2011 7:39 pm
by prashantbala
Actually installing the latest verison of Wampserver solved this error

Re: Installation DB syntax error *SOLVED*

Posted: Wed May 25, 2011 8:58 pm
by serendipitytech
Chalk another one up to solved by Drakkheim's file.

Thanks!

Re: Installation DB syntax error *SOLVED*

Posted: Sat May 28, 2011 5:32 pm
by rejith
Drakkheim wrote:9Iceman's copy paste fix worked for me.

I've attached my 1.5.22 joomla install sql in a zip .
Thanks friend. This one worked fine for me.

Re: Installation DB syntax error *SOLVED*

Posted: Sat Jul 02, 2011 12:43 pm
by reesedesign
none of the find and replace text fixes worked for me, so after much playing around i found uninstalling the new WAMP (2.1a) and installing a previous wampserver (2.0i) and then installing VirtueMart_1.1.8_eCommerceBundle_Joomla_1.5.22 - WORKED PERFECTLY!!

Re: Installation DB syntax error

Posted: Tue Jul 12, 2011 12:01 pm
by kashkhan
It is the BEST fix!

Thanks
hotwired2 wrote:Thanks phuc.  Unfortunately that was not the issue for me.  I tried your mod and still got an error.  So I had to debug the SQL further.  Well I got it working also by changing 'TYPE=MyISAM' to 'ENGINE = MyISAM'.  What threw me off is that my server have MySQL v5.0.18 and 'TYPE=MyISAM' should have worked fine. 

Anyway the sql file that came with the download worked fine by just changing those parameters without your modifications.

Re: Installation DB syntax error *SOLVED*

Posted: Tue Jul 12, 2011 1:57 pm
by Reintje111
dpacadmin wrote:Change TYPE=MyISAM to ENGINE=MyISAM in your sql file.
I cant upload Easybook reloaded as extension not anymore. I ll get an error about mysql

Re: Installation DB syntax error *SOLVED*

Posted: Sat Aug 13, 2011 11:36 pm
by amboshy
great

Re: Installation DB syntax error *SOLVED*

Posted: Thu Aug 25, 2011 8:13 am
by kannansreenivas
As mentioned anove,
This worked for me :
Open "joomla.sql" - from installation/sql/mysql
copy the this text: TYPE=MyISAM CHARACTER SET `utf8`;
with the "joomla.sql" file open got to EDIT- REPLACE and paste the text in to "FIND WHAT"
Then copy this textCHARACTER SET `utf8`; into REPLACE WITH
Hit REPLACE ALL - save the file - and your done.
Thank you for information...

Re: Installation DB syntax error *SOLVED*

Posted: Sun Aug 28, 2011 12:01 pm
by rejith
Drakkheim wrote:9Iceman's copy paste fix worked for me.

I've attached my 1.5.22 joomla install sql in a zip .
This one worked for me. Thanks mate!

Re: Installation DB syntax error *SOLVED*

Posted: Sun Aug 28, 2011 4:50 pm
by Vikula
Wow! This worked for me..First time posting in a forum and It really worked! You rock guys...

Re: Installation DB syntax error *SOLVED*

Posted: Mon Oct 03, 2011 6:54 am
by marehabdallah
i tried all the solution but still getting the following:

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 'textCHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL DEFAULT '', `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` TEXT NOT NULL DEFAULT '', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), INDEX `idx_banner_catid`(`catid`) ) textCHARACTER SET `utf8`

Re: Installation DB syntax error *SOLVED*

Posted: Fri Oct 21, 2011 2:50 pm
by pparmar
Excellent..:)

this work form me appreciate. *****
9Iceman wrote:Try This! It worked for me.

Open "joomla.sql" - from installation/sql/mysql
copy the this text: TYPE=MyISAM CHARACTER SET `utf8`;
with the "joomla.sql" file open got to EDIT- REPLACE and paste the text in to "FIND WHAT"
Then copy this textCHARACTER SET `utf8`; into REPLACE WITH
Hit REPLACE ALL - save the file - and your done.
Close everything and start over, it should work.
PM me if you need further help.

Re: Installation DB syntax error *SOLVED*

Posted: Thu Nov 10, 2011 4:35 pm
by becca-ag
YES! Thank you Drakkheim and phuc!! Replacing those two files worked. Thanks so much, you rock.

Re: Installation DB syntax error *SOLVED*

Posted: Fri Nov 18, 2011 5:26 am
by krekicak
Drakkheim wrote:9Iceman's copy paste fix worked for me.

I've attached my 1.5.22 joomla install sql in a zip .

FINALLY this file solved my problem... TY big time...

Re: Installation DB syntax error *SOLVED*

Posted: Mon Nov 28, 2011 2:23 am
by apc01
Just remove CHARACTER SET UTF-8 , then everything solved!

Re: Installation DB syntax error *SOLVED*

Posted: Sat Dec 31, 2011 9:32 pm
by Fonias
Drakkheim's file worked for me too! Thanx!

Re: Installation DB syntax error *SOLVED*

Posted: Tue Jan 03, 2012 3:58 am
by masternick77
hmm.. I had tried the way phuc had given to us.. but why it still can't work? I've replace joomla_backward.sql with this file but it still didn't succeed.. maybe any suggestions? Anyway, does it relates to the name of the database that we had made? I'm waiting for the reply! Thanks all that made an attention to mine! I'm still new on Joomla! (I'm a six grader in Indonesia), so I need more help from you masters! Thanks a lot!

Re: Installation DB syntax error *SOLVED*

Posted: Tue Jan 03, 2012 4:25 am
by masternick77
Guys, I still had the same problem for the syntax error on the joomla. I've been sure that I've changed the TYPE=MyISAM CHARACTER SET `utf8`; into textCHARACTER SET `utf8`; but still the Joomla Final Installation comes with this:


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 CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL DEFAULT '', `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` TEXT NOT NULL DEFAULT '', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), INDEX `idx_banner_catid`(`catid`) ) TYPE=MyISAM CHARACTER SET `utf8`

If you guys see the text, those are still in TYPE, not TEXT, I wonder why I've replace it but it didn't work. Moreover, is it the error of the XAMPP or my Joomla! ? So for the point, how would we deal with this, is this the error of the LOCALHOST, or the old version, or are there any other replaces?

Plus: I've replace the TYPE, into ENGINE, but it also couldn't work, I've tried all the FIND and REPLACE ways also with removing the DEFAULTS, so guys how must I deal with this?

Though it didn't succeed for me, I thanked you guys that had worked hard to find the solution. I'm waiting for the best solution reply. Thanks! :)

YOU GUYS ROCK! 8)

Re: Installation DB syntax error *SOLVED*

Posted: Wed Jan 04, 2012 10:03 pm
by davidjbrock2
Had this issue too... tried everything on this page, but to no avail. An earlier poster mentioned conflicts with the SQL versions. I didn't uninstall WampServer 2.2, I just added an earlier version of SQL and used that one. Version 5.0.88 worked for me. Don't forget to undo/redo the changes you've made thus far: i.e. copy back the original joomla.sql and joomla_backward.sql from the Joomla build .zip into the mysql folder. Also, since it's a new version of mySQL, you'll have to set up your password and database through phpMyAdmin again. Good luck all.

Re: Installation DB syntax error *SOLVED*

Posted: Fri Jan 06, 2012 5:45 pm
by bukas
I am new to the forum, i have being this problem, i tried all the suggestions on this forum; changing the TYPE to ENGINE, changing the TYPE=MyISAM CHARACTER SET `utf8`; to textCHARACTER SET `utf8`; but none worked until I uninstalled my wamp 2.2a and installed wamp 2.0c which worked perfectly for me.

Therefore i think that wamp2.2a might be having a compatibility problem with joomla 1.5, hence i would rather suggest to anyone having the same problem to do the same. By the way thanks guys for your contributions. You guys rocks!!! :D

Re: Installation DB syntax error *SOLVED*

Posted: Wed Jan 11, 2012 6:47 pm
by janemores
Wow!! Useful :)

Re: Installation DB syntax error *SOLVED*

Posted: Mon Mar 05, 2012 4:07 pm
by 7170
Thanks Drakkheim your file fixed my error!!

Re: Installation DB syntax error *SOLVED*

Posted: Wed May 02, 2012 9:14 pm
by humvee
[Mod Note: Topic locked to prevent further unassociated posts being posted to it. Please start a specific new thread where appropriate and refer back to this one.]