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: 43259
Total Topics: 7518
Most Online Today: 297
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 282
Total: 282

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

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

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

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal