Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4239
Latest: 3dickulus
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 43126
Total Topics: 7500
Most Online Today: 52
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 2
Guests: 53
Total: 55

Author Topic: Database Error for Store in SMF2.1.2  (Read 994 times)

0 Members and 1 Guest are viewing this topic.

Offline KKOG

  • Community Suite Customer
  • Member
  • ******
  • Posts: 47
    • View Profile
Database Error for Store in SMF2.1.2
« on: October 12, 2022, 07:37:24 pm »
Hi,

I am testing our upgrade to SMF 2.1.2 and have just installed Store version 5.0Beta

In testing the purchase of an item in the store when trying to add the item to the cart I received the following error

Quote
Field 'ID_ITEM' doesn't have a default value
File: /home/kkogcoma/public_html/smf2/Sources/Store2.php
Line: 4440


I have added a screen shot of the error

Regards
Greg Ralph
KKOG Forum Admin

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16378
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #1 on: October 12, 2022, 09:18:11 pm »
A quick hotfix you can run this query on your database.
Code: [Select]
ALTER TABLE smf_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 KKOG

  • Community Suite Customer
  • Member
  • ******
  • Posts: 47
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #2 on: October 12, 2022, 09:33:37 pm »
Hi,

Thanks for the hot fix

Running some additional checks, and the store item has a custom field attached.  The custom field is to record the mobile number of the buyer so that it can be included in the shipping details.

on deleting the custom field the add to cart works correctly.

If I run the hot fix on the database, will this affect the updated version of the Store mod or will an updated Store mod fix the database?  As I am currently in test mode, I am happy to wait for a new version to download.

Regards
Greg Ralph
KKOG Forum Admin
« Last Edit: October 12, 2022, 09:39:16 pm by KKOG »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16378
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #3 on: October 12, 2022, 09:59:07 pm »
It will not affect anything running on a live site. The fix will be included in a future update.
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 KKOG

  • Community Suite Customer
  • Member
  • ******
  • Posts: 47
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #4 on: October 12, 2022, 10:14:50 pm »
Thank you

Offline KKOG

  • Community Suite Customer
  • Member
  • ******
  • Posts: 47
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #5 on: October 24, 2022, 10:07:16 pm »
Is there a timeframe for the next version of the store as I would now like to migrate our production site to SMF 2.1.2

Thanks
Greg Ralph
KKOG Forum Admin

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16378
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #6 on: October 24, 2022, 11:13:31 pm »
There is not currently. I can add the fix in the download if needed.
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 KKOG

  • Community Suite Customer
  • Member
  • ******
  • Posts: 47
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #7 on: October 25, 2022, 12:12:41 am »
If you could add the fix to the current download (5.0beta) it would be appreciated

Thanks
Greg Ralph
KKOG Forum Admin

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16378
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #8 on: October 25, 2022, 03:06:07 pm »
Updated download. Has same filename.
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 KKOG

  • Community Suite Customer
  • Member
  • ******
  • Posts: 47
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #9 on: October 25, 2022, 06:01:32 pm »
Thank you, I have downloaded the revised file

Regards
Greg Ralph
KKOG Forum Admin

Offline KKOG

  • Community Suite Customer
  • Member
  • ******
  • Posts: 47
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #10 on: October 25, 2022, 08:01:09 pm »
Hello,

On installing the revised version of the Store I received the following error:

Quote
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''' at line 1
File: /home/kkogcoma/public_html/smf2/Packages/temp/storeinstall2.php
Line: 1062

I have included a screen shot of the error.

[ Guests cannot view attachments ]

Thanks
Greg Ralph
KKOG Forum Admin

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16378
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #11 on: October 25, 2022, 08:27:07 pm »
Try again uploaded a new package.
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 KKOG

  • Community Suite Customer
  • Member
  • ******
  • Posts: 47
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #12 on: October 25, 2022, 08:36:35 pm »
Thank you,

Downloaded new file

Regards
Greg Ralph
KKOG Forum Admin

Offline KKOG

  • Community Suite Customer
  • Member
  • ******
  • Posts: 47
    • View Profile
Re: Database Error for Store in SMF2.1.2
« Reply #13 on: October 25, 2022, 08:50:14 pm »
Successful Install

Thank you

Regards
Greg Ralph
KKOG Forum Admin
Like Like x 1 View List

 

Related Topics

  Subject / Started by Replies Last post
4 Replies
10187 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
2 Replies
3476 Views
Last post November 25, 2009, 07:43:15 am
by guest3817
4 Replies
4937 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks
3 Replies
3899 Views
Last post December 01, 2013, 05:37:43 pm
by SMFHacks
7 Replies
1089 Views
Last post May 20, 2022, 08:58:15 pm
by Michael Vail

+- Recent Topics

“Insert from Gallery” by apothocary
November 21, 2023, 07:25:28 am

SMFHacks Black Friday Sale 2023! by SMFHacks
November 19, 2023, 12:05:51 pm

File Count by SMFHacks
November 11, 2023, 11:46:46 am

Theme Changer by SMFHacks
November 09, 2023, 04:30:05 pm

Pretty Urls extras by SMFHacks
November 08, 2023, 05:23:14 pm

Member group access to emojis by SMFHacks
October 22, 2023, 07:24:12 am

Miscellaneous errors - don't know why by SMFHacks
October 13, 2023, 09:28:50 am

Follow / Follower Mod? by Nicole
October 06, 2023, 07:37:20 am

Mods supporting custom themes? by SMFHacks
October 02, 2023, 04:20:18 pm

Version 6.1.6 issues by SMFHacks
September 30, 2023, 07:54:52 am

Powered by EzPortal