[FIXED] - MySQL 5.0 problems

mdogbender
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Wed Dec 21, 2005 8:31 pm

[FIXED] - MySQL 5.0 problems

Post by mdogbender » Wed Dec 21, 2005 8:46 pm

I can't add a section to my site. The following error pops up in an IE Warning box.

mossection::store failed
Field 'params' doesn't have a default value SQL=INSERT INTO jos_sections('id','title','image','scope','image_position','description','published','ordering','access')VALUES('0','asdf','asdf','','content','left','asdfasdfasdf','1','','0')

I'm using PHP 5.1.1, MySQL 5.0.17-nt

I get a similar error when trying to create a category.
Last edited by stingrey on Tue Mar 07, 2006 9:19 pm, edited 1 time in total.

mdogbender
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Wed Dec 21, 2005 8:31 pm

Re: MySQL 5.0 problems

Post by mdogbender » Wed Dec 21, 2005 8:47 pm

Trying to set a menu item to unpublished is producing the following error to appear in the area right above the menu manager table.

mosmenu::store failed Incorrect integer value: \\\'\\\' for column \\\'published\\\' at row 1 SQL=UPDATE jos_menu SET `menutype`=\\\'topmenu\\\',`name`=\\\'Contact Us\\\',`link`=\\\'index.php?option=com_contact

Using
PHP 5.1.1
MySQL 5.0.17-nt

User avatar
Jinx
Joomla! Champion
Joomla! Champion
Posts: 6569
Joined: Fri Aug 12, 2005 12:47 am
Contact:

Re: MySQL 5.0 problems

Post by Jinx » Thu Dec 22, 2005 3:06 pm

U are using MySQL 5.0, Joomla 1.0.x is not compatible with MySQL 5.0 at the moment. We are working on a solution.
Johan Janssens - Joomla Co-Founder, Lead Developer of Joomla 1.5

http://www.joomlatools.com - Joomla extensions that just work

mstecha
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Tue Dec 20, 2005 3:37 pm

Re: [UNDER REVIEW] - MySQL 5.0 problems

Post by mstecha » Thu Dec 22, 2005 6:20 pm

What is the time frame for such solution?  I know that 1.0.5 is due in the near future; will it be there?  Or will we have to wait until 1.1?  I do not care as much about making optimal use of new features, query optimization, etc., but more about it actually working.  There are many issues that I have encountered.  Most of them can be fixed by setting a column type from not null to null.  However, I have also encountered other issues, such as a problem with User check-in and another issue with user management - I can only see admin in the user list, and not other users.

Thanks for all your work,

Kyle Lady

User avatar
Tonie
Joomla! Master
Joomla! Master
Posts: 16584
Joined: Thu Aug 18, 2005 7:13 am

Re: [UNDER REVIEW] - MySQL 5.0 problems

Post by Tonie » Thu Dec 22, 2005 6:44 pm

This will probably be in Joomla 1.1. The roadmap is here: http://www.joomla.org/content/view/14/28/

User avatar
masterchief
Joomla! Hero
Joomla! Hero
Posts: 2316
Joined: Fri Aug 12, 2005 2:45 am
Location: Brisbane, Australia
Contact:

Re: [UNDER REVIEW] - MySQL 5.0 problems

Post by masterchief » Fri Dec 23, 2005 2:33 am

I've run out of time to slip some experimentation into 1.0.5.  I should have a chance to get it ready for the next maintenance release within January though.

Hang tight.  The solution seems to be working.  Just need some more rigourous testing.
Andrew Eddie - Tweet @AndrewEddie
<><
http://eddify.me
http://www.kiva.org/team/joomla - Got Joomla for free? Pay it forward and help fight poverty.

User avatar
wensveen
Joomla! Apprentice
Joomla! Apprentice
Posts: 24
Joined: Tue Sep 13, 2005 11:32 am

Re: [SOLUTION PENDING] - MySQL 5.0 problems

Post by wensveen » Tue Dec 27, 2005 12:52 pm

Is there a tracker artifact for this bug? I have a bug report on this for a component I made and I want to redirect him to the Joomla! tracker.

I'll send him here instead, for now :)

Regards,
Matthijs

