Administrators Nabeel Posted October 7, 2011 Administrators Report Share Posted October 7, 2011 i found this on the internet: http://www.phpbb.com...t-value-errors/ could it be that somehow my mysql installation is somehow newer and could cause some values not written correctly during installation? I looked up my mysql installer and this is what it says: mysql-installer-5.5.15.0 Perhaps. I've been installing/testing on MySQL 5.1. I don't know what changed have occurred in 5.3+ See if you can get a copy of 5.1. I'll try to figure out what's going on with 5.5 Quote Link to comment Share on other sites More sharing options...
Edwin Posted October 7, 2011 Author Report Share Posted October 7, 2011 Perhaps. I've been installing/testing on MySQL 5.1. I don't know what changed have occurred in 5.3+ See if you can get a copy of 5.1. I'll try to figure out what's going on with 5.5 i found 5.1, but there are a lot of builds in 5.1, which do you recommend? http://downloads.mysql.com/archives.php?p=mysql-5.1 Quote Link to comment Share on other sites More sharing options...
Edwin Posted October 8, 2011 Author Report Share Posted October 8, 2011 I deleted old installations and installed mysql 5.1 and installed phpvms. I'm back to square one saying the field price doesnt have a default value.. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted October 8, 2011 Administrators Report Share Posted October 8, 2011 I think the issue might be that MySQL is in strict mode. Can you try this http://lynnepope.net/turn-off-mysql-strict-mode Quote Link to comment Share on other sites More sharing options...
Edwin Posted October 9, 2011 Author Report Share Posted October 9, 2011 I think the issue might be that MySQL is in strict mode. Can you try this http://lynnepope.net/turn-off-mysql-strict-mode Reinstalled the whole thing with mysql55 since the same happend with mysql51 and only thing I did was execute the SET @@global.sql_mode= ''; in the database query. Filed a report and it worked!!!!!! Thanks a million for your support with this so solution on new installation is, install everything by default as in the dummy guide and execute the SET @@global.sql_mode= ''; in the database. Then all should be fine Quote Link to comment Share on other sites More sharing options...
Edwin Posted October 9, 2011 Author Report Share Posted October 9, 2011 I think the issue might be that MySQL is in strict mode. Can you try this http://lynnepope.net/turn-off-mysql-strict-mode Reinstalled the whole thing with mysql55 since the same happend with mysql51 and only thing I did was execute the SET @@global.sql_mode= ''; in the database query. Filed a report and it worked!!!!!! Thanks a million for your support with this so solution on new installation is, install everything by default as in the dummy guide and execute the SET @@global.sql_mode= ''; in the database. Then all should be fine Quote Link to comment Share on other sites More sharing options...
Edwin Posted October 22, 2011 Author Report Share Posted October 22, 2011 Reinstalled the whole thing with mysql55 since the same happend with mysql51 and only thing I did was execute the SET @@global.sql_mode= ''; in the database query. Filed a report and it worked!!!!!! Thanks a million for your support with this so solution on new installation is, install everything by default as in the dummy guide and execute the SET @@global.sql_mode= ''; in the database. Then all should be fine Sometimes i still have to run this code; SET @@global.sql_mode= ''; Otherwise my system stops registrering pending items etc. I'm trying to figure out how to auto-run this, but haven't found it yet. Anyone an idea? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.