Mysql 5.5

[massive]

I recently updated mysql to 5.5 and i am facing the following problem.
I am trying to install joomla and i am getting the following 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 CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT --------------------------------------------------------------------

Does anybody have experience with this?

 

[ISOS6]

The problem is Joomla, possible it is not compatible with MySQL 5.5

 

[massive]

Yap and here is the solution :
http://forum.joomla.org/viewtopic.php?p=2132134

I tested wordpress also and it works properly.

 

[ditto]

Yap and here is the solution :
http://forum.joomla.org/viewtopic.php?p=2132134

I tested wordpress also and it works properly.

I have a customer running Joomla 1.5.22 on my server wich run MySQL 5.1.54. If I upgrade to MySQL 5.5x, I expect this site to stop working? If so, do you know how to fix a existing Joomla 1.5.22 site to work under MySQL 5.5x? To me, the link to Joomla forum seems to describe how to fix a new install, and not a existing one ...

 

[ISOS6]

5.5 is a development release and not suitable for production. Unless you have a specific reason to, you should not even consider running 5.5 for any production use.

I'm still running 5.1 on my server. No reason to upgrade

 

[massive]

Nope it's production release :
http://dev.mysql.com/doc/refman/5.5/en/choosing-version.html

MySQL 5.5: Latest General Availability (Production) release

MySQL 5.1: Previous stable (production-quality) release

MySQL 5.0: Older stable release nearing the end of the product lifecycle

Reason for updating (Personal Opinion) :

Massive Increase in speed

 

[ditto]

You are wrong, ISOS6. 5.5.8x is a Generally Available (GA) Release, and it have been GA since version 5.5.8. Now we are at version 5.5.9, and I am considering a upgrade.

 

[ISOS6]

I still see no reason to upgrade Not always the best idea with the latest version

 

[ditto]

I recently updated mysql to 5.5 and i am facing the following problem.
I am trying to install joomla and i am getting the following 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 CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT --------------------------------------------------------------------

Does anybody have experience with this?

This have now been fixed in Joomla version 1.5.23 wich was released today: http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit&tracker_item_id=25162

However, I wonder how existing Joomla 1.5x installations will do after a upgrade to MySQL 5.5.x? Does we need to manually change something in their databases?