MySQL Forums
Forum List  »  Newbie

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!

Options: ReplyQuote

Written By
Upgraded MySQL - Lot's of Similar Errors
March 02, 2009 12:45AM

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.