User avatar
masterchief
Joomla! Hero
Joomla! Hero
Posts: 2316
Joined: Fri Aug 12, 2005 2:45 am
Location: Brisbane, Australia
Contact:

MySQL 5 driver

Post by masterchief » Fri Dec 30, 2005 12:28 am

Here is a prototype driver for MySQL for Joomla 1.0.5+

First backup your old /includes/database.php file

Then rename the one attached to database.php and copy it over the existing one.

I've not done exhaustive testing on it yet.  Please turn on site debugging and set error reporting to maximum if you come across any problems.

For those who know a little more about php set up, can you write your php error to a log file and monitor it as well.

Let me know how it goes.
You do not have the required permissions to view the files attached to this post.
Andrew Eddie - Tweet @AndrewEddie
<><
http://eddify.me
http://www.kiva.org/team/joomla - Got Joomla for free? Pay it forward and help fight poverty.

User avatar
micheas
Joomla! Explorer
Joomla! Explorer
Posts: 323
Joined: Sat Sep 03, 2005 10:54 am
Location: San Francisco, CA
Contact:

Re: [SOLVED] - MySQL 5.0 problems

Post by micheas » Fri Dec 30, 2005 6:27 am

This is strange,

I have sent in patches for all of my bugs I have encountered with mysql 5 and the have been accepted.

The I have six sites using mysql5 and It has been a while since I have had an sql issue. (1.0.2 was the last bug mysql bug I encountered if i recall correctly)

User avatar
micheas
Joomla! Explorer
Joomla! Explorer
Posts: 323
Joined: Sat Sep 03, 2005 10:54 am
Location: San Francisco, CA
Contact:

Re: [SOLVED] - MySQL 5.0 problems

Post by micheas » Fri Dec 30, 2005 6:42 am

mdogbender wrote: Trying to set a menu item to unpublished is producing the following error to appear in the area right above the menu manager table.

mosmenu::store failed Incorrect integer value: \\\'\\\' for column \\\'published\\\' at row 1 SQL=UPDATE jos_menu SET `menutype`=\\\'topmenu\\\',`name`=\\\'Contact Us\\\',`link`=\\\'index.php?option=com_contact

Using
PHP 5.1.1
MySQL 5.0.17-nt
Looking at your errors this does not look to me to be a mysql 5 issue.

Ths last time I had this bug was in some python code in 2001. The problem was that the mysql database was set to an oddball default language. so the magic quotes became very confused, resulting in data corruption in the form of back slashes.

you may have magic_quotes_sybase or magic_quotes_runtime turned on, If either of those are on turn them off, and see if your problem goes away, also make sure that magic_quotes_gpc is on.

As I posted, I my patches to get Joomla working with mysql5 have been accepted long ago (mostly left joins) MySQL 5.0.11 caused a fair amount of pain, but that was dealt with a while ago.

User avatar
masterchief
Joomla! Hero
Joomla! Hero
Posts: 2316
Joined: Fri Aug 12, 2005 2:45 am
Location: Brisbane, Australia
Contact:

Re: [SOLVED] - MySQL 5.0 problems

Post by masterchief » Fri Dec 30, 2005 7:16 am

I should clarify, this file is to support MySQL5 in strict mode, which is the default setting.
Andrew Eddie - Tweet @AndrewEddie
<><
http://eddify.me
http://www.kiva.org/team/joomla - Got Joomla for free? Pay it forward and help fight poverty.

User avatar
micheas
Joomla! Explorer
Joomla! Explorer
Posts: 323
Joined: Sat Sep 03, 2005 10:54 am
Location: San Francisco, CA
Contact:

Re: [SOLVED] - MySQL 5.0 problems

Post by micheas » Fri Dec 30, 2005 10:08 am

masterchief wrote: I should clarify, this file is to support MySQL5 in strict mode, which is the default setting.
Interesting, I am using the FreeBSD port in it's default version with no extra options. (I have considered compiling it with BUILD_STATIC=Yes but otherwise this is a very default usage of MySQL5) And my only issue was a few joins.

the "\\\\" showing up in errors suggests to me a php problem not a mysql problem. At least It has never been a database problem when my previous mistakes created that. Sending the wrong character set, or not sending a character set has done it to me in the past.

mikeatwork
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Wed Jan 04, 2006 9:10 pm

