Database Error for Store in SMF2.1.2

[KKOG]

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

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

[SMFHacks]

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;


[KKOG]

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

[SMFHacks]

It will not affect anything running on a live site. The fix will be included in a future update.

[KKOG]

Thank you

[KKOG]

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

[SMFHacks]

There is not currently. I can add the fix in the download if needed.

[KKOG]

If you could add the fix to the current download (5.0beta) it would be appreciated

Thanks
Greg Ralph
KKOG Forum Admin

[SMFHacks]

Updated download. Has same filename.

[KKOG]

Thank you, I have downloaded the revised file

Regards
Greg Ralph
KKOG Forum Admin

[KKOG]

Hello,

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

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

[SMFHacks]

Try again uploaded a new package.

[KKOG]

Thank you,

Downloaded new file

Regards
Greg Ralph
KKOG Forum Admin

[KKOG]

Successful Install

Thank you

Regards
Greg Ralph
KKOG Forum Admin