Free Gifts-Dangling Carrot support

[lat9]

If you're using the Install SQL Patches, the backticks should be removed, too

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

[simpledomaining]

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?

[simpledomaining]

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

[Able]

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.

[Stevis2002]

Does this contribution work with 1.5.1 please, or is there an alternative?

Thanks

[Stevis2002]

Sorry...posted twice....internet problem

[Stevis2002]

Can anybody please tell me if this works properly with 1.3.9h?

Many Thanks

[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.

[amandavz]

I have uninstalled the module...thanks. :)

[lankeeyankee]

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.