Facebook 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4301
Latest: Bolon377
New This Month: 9
New This Week: 4
New Today: 1
Stats
Total Posts: 43801
Total Topics: 7605
Most Online Today: 561
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 54
Total: 55

Author Topic: Database Error During Store Purchase After SMF 2.1 and Store 5.0 Beta Upgrades  (Read 2393 times)

0 Members and 1 Guest are viewing this topic.

Offline Michael Vail

  • SMF Store Customer
  • Jr. Member
  • *****
  • Posts: 76
    • View Profile
    • Sonoma County DSA
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:

Quote
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...
« Last Edit: May 19, 2022, 09:36:05 pm by scso1502 »
"We sleep safe in our beds because rough men stand ready in the night to visit violence on those who would do us harm" - George Orwell

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16677
    • View Profile
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;
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Michael Vail

  • SMF Store Customer
  • Jr. Member
  • *****
  • Posts: 76
    • View Profile
    • Sonoma County DSA
Thank you for the quick reply. I believe I executed the command correctly and the below is the the response phpmyadmin returned:

Quote
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
« Last Edit: May 19, 2022, 11:51:55 pm by Michael Vail »
"We sleep safe in our beds because rough men stand ready in the night to visit violence on those who would do us harm" - George Orwell

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16677
    • View Profile
yes it is. The error should no longer occur.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Michael Vail

  • SMF Store Customer
  • Jr. Member
  • *****
  • Posts: 76
    • View Profile
    • Sonoma County DSA
You're amazing. Any idea what caused it? Was it something I did wrong?

I sure appreciate your help.

Thanks again,
"We sleep safe in our beds because rough men stand ready in the night to visit violence on those who would do us harm" - George Orwell

Offline Michael Vail

  • SMF Store Customer
  • Jr. Member
  • *****
  • Posts: 76
    • View Profile
    • Sonoma County DSA
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
"We sleep safe in our beds because rough men stand ready in the night to visit violence on those who would do us harm" - George Orwell

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16677
    • View Profile
Glad it works. Yeah main issue for me is lack of time/users. The peak was around 2006 to 2009 for sales.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Michael Vail

  • SMF Store Customer
  • Jr. Member
  • *****
  • Posts: 76
    • View Profile
    • Sonoma County DSA
Well thanks for all you do. My users and I greatly appreciate your products and support.

Have a great weekend!
Michael
"We sleep safe in our beds because rough men stand ready in the night to visit violence on those who would do us harm" - George Orwell

 

Related Topics

  Subject / Started by Replies Last post
2 Replies
3653 Views
Last post February 22, 2009, 01:23:53 am
by speedfreak87
2 Replies
5593 Views
Last post April 25, 2009, 10:19:23 am
by Wegg
20 Replies
10627 Views
Last post October 02, 2017, 03:00:50 pm
by Michael Vail
5 Replies
3970 Views
Last post November 15, 2017, 05:29:15 pm
by SMFHacks
13 Replies
7258 Views
Last post October 25, 2022, 08:50:14 pm
by KKOG

+- Recent Topics

A day? by davejo
June 11, 2025, 04:14:35 pm

Dual 'Upload Url' by davejo
June 06, 2025, 04:27:45 pm

Automatic Sorting of Categories by Kiwi
June 03, 2025, 10:32:32 pm

[Mod]Cloudflare Turnstile for SMF by SMFHacks
May 08, 2025, 10:08:43 am

Disable "Notify me of Comments feature" by Kiwi
May 08, 2025, 02:04:16 am

Trying to access array offset on null by Michel68
May 05, 2025, 08:47:34 am

Default [Additional] Membergroups upon Registration by SMFHacks
April 30, 2025, 10:22:52 am

Sorted FTP Import Directory by SMFHacks
April 25, 2025, 05:11:22 am

Search results items per page? by SMFHacks
April 18, 2025, 04:12:23 pm

Suggestions and request by Senkusha
April 03, 2025, 02:30:43 pm

Powered by EzPortal