Database Error in Store module

Getting this error when trying to add an item in the store module.

 

I'll try reinstalling the module to see if that helps but this was a recent install so should be fine.

 

Any input on the error?

 

Database error in MobStrik

Query: 

INSERT INTO `bx_store_product_files` VALUES (NULL, '1', '4', '10', '100', '2', 0)

Mysql error: Column count doesn't match value count at row 1

Found error in the file '/home/mobstrik/public_html/modules/boonex/store/classes/BxStoreDb.php' at line 79.
Called 'query' function with erroneous argument #0.

Quote · 29 Apr 2017

I see 7 fields tried to be inserted...  which matches the field count in the module...   

The only thing I can see maybe...  the last 0  is not '0'  

Without looking at your database it's hard to say why the field count is not matching.

If you look in the database at bx_store_product_files you should see these 7 fields.

 

ID

author_id

entry_id

media_id

price

allow_purchase_to

hidden

https://dolphin-techs.com - Skype: Dolphin Techs
Quote · 29 Apr 2017

Note that the last value being inserted does not have the single quotes around it as Dolphin Jay stated.  I would think that the hidden value is assigned zero or one.

Geeks, making the world a better place
Quote · 30 Apr 2017
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.