Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4260
Latest: Verrick
New This Month: 3
New This Week: 0
New Today: 0
Stats
Total Posts: 43301
Total Topics: 7525
Most Online Today: 102
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 87
Total: 87

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

+- Recent Topics

Pretty Urls extras by SMFHacks
May 13, 2024, 10:28:54 am

Mod question by Verrick
May 11, 2024, 02:42:50 pm

i have paid but cant download ad pro. by SMFHacks
May 02, 2024, 11:29:38 pm

Please Help! by SMFHacks
April 17, 2024, 08:04:55 am

Rate own images by fvlog19
April 11, 2024, 10:56:53 am

Tidy Child Boards on 2.1.4 by SMFHacks
April 04, 2024, 03:54:12 pm

Problems SMF 2.0.19 > 2.1.4 SMF Gallery Pro - Recents Images to overall header by Michel68
March 30, 2024, 12:41:08 pm

Can't DROP 'id_member'; check that column/key exists Datei: by SMFHacks
March 30, 2024, 11:58:20 am

No thumbnails on new uploads by Tonyvic
March 29, 2024, 06:26:18 am

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

Powered by EzPortal