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));
Last edited by SageSystems; 14 Dec 2008 at 06:06 AM.
Hello,
I am having the same problem with the orders showing as $0.00, I changed the product's subscription to NO and it still does the same thing. I don't even see the recurring payment things that were shown in the screen shot you provided. Any help?
I just tried to add a new product without the recurring subscription and it worked fine. When I turn recurring subscriptions on, add a new subscription, and then go to checkout, the price is $0.00 and when I click on confirm order it just sends out the order summary as if it was sold for free
I have installed the files, but am stuck on the database issue. How do I create a database, etc and insert pg. 3 of the readme files? That part has me totally lost.
I have the database situation figured out now, but I'm not getting a subscription setting under the new products so I can set the subscription settings in the new module. Why?
Uploaded files again and it is there!!! Fantastic! :)
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??
Website Developer and Search Engine Optimazation Boise Idaho. Details at BoiseWired.com
does anyone read this thread??? i posted over 24 hours ago and my website is in 'limbo' waiting for an answer..
Website Developer and Search Engine Optimazation Boise Idaho. Details at BoiseWired.com
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.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Bookmarks