Re: [SOLVED] - MySQL 5.0 problems

Post by mikeatwork » Wed Jan 04, 2006 9:47 pm

After fighting with this for the past 6 hours[1], my solution is: comment out STRICT_TRANS_TABLES in my.ini

I've tried the patch posted above with no joy, error message follows:

Fatal error: Call to undefined method mosSession::_setSchema() in C:\Program Files\Apache Group\Apache2\htdocs\joomla\includes\database.php on line 757

This is on Win2K, Apache 2.0.52, PHP 5.1.1, MySQL 5.0.18 (win32 binary, not compiled from source).

[1] Fighting defined as 3 clean installs of Joomla (didn't have mambo, or joomla, or anyother CMS prior to this); clean re-install of MySQL (thought it might be their crazy latin1_swedish_ci default setting, before realizing it could be changed in my.ini).

Oh well.

If you're having problems and the above patch doesn't work, AND you have control over your MySQL server, edit my.ini. Duplicate the line beginning "sql-mode=". Comment the original out. Delete "STRICT_TRANS_TABLES" from the copy and restart MySQL.

HTH.

/mike

tagrace
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Mon Jan 09, 2006 9:05 pm

Re: [SOLVED] - MySQL 5.0 problems

Post by tagrace » Wed Jan 11, 2006 3:18 pm

Mike,

deleting the STRICT_TRANS_TABLES has solved my problem and Joomla is now running on my test server. Thanks.

It's a shame it took three days for me to find this thread.

Ted

mikeatwork
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Wed Jan 04, 2006 9:10 pm

Re: [SOLVED] - MySQL 5.0 problems

Post by mikeatwork » Wed Jan 11, 2006 3:39 pm

Ted,

I can't really blame the Joomla folks. I'd upgraded to PHP5.1.1 the previous week which broke a number of my internal sites (strtodate() seems to have b0rked or changed). And installed MySQL 5.0 which, while working, has some miserable online documentation... I can't even find the page on their site which references the "strict" as related to dates that clued me to suspect that php5.1.1 might be passing problem dates to MySQL via Joomla (seemed to be the error Joomla was reporting).

Living on the edge. Oh well.

/mike

tagrace
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Mon Jan 09, 2006 9:05 pm

Re: [SOLVED] - MySQL 5.0 problems

Post by tagrace » Wed Jan 11, 2006 5:25 pm

Hi Mike,

I have PHP5 1.1 and mysql 5.018 loaded and all my other PHPBB and PHPNuke sites were working fine.

I found Joomla and decided to give it a try only to get the bug. I naturally thought (I should not think so hard) the issue was Joomla related and posted a note here in a subject related to mysql problems. I BUMPed it the next day and never received a response. ???

I searched again today and thankfully found you post. No big deal and I'm not upset  :) at all. I just thought that a bug of this nature would have a higher profile on the site.

OK, now what happens to the Joomla users that do not run their own serve and may not have the ability or can't get their ISP to change the my.ini? :(

Nothing worse then installing a new package that won't run. My usual action would be the delete key.

Ted

mikeatwork
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Wed Jan 04, 2006 9:10 pm

Re: [SOLVED] - MySQL 5.0 problems

Post by mikeatwork » Wed Jan 11, 2006 6:01 pm

Hello Ted,

With regards the bug's low profile, it seems to require the latest MySQL (alright, 5.0, I haven't tried 5.1), PHP and Joomla to bite. Not may ISPs are going to be running those versions. Yet. The support issues would be a nightmare. And most Joomla sites are probably hosted by service providers, not an individual's PC.

I'm still not sure what changed in PHP5.1.1 that caused my problems. PHPmyAdmin seemed to have no problems with MySQL5.0.18.

Our company's installed SharePoint Portal Server. On IIS. I'm one of the few interested in open source here. But I have got a couple of Apache servers up and PHP/perl driving SQL Server databases. I was hoping to find something to compete with SharePoint. I'd been reading a lot about Ruby on Rails, but getting it up and running and learning a new language has been a slog. A site I follow had been running a discussion of CMS packages and Joomla/Mambo was mentioned. Looked easy enough to test. And it probably would have been if I'd followed the advice and stuck to MySQL 4.

