02-15-11 02:12 PM - Post#85255    

I've just had to move our FusionBB from a server running MySQL 4.something to one running 5.something.

All seemed to be OK, but then I found I couldn't post new messages. It turned out that the 'Post_class' was trying to insert a row with an integer value set to '' (two single quotes) which isn't an integer value.

In MySQL 4, that was converted to '0', but in MySQL 5 it isn't.

I found an article here explaining how to make MySQL 5 less fussy, which does seem to work, but it doesn't seem ideal to have to do this.

Is FusionBB meant to work with MySQL 5 'strict' mode?

(FusionBB 3.1 Final)

02-15-11 11:24 PM - Post#85258    

    In response to pscsuk

It should be... but that sounds like a bug which we'll have to fix up in our next version.

Thanks for the heads up.

Feel Better, Feel Younger, Sleep Better - Trans-D Tropin Visit www.BuyTransD.com - use coupon code 1004 to save $20