Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4206
Latest: jagwire
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 42721
Total Topics: 7443
Most Online Today: 130
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 44
Total: 45

Author Topic: Database Error for Store in SMF2.1.2  (Read 489 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: 16205
    • 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: 16205
    • 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: 16205
    • 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: 16205
    • 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: 16205
    • 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
9969 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
2 Replies
3320 Views
Last post November 25, 2009, 07:43:15 am
by guest3817
4 Replies
4766 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks
3 Replies
3763 Views
Last post December 01, 2013, 05:37:43 pm
by SMFHacks
7 Replies
521 Views
Last post May 20, 2022, 08:58:15 pm
by Michael Vail

+- Recent Topics

Feature to upload a photo straight when composing a message by SMFHacks
February 04, 2023, 08:13:46 am

Pretty URL's Pro rewriting URLs by [chrisB]
February 01, 2023, 05:18:47 pm

Question before purchase by SMFHacks
February 01, 2023, 03:53:33 pm

Unlimited ending time by Saftek
January 29, 2023, 10:06:26 pm

Converting from Aeva Media by ivanr
January 28, 2023, 10:09:42 am

[Mod] Post Scheduler by bayonetbrant
January 23, 2023, 02:24:09 pm

"Notify all store admins of item purchase" Not Working in SMF 2.1.2 or 2.1.3 by Michael Vail
January 22, 2023, 10:50:23 pm

[Request] Future consideration by [chrisB]
January 18, 2023, 08:42:53 am

Pretty Urls extras by SMFHacks
January 16, 2023, 04:00:57 pm

I don't think its installed correctly by SMFHacks
January 10, 2023, 05:56:21 pm

Powered by EzPortal