# Server version: 5.0.37-standard # Protocol version: 10 Hi guys, Im trying to install this mysql database, but for some reason im getting a bunch of errors like; #1067 - Invalid default value for 'membership' Looking around i found out that its that the table structure is no compatible with my version of Mysql. Can someone please help me make this compatible with my server version. I know that while there are a lot of people here that just love to help, I also understand that your time is money, so Im willing to deposit $10 in the paypal or MoneyBookers account of the first one who can help me with this quick task! Please download -FILE REMOVED, PROBLEM FIXED- which contain the data. This is the same threat i posted in the service section, sorry, i didn't note there was such a section in the forum.
Can you define 'a bunch of errors'? How big is the sql dump? I can take a look at it for you if you want, no problem, I just need the file and 15-60 minutes depending on the size of the file.
The database was attached in a link, did you read the post? Mr. sawz got it fix it! Thanks for reapplying twhiting9275 If someone NOOB like me want the file to learn like im doing, just let me know!
Sorry, didn't see the link. The problem is the membership which wasn't set to the right default value (should have been 0 instead of ''). Meh, simple mistake me not seeing the file. It'd really be best though if you only posted in one place so you don't get competition like this going on Glad to see you got it fixed
Your datatype is int, however your default value is a string. Try using 0 or NULL as the default. Ooops...didn't see the post ahead. meh
Thank you very much for the help, I didn't even noted this side of the forum was that active, sure will learn a lot from you guys. I know some coding, but some times get stuck in the most simple things. What happen is that I upgraded my server to a newer version of mysql/PHP and as you all know a lot of things have been changed, for good of course!