Incorrect integer value: '' for column 'don_ID' at row 1
It seems that OSC is not picking up the donation amount and I keep getting this error. I have tried everything I know to see if maybe I have the wrong envelope, or maybe the person isn't saved properly or that they aren't in the cart or someother thing, but I keep getting the error.
Oh... I even tried getting the new page from the CVS and I still get the exact same error message.
Thanks.
Ken
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have been trying and trying to get the batch entry to work, but alas, nothing.
This is the error I keep getting...
Cannot execute query.
INSERT INTO donations_don VALUES ('', 1, 2, 1, 0, '2005-12-4', 1)
Incorrect integer value: '' for column 'don_ID' at row 1
It seems that OSC is not picking up the donation amount and I keep getting this error. I have tried everything I know to see if maybe I have the wrong envelope, or maybe the person isn't saved properly or that they aren't in the cart or someother thing, but I keep getting the error.
Oh... I even tried getting the new page from the CVS and I still get the exact same error message.
Thanks.
Ken
I forgot to mention the new page I got from the CVS is DonationEdit.php
Ken,
Could you verify in mysql that don_ID is incrementing?
As far as I can tell it is set up to auto increment.
I've looked at the database and it has auto_increment in the Extra area.
Hmm, can you send me a screen shot of the screen just before you hit submit. I'd like to see the values you are typing in.
Steve.
Sure!!! Have sent via e-mail.
Ken
As an aside to what I replied... I have also dropped the database, reinstalled it, and reinstalled OSC twice with the same results all two times.
I'm using the most recent edition of MySql, PHP, Perl etc...
I'm even using FireFox as the browser.
Ken
Okay... Never mind... I fixed it.
I had the MYSQL server set in strict mode. It must not be set in that mode in order for OSC