Upgraded MySQL - Lot's of Similar Errors

[Marvin Miller]

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