MySQL Forums :: Newbie :: Upgraded MySQL - Lot's of Similar Errors


Advanced Search

Upgraded MySQL - Lot's of Similar Errors
Posted by: Marvin Miller ()
Date: March 02, 2009 12:45AM

Hi Folks;

I just upgraded from MySQL mySQL 5.0.51a to 5.1.31 and now I'm seeing lots of errors in my PHP application.

What may be more important was that the connector for PHP to MySQL was version 3.23 and is now 5.0.51a

When I chose to upgrade I chose strict adherence.

Anyway, the application was working well until the upgrade. After the upgrade I'm seeing a LOT of these kinds of errors;

mySQL query error: UPDATE ibf_members SET user_sort='0',user_order='0',user_g_pp='5',user_s_pp='0',def_g_cat=NULL,game_skin=NULL WHERE id=1

mySQL error: Column 'def_g_cat' cannot be null

I've gone back over the code that creates the tables and they are exactly as originally designed.

Now, it seems to me that there are some issues with the dB tables design but my question is this - why are these errors showing up after the upgrade?

Best & Thank You!
Marvin

Options: ReplyQuote


Subject Written By Posted
Upgraded MySQL - Lot's of Similar Errors Marvin Miller 03/02/2009 12:45AM
Re: Upgraded MySQL - Lot's of Similar Errors laptop alias 03/03/2009 01:43AM
Re: Upgraded MySQL - Lot's of Similar Errors Marvin Miller 03/03/2009 01:54AM
Re: Upgraded MySQL - Lot's of Similar Errors laptop alias 03/03/2009 02:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.