Zen Cart Logo
Forums / General Questions / Need help following mod instructions

Need help following mod instructions

Views: 465

Results 1 to 3 of 3
2 Oct 2013, 2:28 AM
#1
jjensen avatar

jjensen

New Zenner

Join Date:
Aug 2013
Location:
Washington state, USA
Posts:
4
Plugin Contributions:
0

Need help following mod instructions

I'm trying to set up a cart for a local symphony and I need products (tickets) to expire. I found a mod someone wrote here:

http://www.zen-cart.com/showthread.php?95237-Setting-products-to-expire-at-certain-date/page2&p=793533

The problem is I'm new to PHP and SQL, so I'm having problems following the instructions:

Run these 3 sql queries:
ALTER TABLE products ADD products_date_expire DATETIME AFTER products_date_available ;

UPDATE products SET products_date_expire = '2099-12-31';

INSERT INTO configuration VALUES ("", "Use product expire date featured", "PRODUCT_EXP_DATE", "true", "Automatically disable product after expire date", 8, 100, NULL, "2008-09-22 07:55:24", NULL, "zen_cfg_select_option(array(""true"", ""false""), ")

What SQL queries am I running? I can find in phpMyAdmin (version 3.5.8.1) where to run queries, but I am lost following the instructions. I've been searching, but haven't turned anything up and am running out of time. Can anyone provide handholding to a zc newbie?

-Running v. 1.5.1 and Sheffield Blue template.-

2 Oct 2013, 12:33 PM
#2
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Need help following mod instructions

Easiest way would be to paste the SQL (I would do them one at a time) into the box in Admin - Tools - Install SQL Patches and click on Send. The third one doesn't seem to be complete.

Looking at that thread, I'd guess that the mod isn't really ready for primetime. I hope you're installing it on a test site and not your live store. If it weren't for your time constraints someone (maybe me) could check it out on Zencart version 1.5.1.

2 Oct 2013, 8:22 PM
#3
jjensen avatar

jjensen

New Zenner

Join Date:
Aug 2013
Location:
Washington state, USA
Posts:
4
Plugin Contributions:
0

Re: Need help following mod instructions

Thanks for responding. My site is kind of live but still in testing. (We aren't hooked up to any payment module, etc., but it's visible to the public.) How long would it take to get something like this to work? Are we talking 2 weeks, or over a month? I've already missed the arbitrary deadline they gave, but can also argue that they didn't lessen any of my workload, so that deadline wasn't going to work anyway. If I can't have the products expire, I think we'll have to give up on zc and look at other options. Honestly, I've seen a number of people looking for this mod, so if we can get it worked out it might help others. I'm willing to do some work on it with someone (you?) and try and figure this out if it's doable.