Installation DB syntax error *SOLVED*
Moderator: General Support Moderators
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.
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.
-
- Joomla! Apprentice
- Posts: 6
- Joined: Mon Apr 04, 2011 9:25 pm
Re: Installation DB syntax error *SOLVED*
Drakkheim's attached file worked for me as well! Thanks Tons!
-
- Joomla! Fledgling
- Posts: 1
- Joined: Tue Apr 26, 2011 2:05 pm
Re: Installation DB syntax error *SOLVED*
Gracias pero se debe cambiar es en el joomla.sql!! y perfecto!!!!!
-
- Joomla! Fledgling
- Posts: 1
- Joined: Wed Apr 20, 2011 1:00 pm
Re: Installation DB syntax error *SOLVED*
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
thanx for the solution btw
-
- Joomla! Fledgling
- Posts: 1
- Joined: Mon May 02, 2011 7:42 pm
Re: Installation DB syntax error *SOLVED*
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
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
- dpacadmin
- Joomla! Champion
- Posts: 6029
- Joined: Sat Aug 16, 2008 1:46 pm
- Location: the Bat Cave
- Contact:
Re: Installation DB syntax error *SOLVED*
Change TYPE=MyISAM to ENGINE=MyISAM in your sql file.
-
- Joomla! Apprentice
- Posts: 9
- Joined: Tue Nov 24, 2009 11:31 pm
Re: Installation DB syntax error *SOLVED*
Actually installing the latest verison of Wampserver solved this error
-
- Joomla! Apprentice
- Posts: 7
- Joined: Mon Aug 16, 2010 2:08 pm
Re: Installation DB syntax error *SOLVED*
Chalk another one up to solved by Drakkheim's file.
Thanks!
Thanks!
-
- Joomla! Fledgling
- Posts: 4
- Joined: Sat May 28, 2011 5:18 pm
Re: Installation DB syntax error *SOLVED*
Thanks friend. This one worked fine for me.Drakkheim wrote:9Iceman's copy paste fix worked for me.
I've attached my 1.5.22 joomla install sql in a zip .
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sat Jul 02, 2011 11:39 am
Re: Installation DB syntax error *SOLVED*
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!!
-
- Joomla! Fledgling
- Posts: 1
- Joined: Tue Jul 12, 2011 11:46 am
Re: Installation DB syntax error
It is the BEST fix!
Thanks
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.
-
- Joomla! Apprentice
- Posts: 17
- Joined: Sun Dec 06, 2009 3:22 pm
Re: Installation DB syntax error *SOLVED*
I cant upload Easybook reloaded as extension not anymore. I ll get an error about mysqldpacadmin wrote:Change TYPE=MyISAM to ENGINE=MyISAM in your sql file.
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sat Aug 13, 2011 11:29 pm
- kannansreenivas
- Joomla! Ace
- Posts: 1122
- Joined: Tue Feb 24, 2009 6:29 pm
- Location: Calicut, Kerala, India
- Contact:
Re: Installation DB syntax error *SOLVED*
As mentioned anove,
This worked for me :
This worked for me :
Thank you for information...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.
Kannan Sreenivas ,
Freelance Web Developer , (+917403 00 44 33 )
[email protected]
http://kannansreenivas.elance.com
Freelance Web Developer , (+917403 00 44 33 )
[email protected]
http://kannansreenivas.elance.com
-
- Joomla! Fledgling
- Posts: 4
- Joined: Sat May 28, 2011 5:18 pm
Re: Installation DB syntax error *SOLVED*
This one worked for me. Thanks mate!Drakkheim wrote:9Iceman's copy paste fix worked for me.
I've attached my 1.5.22 joomla install sql in a zip .
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sun Aug 28, 2011 4:36 pm
Re: Installation DB syntax error *SOLVED*
Wow! This worked for me..First time posting in a forum and It really worked! You rock guys...
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sun Oct 02, 2011 4:32 pm
Re: Installation DB syntax error *SOLVED*
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`
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`
-
- Joomla! Fledgling
- Posts: 4
- Joined: Thu Jul 21, 2011 10:06 am
- Location: INDIA
- Contact:
Re: Installation DB syntax error *SOLVED*
Excellent..
this work form me appreciate. *****
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.
-
- Joomla! Fledgling
- Posts: 1
- Joined: Thu Nov 10, 2011 4:20 pm
Re: Installation DB syntax error *SOLVED*
YES! Thank you Drakkheim and phuc!! Replacing those two files worked. Thanks so much, you rock.
-
- Joomla! Fledgling
- Posts: 1
- Joined: Fri Nov 18, 2011 5:08 am
Re: Installation DB syntax error *SOLVED*
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...
-
- Joomla! Fledgling
- Posts: 2
- Joined: Sun Nov 27, 2011 2:46 am
Re: Installation DB syntax error *SOLVED*
Just remove CHARACTER SET UTF-8 , then everything solved!
-
- Joomla! Apprentice
- Posts: 14
- Joined: Mon Nov 16, 2009 1:19 am
- Location: Ελλάδα
- Contact:
Re: Installation DB syntax error *SOLVED*
Drakkheim's file worked for me too! Thanx!
-
- Joomla! Fledgling
- Posts: 2
- Joined: Tue Jan 03, 2012 3:45 am
Re: Installation DB syntax error *SOLVED*
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!
-
- Joomla! Fledgling
- Posts: 2
- Joined: Tue Jan 03, 2012 3:45 am
Re: Installation DB syntax error *SOLVED*
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!
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!
-
- Joomla! Fledgling
- Posts: 1
- Joined: Wed Jan 04, 2012 9:17 pm
Re: Installation DB syntax error *SOLVED*
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.
-
- Joomla! Fledgling
- Posts: 1
- Joined: Thu Jan 05, 2012 11:24 pm
Re: Installation DB syntax error *SOLVED*
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!!!
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!!!
-
- Joomla! Fledgling
- Posts: 1
- Joined: Wed Jan 11, 2012 6:44 pm
- Location: Toronto
- Contact:
Re: Installation DB syntax error *SOLVED*
Wow!! Useful
-
- Joomla! Fledgling
- Posts: 1
- Joined: Mon Sep 12, 2011 4:13 pm
Re: Installation DB syntax error *SOLVED*
Thanks Drakkheim your file fixed my error!!
- humvee
- Joomla! Master
- Posts: 14704
- Joined: Wed Aug 17, 2005 10:27 pm
- Location: Kent, England
Re: Installation DB syntax error *SOLVED*
[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.]