Re: Free Gifts-Dangling Carrot support
If you're using the Install SQL Patches, the backticks should be removed, too
Code:
# Add the following to your database via Zen Cart Admin.
# NOTE...IF YOU USE A DATABASE PREFIX YOU MUST ADD IT INTO THESE TABLE UPDATES - FOR EXAMPLE:
# If your db prefix is zen_, then change
# CREATE TABLE free_gifts (
# to
# CREATE TABLE zen_free_gifts (
CREATE TABLE free_gifts (
gift_id tinyint( 4 ) NOT NULL AUTO_INCREMENT ,
threshold mediumint( 9 ) NOT NULL default '0',
products_id mediumint( 9 ) NOT NULL default '0',
PRIMARY KEY ( gift_id )
) ENGINE= MyISAM ;
Re: Free Gifts-Dangling Carrot support
i managed to install this mod on 1.5.0 the only problem i have is carrot item that is being hidden because the price set at $0.00 is searchable. It is possible to add this product into cart from search, it shows you have 1 item in shopping cart, but then shopping-cart page shows nothing and on refresh the item dissappeares from the shopping cart. so not big of a deal, but still looks like a bug. anyone knows how to fix this?
Re: Free Gifts-Dangling Carrot support
i need some help sorting this bug out, and it occurs when customer adds the free gift into a cart, and then does a search for free gift, then he is able to add same free gift again via "add to cart" button. How to make this free gift items non searchable, or how to disable "add to cart" button on them in any other situations besides under checkout page when they are eligible to add a free gift.
thanks
Re: Free Gifts-Dangling Carrot support
I would like to install this to my 1.5.1 cart as well. Hopefully some of the better minds out there are working on it. I am willing to kick in for a few hours of time via paypal (if that is allowed?). for the good of all.
Re: Free Gifts-Dangling Carrot support
Does this contribution work with 1.5.1 please, or is there an alternative?
Thanks
Re: Free Gifts-Dangling Carrot support
Sorry...posted twice....internet problem
Re: Free Gifts-Dangling Carrot support
Can anybody please tell me if this works properly with 1.3.9h?
Many Thanks
Re: Free Gifts-Dangling Carrot support
Hi...
Just installed and got this error:
1146 Table 'london_zc5.zen_free_gifts' doesn't exist
in:
[SELECT fg.*, p.products_id, p.products_model, p.products_price, p.products_image, p.products_status, pd.products_name FROM (zen_free_gifts fg, zen_products p) LEFT JOIN zen_products_description pd ON (pd.products_id=fg.products_id) WHERE pd.language_id = '5' AND p.products_id = fg.products_id ORDER BY fg.threshold ASC]
Cannot do anything in link on admin side, but cannot add product to shopping cart with out same error showing. Site is down. Any help would be GREATLY appreciated.
Re: Free Gifts-Dangling Carrot support
I have uninstalled the module...thanks. :)
Re: Free Gifts-Dangling Carrot support
Quote:
Originally Posted by
amandavz
Hi...
Just installed and got this error:
1146 Table 'london_zc5.zen_free_gifts' doesn't exist
in:
[SELECT fg.*, p.products_id, p.products_model, p.products_price, p.products_image, p.products_status, pd.products_name FROM (zen_free_gifts fg, zen_products p) LEFT JOIN zen_products_description pd ON (pd.products_id=fg.products_id) WHERE pd.language_id = '5' AND p.products_id = fg.products_id ORDER BY fg.threshold ASC]
Cannot do anything in link on admin side, but cannot add product to shopping cart with out same error showing. Site is down. Any help would be GREATLY appreciated.
Looks like the sql patch didn't take which is why you got this error message. I would recommend trying the sql patch again. The zen_free_gift table was not created in the db. If you used lat9's sql from the above post, you need to uncomment the one line (create table zen_free_gifts) and comment the one below it.