The Joomla! Forum ™

It work for me too..

Drakkheim's 'joomla.sql' in the zip file worked for me after two days of screwing around with this.

Thanks Drakkheim! (and whoever else suggested the changes to joomla.sql)

It was weird, Joomla 1.6 would install but 1.5.22 would not. It was suggested to install Zend Framework Community Edition...that didn't help at all.

easyest way is to fix it is to install wamp 2.0i

Hello everyone! I tried replacing the files as mentioned above, but now I'm getting a message that says Unable to connect to the database:Could not connect to MySQL. I tried restarting mysql but I'm not having any luck. Does anyone have a suggestion for me before I actually uninstall Wampserver and install the prior version? Thanks in advance.

The default MySQL user is root and the password should be left blank. If you added a password to the MySQL user that could be your problem, I haven't had much luck adding a password. Make sure the MySQL service is running, Alt/Ctrl/Delete you should see mysqld-nt.exe running. You can left click the Wamp icon, bottom right tray, and Restart or Start all services to make sure it is running.

Thanks Dpac, but the first thing I checked was to make sure mysql was running. I also left the password blank and left the user as root. I guess it must be something with the new version of wamp. Should I install the previous version of Wamp? It seems like people are saying that works.

If the user name and password are correct double check the database name. The problem others are having with the latest version of Wamp is that the Joomla sql file is not updated for the latest version of MySQL that it uses. If you are using the correct connection info but getting a can not connect issue then you haven't gotten to the sql error problem yet. You might try un-installing Wamp and installing the older version WampServer2.0i and see if that helps.

ENGINE = MyISAM was great thanks

Hi everyone,

just wanted to witness that integradona made my day by solving the issue.

Is just funny that I used joomla1.5 before without ever getting this error.... where does it suddenly comes from?

This was a nice discussion here and it's great that the community works so well together!

Just another thankyou to Drakkheim for his fix and to say that this has restored my confidence in Joomla. I was using XAMPP

Yes, yes, yes! It works.

Original code:

) CHARACTER SET `utf8`;

Changed code:


) TYPE=MyISAM CHARACTER SET `utf8`;


Thank You, guys!

Now its work.. Thanks.

i think if you use appserv
you will not have any problem like this

_________________
http://www.tomweb.ir
http://www.nicmehr.com

It work for me !! Thanks !!
Joomla in localhost (Win 2003) with XAMPP 1.74

It works!!!!!!!!!!!!!!!!!!!!!!!!!Thank you Drakkheim

Drakkheim's attached file worked for me. Thank you very much.

As far as I know Joomla 1.5 is not compatible with MySQL 6.
http://www.joomla.org/technical-requirements.html

the problem many are having is that they replaced: TYPE=MyISAM CHARACTER SET='utf-8'
with: textCHARACTER SET='utf8'

This was due to the post describing that solution missing a space between the words text and CHARACTER. the word "text" was not meant to be part of the replacement string.

the proper replacement text is just: CHARACTER SET='utf-8'

wow that worked for me as well....replace TYPE=MyISAM by ENGINE=MyISAM

Thanks a lot, Drakkheim. I just solved this annoying problem. I owe you a coffee

Wampserver 2.0i + joomla 1.5.22 = DB syntax error solved

Hello,
still having a problem after I replaced both the files you attached.
can anyone help ?


LE: sorry , fixed it ! have a nice day

Drakkheim's attached file worked for me (joomla 1.5.22.+wamp 2.1e)
Thanks a lot, Drakkheim!

Hi,

I've got the same problem while migrating from Joomla 1.0.13 to Joomla 1.5.22. When I try to upload and execute the SQL migration script I get this error:

Error at the line 35: ) TYPE=MyISAM AUTOjos_INCREMENT=1 ;

Query:CREATE TABLE IF NOT EXISTS `#jos_jos_jfjos_content` (
`id` int(10) unsigned NOT NULL autojos_increment,
`languagejos_id` int(11) NOT NULL default '0',
`referencejos_id` int(11) NOT NULL default '0',
`referencejos_table` varchar(100) NOT NULL default '',
`referencejos_field` varchar(100) NOT NULL default '',
`value` text NOT NULL,
`originaljos_value` varchar(255) default NULL,
`originaljos_text` text,
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modifiedjos_by` int(11) unsigned NOT NULL default '0',
`published` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTOjos_INCREMENT=1 ;

MySQL: 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 'autojos_increment, `languagejos_id` int(11) NOT NULL default '0', `reference' at line 2

I've spent hours searching for a solution on the web and nothing worked. I replaced "TYPE=MyISAM" by "ENGINE=MyISAM", and it didn't work (I've tried with several editors including Notepad++ and Wordpad). I've also tried just to remove "TYPE=MyISAM". I've tried ISO-8859-1 and UTF8 encodings (with UTF8 I get an iconv error, so I guess ISO-8859-1 is the right choice). I've tried to uncheck JoomFish! (the only 3rd party migrator I've installed) while creating the migration script. I've tried with XAMPP 1.5.4 (MySQL 5.0.24a) & 1.7.3 (with this server I get additionally a "Function ereg() is deprecated" error, so I guess it's useless to try again), WAMP 2.1 (MySQL 5.1.36), WAMP 2.0i (also the ereg error).

Nothing has worked! Always exactly the same error!

Some more information (I don't think it's useful but we never know...). The initial database has latin1_swedish_ci encoding, and the created one for Joomla 1.5 has utf8_general_ci encoding (all tables seem to have been successfully created but the installation fails).

Any idea what could be wrong? Hopefully an easy trick I've forgotten to try...

Thanks for your help

Philippe

This is messed up

It looks like you did a search and replace on the dump file and put jos_ all through it. During the install of the migration file the only prefix you should use is jos_
http://docs.joomla.org/Common_Migrator_Errors

Thanks a lot!

As expected it was a stupid mistake... I hadn't filled in the "Old table prefix" field because it was left blank in the tutorial I'd read (probably a mistake). As I'd left this field blank the installer replaced automatically all "_" in the migration file by "jos_" when I clicked on "upload the script". The program probably considered a blank prefix as the prefix "_" and is configured to replace the blank prefix by the default prefix "_jos". But this is a bug, as replacing all "_" also has as a consequence to modify SQL keywords (e.g. "AUTO_INCREMENT" --> "AUTOjos_INCREMENT"), hence the error that occurred everytime. Now the problem is solved: the migration worked, after more than one day lost trying to find a solution...

Thanks again

Philippe

I also cannot get past this install issue


ERROR MESSAGE IS LIKE BELOW:
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`

_________________
Please read the forum rules regarding the use of signatures: viewtopic.php?f=8&t=65

thaxz it workz fine now

The above is wrong.

The replace should be: CHARACTER SET `utf8`;

Totally agree. Wampserver 2.0i + joomla 1.5.22 = Database syntax error solved!