Facebook  Twitter 




+- User Information

Welcome, Guest.
Please login or register.
Forgot your password?

+- Forum Stats

Total Members: 11834
Latest: Volker S
New This Month: 1
New This Week: 1
New Today: 0
Total Posts: 42319
Total Topics: 7381
Most Online Today: 219
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 33
Total: 34

Recent Posts

Pages: 1 ... 7 8 [9] 10
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,
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;
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
 /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...
Support / Re: Default License Agreement
« Last post by SMFHacks on May 18, 2022, 08:18:15 pm »
I think it could be done by setting a default value for the column in the database as quickword around.
Support / Re: Default License Agreement
« Last post by Puppeteer on May 18, 2022, 08:10:02 pm »
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.
Support / Re: Default License Agreement
« Last post by mickjav on May 18, 2022, 04:45:17 pm »
Doesn't the License Agreement you added for me cover that as you can add text so if somebody downlaods a item they have to agree to the License.

Try downloading link below.

Support / Re: Email Note - Included in order purchase
« Last post by Shades on May 18, 2022, 02:54:54 pm »
Thanks, I will give that a go on my test site because I'm sure I'll screw something up! :o  ;D
Support / Re: Email Note - Included in order purchase
« Last post by SMFHacks on May 18, 2022, 02:33:21 pm »
yes https://www.w3resource.com/mysql/string-functions/mysql-replace-function.php

update tablename set columnname = REPLACE(columnname, "find_string", "replace_with")
Support / [Feature Request] Keywords
« Last post by Shades on May 18, 2022, 02:20:19 pm »
The ability to add keywords to each item in the store individually would be a nice feature. 8)
Support / Re: Email Note - Included in order purchase
« Last post by Shades on May 18, 2022, 02:17:19 pm »
Is there a way to globally change certain phrases or words in the description without changing the whole description in phpadmin?
Pages: 1 ... 7 8 [9] 10

+- Recent Topics

Profile Gallery Link by Hatshepsut
July 04, 2022, 11:00:01 pm

Trying to access array offset on value of type null by SMFHacks
July 04, 2022, 08:14:20 pm

Pictures appearing in post by SMFHacks
July 04, 2022, 12:56:40 pm

Error When Uploading Gifs To Subcategories by SMFHacks
July 03, 2022, 05:50:19 pm

SMF forum by davejo
June 27, 2022, 01:16:25 am

Quick-moderation checkboxes by davejo
June 22, 2022, 09:27:24 am

Add option to Main Menu bar by Shades
June 21, 2022, 12:23:00 am

Logo and Category? by SMFHacks
June 12, 2022, 03:43:31 pm

prettyurls - TroubleShooting.wiki by GhostHunting
June 12, 2022, 02:52:57 pm

[Mod]Modification Update Version Checker by SMFHacks
June 06, 2022, 09:25:39 pm

Powered by EzPortal