Thread

Upgraded a 1.* to v2.2.2 - Build: date 20110801

Just now we’ve tried adding a new item into Simple Commerce and received the following error:

A Database Error Occurred

Error Number: 1054

Unknown column 'member_group_unsubscribe' in 'field list'

INSERT INTO `exp_simple_commerce_items` (`entry_id`, `item_enabled`, `item_regular_price`, `item_sale_price`, `item_use_sale`, `subscription_frequency`, `subscription_frequency_unit`, `new_member_group`, `admin_email_address`, `admin_email_template`, `customer_email_template`, `recurring`, `admin_email_template_unsubscribe`, `customer_email_template_unsubscribe`, `member_group_unsubscribe`) VALUES ('289', 'y', '249.00', '97.00', 'y', NULL, 'day', '0', '', '0', '0', 'n', '0', '0', '0')

Filename: modules/simple_commerce/mcp.simple_commerce.php

Line Number: 475

I’m only guessing but I don’t think the table was properly upgraded. I *would uninstall the module and re-install it if I knew I wouldn’t lose all my products etc.

Thoughts?

Hi Brandon,

For a bit of background. Did you already have entries associated with the Simple Commerce Module in your EE1.x version or are you just starting to use SCM now you are on EE2.2x?

Can you head to Tool -> Data -> MySql Manager and open the Database Query Form please?

In it could you type and submit the following

DESCRIBE exp_simple_commerce_items

Can you then take a screenshot and post it back here in a reply please?

Hey John,

We already had entries associated with the SCM from version EE1.
It appears that the upgrade didn’t upgrade the tables for SCM, I manually created the missing column with int(8) and this seems to fix the issue, but this may be a bug that needs to be submitted.

brandonrichards,

Thanks for letting us know you are all set. If you need assistance in the future, please feel free to start a new thread.

resolved