Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43261
Total Topics: 7519
Most Online Today: 297
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 286
Total: 287

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

0 Members and 1 Guest are viewing this topic.

Offline Michael Vail

  • Jr. Member
  • **
  • Posts: 67
    • 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 »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • 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

  • Jr. Member
  • **
  • Posts: 67
    • 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 »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • 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

  • Jr. Member
  • **
  • Posts: 67
    • 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,

Offline Michael Vail

  • Jr. Member
  • **
  • Posts: 67
    • 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

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • 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

  • Jr. Member
  • **
  • Posts: 67
    • 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

 

Related Topics

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

+- Recent Topics

Problems SMF 2.0.19 > 2.1.4 SMF Gallery Pro - Recents Images to overall header by Michel68
Today at 08:27:36 am

No thumbnails on new uploads by Tonyvic
Today at 06:26:18 am

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Powered by EzPortal