And at least the boards here, while not easy to navigate[1], don't seem to delete posts they don't like[2]. And the email notification is a nice touch.

/mike

[1] not easy = not familiar. If you've ever been to Apple's discussion boards you've probably seen [2].

User avatar
Tonie
Joomla! Master
Joomla! Master
Posts: 16584
Joined: Thu Aug 18, 2005 7:13 am

Re: [SOLVED] - MySQL 5.0 problems

Post by Tonie » Wed Jan 11, 2006 6:03 pm

Please also read this thread. Mysql 5 support is not totally there yet, but it's getting there: http://forum.joomla.org/index.php/topic,23659.0.html.

rbala
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Jan 20, 2006 8:32 am

Re: [SOLVED] - MySQL 5.0 problems

Post by rbala » Fri Jan 20, 2006 9:38 am

I commented out the 'STRICT' clause in my.ini and got the user registration for Joomla 1.0.7 to work.  However, Administrator cannot login...some problem with that piece.

I desperately would like to see Joomla work with MYSQL 5.0 as that RDBMS rocks....and so does Joomla and the combo would be awesome!

User avatar
stingrey
Joomla! Hero
Joomla! Hero
Posts: 2756
Joined: Mon Aug 15, 2005 4:36 pm
Location: Marikina, Metro Manila, Philippines
Contact:

Re: [SOLVED] - MySQL 5.0 problems

Post by stingrey » Fri Jan 20, 2006 10:48 am

What version of MySql are you try to use.

My local development server utilises
Apache2
MySql 5.0.17
PHP 5.11
&
PHP 4.4.2

and everything works correctly
Rey Gigataras
http://www.wizmediateam.com <-- great team of talented Web Designers and Programmers!
http://about.me/reygigataras <-- About Me :)
Partner, Business Development & Project Manager, Event Manager, Sports Coach :D

User avatar
micheas
Joomla! Explorer
Joomla! Explorer
Posts: 323
Joined: Sat Sep 03, 2005 10:54 am
Location: San Francisco, CA
Contact:

Re: [SOLVED] - MySQL 5.0 problems

Post by micheas » Fri Jan 20, 2006 12:55 pm

Would you happen to be using windows?

It seems that the defaults of MySQL5 on windows are more problematic, If you are I will look at the windows config files from MySQL.com to see if I can tell what is going on.

User avatar
stingrey
Joomla! Hero
Joomla! Hero
Posts: 2756
Joined: Mon Aug 15, 2005 4:36 pm
Location: Marikina, Metro Manila, Philippines
Contact:

Re: [SOLVED] - MySQL 5.0 problems

Post by stingrey » Fri Jan 20, 2006 3:28 pm

Well as it happens I develop on Windows and the server environement is a WAMP and I have not noticed any problems in my development and testing.
Rey Gigataras
http://www.wizmediateam.com <-- great team of talented Web Designers and Programmers!
http://about.me/reygigataras <-- About Me :)
Partner, Business Development & Project Manager, Event Manager, Sports Coach :D

RedBox
Joomla! Intern
Joomla! Intern
Posts: 64
Joined: Fri Oct 07, 2005 4:45 pm

Re: [SOLVED] - MySQL 5.0 problems

Post by RedBox » Fri Feb 03, 2006 5:24 am

I am glad I found this thread. I came across a similar error when I was testing/developing on

1) Joomla 1.0.7, PHP 5.12, MySQL 5.0.18, Apache 2.0.55 on Windows
2) Joomla 1.1 Alpha, PHP 5.12, MySQL 5.0.18, Apache 2.0.55 on Windows

That means I was able to duplicate the problem as well. Stingrey, maybe you can have someone do additional testing outside of your development/testing environment and see if they can duplicate it.

I had to delete "STRICT_TRANS_TABLES" from my.ini for MySQL as well to be able to move forward. My error was when I was trying to create a new frontpage menu component.

Thanks.


RedBox

chaoman
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Wed Feb 22, 2006 6:10 pm

Re: [SOLVED] - MySQL 5.0 problems

Post by chaoman » Wed Feb 22, 2006 6:15 pm

:D

Thank you all for your ideas. I just came to this forum to look for solutions since this mosuser::store failed problem annoyed me for many days. When I comment out the line STRICT_TRANS_TABLES from my my.ini everything works now!! Great!! Thank you all.

