I am getting the same error Under the Subscriptions/Recurring section.
1146 Table 'mys0832911580xxx.zen_subscription' doesn't exist
in:
[select count(*) as total from zen_subscription s ,zen_products_description pd where s.product_id=pd.products_id]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields
And also this error in MODULE /PAYMENT
Fatal error: Call to undefined function: zen_get_module_directory() in /home/content/m/o/t/motorsinmotion/html/store/includes/modules/payment/checkout_process.php on line 16
No PayPal Payment modules show up now
Any Ideas how to fix this?
I did the sql patch with the contents of the data.sql file:
CREATE TABLE zen_subscription (
id int(10) NOT NULL auto_increment,
name varchar(255) default NULL,
product_id int(10) default NULL,
sub_price varchar(100) default NULL,
billing_frequency int(10) default NULL,
duration_in varchar(10) default NULL,
sub_description text,
sub_trial_confirm int(1) default NULL,
trial_billing_period1 varchar(10) default NULL,
trial_billing_frequency1 int(10) default NULL,
trial_amount1 varchar(100) default NULL,
trial_to_total_billing_cycles1 int(10) default NULL,
PRIMARY KEY (id)
);
CREATE TABLE zen_customer_subscription (
cust_subscription_id int(10) NOT NULL auto_increment,
profile_id varchar(100) default NULL,
customer_id int(10) default NULL,
order_id int(10) default NULL,
subscription_id int(10) default NULL,
status char(1) default NULL,
modified_date varchar(100) default NULL,
product_id int(10) default NULL,
PRIMARY KEY (cust_subscription_id)
);
alter table zen_products add(products_recurring tinyint(1));
