Print Post - MySQL 5 - FusionBB Community

Select "print" from your browser's "File" menu.

Back to Post

Username	Post: MySQL 5
pscsuk FusionBB Newbie Posts 14	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)

Username

Post: MySQL 5

pscsuk
FusionBB Newbie
Posts 14

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)

FusionBB™ Version 3.2 | ©2003-2013 InteractivePHP, Inc.
Execution time: 0.043 seconds. Total Queries: 18 Zlib Compression is on.
All times are (GMT-4). Current time is 06:27 PM
Top