Paypal recurring billing module for Website Payment Pro

[blakdeth77]

Hello, I am getting an error when I log in to the admin section and click on the Subscriptions/Recurring at the top of the screen just under "logoff". The error I get is

1146 Table 'xxxxxxxxxx.subscription' doesn't exist



Do you know offhand where I went wrong with the install? I am using ZC v1.3.8, PHP Version: 5.2.5 (Zend: 2.2.0), and MySQL 5.0.67 .

Thanks!!

[fscproductions]

I have attached the shopping cart image from the granola site. It shows the subscription price in the attributes. That is what is the amount charged through Paypal on the subscription basis.

In order to show the customer the amount they are being charged in the checkout, you have to display the attributes from the cart. As mentioned with the first version of the recurring mod, and I mention above, the checkout price will show $0, but the amount that is being deducted on the schedule you set, is the amount in the attributes area.

It was tested through Paypal sandbox, and the checkout went through with no issues.

You can use the paypal recurring, but unless they have upgraded it, it will require alot of coding inside zen to get it to work through zencarts checkout system.

[fscproductions]

Hello, I am getting an error when I log in to the admin section and click on the Subscriptions/Recurring at the top of the screen just under "logoff". The error I get is

1146 Table 'xxxxxxxxxx.subscription' doesn't exist



Do you know offhand where I went wrong with the install? I am using ZC v1.3.8, PHP Version: 5.2.5 (Zend: 2.2.0), and MySQL 5.0.67 .

Thanks!!

Did you do the sql table update?

[blakdeth77]

Did you do the sql table update?

Yes I copied and pasted each section to the SQL update box. Does the whole thing need to be done at one shot or can I cut and paste one paragraph of the update at a time? It looked to me like they were almost 3 separate pieces with closing brackets so I did one section at a time, copy and paste. I'm not a programmer but it was not stated that I had to copy and paste the entire section at one time in to the SQL patch input. I'll try it that way I guess. Didn't occur to me when I was actually installing it that maybe all three sections of code had to go at one time. Is that maybe the reason?

[SageSystems]

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));

[tyankee]

OK, i just installed this module and went into admin and see the new pull down for 'subscriptions/payments' and i went into ti as see taht i must first create a product subscription through the product page. i went to a product, set the price to 0 but could find NOWHERE on the page a pull down to select subscription.. i also noticed that the product page is product.php and there are no changes to that file in my download - was i missing something??

[tyankee]

does anyone read this thread??? i posted over 24 hours ago and my website is in 'limbo' waiting for an answer..

[DrByte]

If you're referring to a module you got from someone else's website, then you're likely going to have to contact *them* directly for support.

It sounds like you've probably not properly installed the addon ... but, not being familiar with it I'm unable to give you specific help. Best to ask the author.

[tyankee]

i thought this thread was FOR this module???

If you're referring to a module you got from someone else's website, then you're likely going to have to contact *them* directly for support.

It sounds like you've probably not properly installed the addon ... but, not being familiar with it I'm unable to give you specific help. Best to ask the author.