Database Error During Store Purchase After SMF 2.1 and Store 5.0 Beta Upgrades

[Michael Vail]

Good Day,

I recently installed the latest 5.0 beta version of the store software after updating my forum to SMF 2.1.2. Today I had my first user attempt to purchase and item but he couldn't do it. I'm waiting for a reply from him as to what exactly happened when he tried to purchase the item, but I saw three (3) of the following errors in the SMF database log when the users made his purchase attempts and I felt they might give you a head start as to what the problem is:

Today at 16:57
 Rob_McIntire
 96.69.132.22
 8e310795489c26287edb783014437b81
 https://www.sonomacountydsa.org/forums/index.php?action=store;sa=addcartitem;id=52;single=0
 /home/customer/www/sonomacountydsa.org/public_html/forums/Sources/Store2.php (Line 4440)  Backtrace information

Type of error: Database
Error messageSelect
Database Error: Field 'ID_ITEM' doesn't have a default value

INSERT INTO dsa_forums_store_item_custom_field_data
(ID_FIELD, ID_CART, value)
VALUES (6 , 619, 'XL')

If someone can offer a helping hand when they have time, I'd appreciate it.

Warm Regards...

[SMFHacks]

Try this sql command on the database

Code: [Select]

alter table dsa_forums_store_item_custom_field_data change ID_ITEM  ID_ITEM int(11) default 0;


[Michael Vail]

Thank you for the quick reply. I believe I executed the command correctly and the below is the the response phpmyadmin returned:

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0044 seconds.)
alter table dsa_forums_store_item_custom_field_data change ID_ITEM ID_ITEM int(11) default 0

Is this the expected response?

Thank you again,
Michael

[SMFHacks]

yes it is. The error should no longer occur.

[Michael Vail]

You're amazing. Any idea what caused it? Was it something I did wrong?

I sure appreciate your help.

Thanks again,

[Michael Vail]

The store works beautifully again. Thank you!

I'd sure love to work with you to implement the features I listed in the below post if you ever get time. I think a lot of users would find the useful and I'm willing to pay you for your time to do the work as done previously.

https://www.smfhacks.com/index.php/topic,9751.msg43677.html#msg43677

Have a great weekend and thank you again!
Michael Vail

[SMFHacks]

Glad it works. Yeah main issue for me is lack of time/users. The peak was around 2006 to 2009 for sales.

[Michael Vail]

Well thanks for all you do. My users and I greatly appreciate your products and support.

Have a great weekend!
Michael