User avatar
stingrey
Joomla! Hero
Joomla! Hero
Posts: 2756
Joined: Mon Aug 15, 2005 4:36 pm
Location: Marikina, Metro Manila, Philippines
Contact:

Re: [SOLVED] - MySQL 5.0 problems

Post by stingrey » Wed Feb 22, 2006 6:24 pm

There is reported bug in 1.0.7 that affects the core when running in MySQL under strict mode.
Hopefully the upcoming 1.0.8 release has solved this issue.
Rey Gigataras
http://www.wizmediateam.com <-- great team of talented Web Designers and Programmers!
http://about.me/reygigataras <-- About Me :)
Partner, Business Development & Project Manager, Event Manager, Sports Coach :D

islyusar
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Apr 20, 2006 9:22 pm

Re: [SOLVED] - MySQL 5.0 problems

Post by islyusar » Thu Apr 20, 2006 10:00 pm

I encountered the same error as described in the first message of this thread after installing Joomla 1.0.8 yesterday.

System details:

Windows XP
Apache 1.3.23 (Win32) PHP/4.4.1
MySQL 5.0.19-nt
mikeatwork wrote: After fighting with this for the past 6 hours[1], my solution is: comment out STRICT_TRANS_TABLES in my.ini
That worked for me. Thanks a lot, Mike.

User avatar
normdouglas
Joomla! Hero
Joomla! Hero
Posts: 2654
Joined: Fri Jan 20, 2006 11:37 am
Location: Geelong Australia

Re: [FIXED] - MySQL 5.0 problems

Post by normdouglas » Wed May 03, 2006 7:26 am

WAMP5 does NOT have this so-called line in the my.ini for me to comment out!!!

I have googled for a solution to turning off strict mode in WAMP5 but no good.

Please can anyone help me.  I have WAMP5 on a SERVER2003 platform
Step1. Read the instructions. Step2. Refer to step 1. Step 3. Backup

User avatar
stingrey
Joomla! Hero
Joomla! Hero
Posts: 2756
Joined: Mon Aug 15, 2005 4:36 pm
Location: Marikina, Metro Manila, Philippines
Contact:

Re: [FIXED] - MySQL 5.0 problems

Post by stingrey » Thu May 11, 2006 11:39 pm

normdouglas wrote: WAMP5 does NOT have this so-called line in the my.ini for me to comment out!!!

I have googled for a solution to turning off strict mode in WAMP5 but no good.

Please can anyone help me.  I have WAMP5 on a SERVER2003 platform
Try add following to my.ini

sql-mode=MYSQL40

Should set DB to run in MYSQL 4 comapatability mode.



However, it should be noted that WAMP5 shouldnt be running in strict mode by default, at least it hasnt on my version I user for development purposes.
Rey Gigataras
http://www.wizmediateam.com <-- great team of talented Web Designers and Programmers!
http://about.me/reygigataras <-- About Me :)
Partner, Business Development & Project Manager, Event Manager, Sports Coach :D

User avatar
pinchepunk
Joomla! Intern
Joomla! Intern
Posts: 74
Joined: Thu Oct 20, 2005 2:20 pm

Re: [FIXED] - MySQL 5.0 problems

Post by pinchepunk » Sun May 28, 2006 6:19 pm

Is there anyway to do this through myPhpAdmin?  ???

I don't have access to the my.ini file with my host. :(

User avatar
stingrey
Joomla! Hero
Joomla! Hero
Posts: 2756
Joined: Mon Aug 15, 2005 4:36 pm
Location: Marikina, Metro Manila, Philippines
Contact:

Re: [FIXED] - MySQL 5.0 problems

Post by stingrey » Mon May 29, 2006 3:05 am

pinchepunk wrote: Is there anyway to do this through myPhpAdmin?  ???

I don't have access to the my.ini file with my host. :(
http://forum.joomla.org/index.php/topic,47032.0.html
Rey Gigataras
http://www.wizmediateam.com <-- great team of talented Web Designers and Programmers!
http://about.me/reygigataras <-- About Me :)
Partner, Business Development & Project Manager, Event Manager, Sports Coach :D


Locked

Return to “Q&T 1.0.x Resolved - Archived”