Joomla! Discussion Forums

Introduction

Please find attached a proposed solution for problems experienced by users of Joomla! 1.0.8 on servers running MySQL 5 with strict mode on.

This problem usually results in not being able to add data into the system like new sections.

If you are running on a MySQL 5 database without problems, then you do not need to apply this solution.  This is only for users with MySQL 5 that has been switched to strict mode.

Note this `proposed solution` has not yet been exhaustively tested, however, initial tests show it should address the issue of newfeeds not being visible. 
Also as this is a Work In Progress fix, it may not be the final fix that will be available in 1.0.9

This version of jooml.php only contains the fix to make Joomla! work with MySQL 5 in strict mode.  Other changes in SVN made to joomla.php are not included.



Instructions

1. Download the zip file attached.
2. Extract the files locally.
3. Transfer the files across to your server and overwrite the files on your server.

The files go to the following folders:

• joomla.php
  overwrites
  /includes/joomla.php
  

Integrity Check

To check the integrity of the file being downloaded, you can open the file and check that the following file version information can be found at the top of the respective files:

• newsfeeds.html.php
  * @version $Id: joomla.php 2599 2006-02-24 07:49:49Z stingrey + mysql5 strict solution $
  

This is the only place where you should download these files.



Disclaimer

This is not an offiicial release, even though the work is done by the Offiicial Joomla! team, neither does it represent an official patch. 
It is simply an attempt to help users in a more timely fashion with an obvious problem in 1.0.8
The work should be seen as a Work In Progress.

As such it should be used with caution and backups of files being replaced should be done.

Work on the official release of Joomla! 1.0.9 is still being undertaken and will be released in due course after work has been finished and it goes through regular testing phases with testing teams.

For the technical minded all this solution does is to set you mysql mode from strict mode to mysql4 mode.

This should mean you can once again can add data into the database without problems.