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 This topic is locked, you cannot edit posts or make further replies.  [ 88 posts ]  Go to page Previous  1, 2, 3
Author Message
PostPosted: Sat Apr 16, 2011 6:18 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Apr 04, 2011 9:25 pm
Posts: 6
Drakkheim's attached file worked for me as well! Thanks Tons!




:)


Top
 Profile  
 
PostPosted: Tue Apr 26, 2011 5:08 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Apr 26, 2011 2:05 pm
Posts: 1
Gracias pero se debe cambiar es en el joomla.sql!! y perfecto!!!!!


Top
 Profile  
 
PostPosted: Tue Apr 26, 2011 7:40 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Apr 20, 2011 1:00 pm
Posts: 1
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


Top
 Profile  
 
PostPosted: Mon May 02, 2011 9:30 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon May 02, 2011 7:42 pm
Posts: 1
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


Top
 Profile  
 
PostPosted: Tue May 10, 2011 1:37 pm 
User avatar
Joomla! Champion
Joomla! Champion

Joined: Sat Aug 16, 2008 1:46 pm
Posts: 5800
Location: the Bat Cave
Change TYPE=MyISAM to ENGINE=MyISAM in your sql file.


Top
 Profile  
 
PostPosted: Sat May 14, 2011 7:39 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Nov 24, 2009 11:31 pm
Posts: 9
Actually installing the latest verison of Wampserver solved this error


Top
 Profile  
 
PostPosted: Wed May 25, 2011 8:58 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Aug 16, 2010 2:08 pm
Posts: 7
Chalk another one up to solved by Drakkheim's file.

Thanks!


Top
 Profile  
 
PostPosted: Sat May 28, 2011 5:32 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat May 28, 2011 5:18 pm
Posts: 4
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.


Top
 Profile  
 
PostPosted: Sat Jul 02, 2011 12:43 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat Jul 02, 2011 11:39 am
Posts: 1
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!!


Top
 Profile  
 
PostPosted: Tue Jul 12, 2011 12:01 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Jul 12, 2011 11:46 am
Posts: 1
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.


Top
 Profile  
 
PostPosted: Tue Jul 12, 2011 1:57 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Dec 06, 2009 3:22 pm
Posts: 17
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


Top
 Profile  
 
PostPosted: Sat Aug 13, 2011 11:36 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat Aug 13, 2011 11:29 pm
Posts: 1
great


Top
 Profile  
 
PostPosted: Thu Aug 25, 2011 8:13 am 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Tue Feb 24, 2009 6:29 pm
Posts: 1122
Location: Calicut, Kerala, India
As mentioned anove,
This worked for me :
Quote:
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...

_________________
Kannan Sreenivas ,
Freelance Web Developer , (+917403 00 44 33 )
kannan.sreenivas@gmail.com
http://kannansreenivas.elance.com


Top
 Profile  
 
PostPosted: Sun Aug 28, 2011 12:01 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat May 28, 2011 5:18 pm
Posts: 4
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!


Top
 Profile  
 
PostPosted: Sun Aug 28, 2011 4:50 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Aug 28, 2011 4:36 pm
Posts: 1
Wow! This worked for me..First time posting in a forum and It really worked! You rock guys...


Top
 Profile  
 
PostPosted: Mon Oct 03, 2011 6:54 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Oct 02, 2011 4:32 pm
Posts: 1
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`


Top
 Profile  
 
PostPosted: Fri Oct 21, 2011 2:50 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Jul 21, 2011 10:06 am
Posts: 4
Location: INDIA
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.


Top
 Profile  
 
PostPosted: Thu Nov 10, 2011 4:35 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Nov 10, 2011 4:20 pm
Posts: 1
YES! Thank you Drakkheim and phuc!! Replacing those two files worked. Thanks so much, you rock.


Top
 Profile  
 
PostPosted: Fri Nov 18, 2011 5:26 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Fri Nov 18, 2011 5:08 am
Posts: 1
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...


Top
 Profile  
 
PostPosted: Mon Nov 28, 2011 2:23 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sun Nov 27, 2011 2:46 am
Posts: 2
Just remove CHARACTER SET UTF-8 , then everything solved!


Top
 Profile  
 
PostPosted: Sat Dec 31, 2011 9:32 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Nov 16, 2009 1:19 am
Posts: 14
Location: Ελλάδα
Drakkheim's file worked for me too! Thanx!

_________________
http://levites.gr/


Top
 Profile  
 
PostPosted: Tue Jan 03, 2012 3:58 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Jan 03, 2012 3:45 am
Posts: 2
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!


Top
 Profile  
 
PostPosted: Tue Jan 03, 2012 4:25 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Jan 03, 2012 3:45 am
Posts: 2
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)


Top
 Profile  
 
PostPosted: Wed Jan 04, 2012 10:03 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Jan 04, 2012 9:17 pm
Posts: 1
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.


Top
 Profile  
 
PostPosted: Fri Jan 06, 2012 5:45 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Jan 05, 2012 11:24 pm
Posts: 1
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


Top
 Profile  
 
PostPosted: Wed Jan 11, 2012 6:47 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Jan 11, 2012 6:44 pm
Posts: 1
Location: Toronto
Wow!! Useful :)


Top
 Profile  
 
PostPosted: Mon Mar 05, 2012 4:07 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Sep 12, 2011 4:13 pm
Posts: 1
Thanks Drakkheim your file fixed my error!!


Top
 Profile  
 
PostPosted: Wed May 02, 2012 9:14 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Wed Aug 17, 2005 10:27 pm
Posts: 14715
Location: Kent, England
[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.]


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 88 posts ]  Go to page Previous  1, 2, 3



Who is online

Users browsing this forum: No registered users and 18 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