SMFHacks.com

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

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...

That works great.  I just want all my downloads to have default text during the upload process, rather than the box being empty, and needing to be filled in each time.

On our site, we allow members to upload, and just want boilerplate, which they are free to change if they want their own licensing agreement.

Thanks, I will give that a go on my test site because I'm sure I'll screw something up!  

The ability to add keywords to each item in the store individually would be a nice feature.