|
81
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
82
« Last post by SMFHacks on May 19, 2022, 09:38:03 pm »
Try this sql command on the database
alter table dsa_forums_store_item_custom_field_data change ID_ITEM ID_ITEM int(11) default 0;
83
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...
84
« 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.
85
« 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.
86
« 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. https://www.databasedreams.co.uk/support/index.php?action=downloads;sa=view;id=51
87
« 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!
88
« Last post by SMFHacks on May 18, 2022, 02:33:21 pm »
yes https://www.w3resource.com/mysql/string-functions/mysql-replace-function.phpupdate tablename set columnname = REPLACE(columnname, "find_string", "replace_with")
89
« 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.
90
« 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?
|
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
|
|
|