Re: Upgraded MySQL - Lot's of Similar Errors

[Marvin Miller]

Hi!

ibf_members is pretty big but here's the specific row definition that was causing the problem;

`def_g_cat` mediumint(8) NOT NULL default '0',

The problem seems to be the NOT NULL constraint. I understand that but what I don't understand is that the same code used to work with those constraints when I was using the earlier MySQL versions I mentioned in the original post.

I guess I'm wondering if the earlier MySQL versions were much 'looser' and would have allowed that query to work because I'm certain the code hasn't changed and I double checked the contraints on that table and they haven't changed - so I find it odd that those queries stopped working after the updates.

Best & Thank You!
Marvin