The Joomla! Forum ™

Drakkheim's attached file worked for me as well! Thanks Tons!

Gracias pero se debe cambiar es en el joomla.sql!! y perfecto!!!!!

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

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

Change TYPE=MyISAM to ENGINE=MyISAM in your sql file.

Actually installing the latest verison of Wampserver solved this error

Chalk another one up to solved by Drakkheim's file.

Thanks!

Thanks friend. This one worked fine for me.

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!!

It is the BEST fix!

Thanks

I cant upload Easybook reloaded as extension not anymore. I ll get an error about mysql

great

As mentioned anove,
This worked for me :


Thank you for information...

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

This one worked for me. Thanks mate!

Wow! This worked for me..First time posting in a forum and It really worked! You rock guys...

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`

Excellent..

this work form me appreciate. *****

YES! Thank you Drakkheim and phuc!! Replacing those two files worked. Thanks so much, you rock.

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

Just remove CHARACTER SET UTF-8 , then everything solved!

Drakkheim's file worked for me too! Thanx!

_________________
http://levites.gr/

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!

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!

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.

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!!!

Wow!! Useful

Thanks Drakkheim your file fixed my error!!

[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.]