Page 1 of 24 12311 ... LastLast
Results 1 to 10 of 236
  1. #1
    Join Date
    Nov 2005
    Posts
    442
    Plugin Contributions
    4

    Default Free Gifts-Dangling Carrot support

    This is the official thread for support on the Zen Cart port of Dangling Carrot.
    In the early release, many core files are modified. This port was quite complex and we are hoping to modify the code to reduce the number of core files that are overwritten.


    While we did a lot of testing on the mod prior to release, there may be things we missed, so if you experience any problems with the mod, please post them here.

    Regards
    Steve

  2. #2
    Join Date
    May 2005
    Location
    England
    Posts
    600
    Plugin Contributions
    0

    Default Re: Free Gifts-Dangling Carrot support

    Hello there,

    So far, I get this on the shopping cart page:-

    1146 Table 'gemtree_zc2.products' 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, products p) LEFT JOIN products_description pd ON (pd.products_id=fg.products_id) WHERE pd.language_id = '1' AND p.products_id = fg.products_id ORDER BY fg.threshold ASC]
    I reckon it is because I use prefix. The error disappears when I remove main_template_vars.php from includes/modules/pages/shopping_cart though.

    Thanks

    Heathenmagic

  3. #3
    Join Date
    Nov 2005
    Posts
    442
    Plugin Contributions
    4

    Default Re: Free Gifts-Dangling Carrot support

    Are you using V1.1, or V1.2 which was made available earlier today?

  4. #4
    Join Date
    May 2005
    Location
    England
    Posts
    600
    Plugin Contributions
    0

    Default Re: Free Gifts-Dangling Carrot support

    Hello there,

    I am using V1.2. I am just going through the install and checking I haven't missed anything.

  5. #5
    Join Date
    May 2005
    Location
    England
    Posts
    600
    Plugin Contributions
    0

    Default Re: Free Gifts-Dangling Carrot support

    Hello Steve,

    I tried the Free Gifts under catalog in the admin, and I get a similar message on there. I am sure I have everything installed nicely, and I put the SQL statement through ok.

    Regards,

    James

  6. #6
    Join Date
    Nov 2005
    Posts
    442
    Plugin Contributions
    4

    Default Re: Free Gifts-Dangling Carrot support

    Hi James,

    Can you tell me what version of MySql is being used on your server?
    You can get this info from Zen admin under tools, server/version info.

    This error is not something that i've had during numerous test installs, so bear with me while i try and re-create the problem here.

    Thanks
    Steve

  7. #7
    Join Date
    May 2005
    Location
    England
    Posts
    600
    Plugin Contributions
    0

    Default Re: Free Gifts-Dangling Carrot support

    Hello Steve,

    Thanks for getting back to me so quick. I have the following php:-

    PHP Version: 4.4.9 (Zend: 1.3.0)

    In the meantime, I put zen_ in front of the tables those two files couldn't find, and I am getting into the admin Free Gifts page. I'll let you know if I see anything else.

    Regards,

    James

  8. #8
    Join Date
    Nov 2005
    Posts
    442
    Plugin Contributions
    4

    Default Re: Free Gifts-Dangling Carrot support

    Hi James,

    The problem is caused by the additional SQL queries inserted into the database.
    They do not have the prefix that has been used when your original site was configured.
    Neither the new tables, or the modified tables will be correct.

    Please see the following SQL query, and substitute YOUR PREFIX with whatever you have set as a prefix.
    Run the query either through zen admin, or phpmyadmin.
    Be sure to back up your database first.

    CREATE TABLE `YOUR PREFIX_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`)
    ) TYPE=MyISAM;

    insert into YOUR PREFIX_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values (1200, 'Gifts Image Width', 'GIFTS_IMAGE_WIDTH', '90', 'The pixel width of heading images', '4', '25', now(), now(), NULL, NULL);
    insert into YOUR PREFIX_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values (1201, 'Gifts Image Height', 'GIFTS_IMAGE_HEIGHT', '100', 'The pixel height of heading images', '4', '26', now(), now(), NULL, NULL);
    UPDATE YOUR PREFIX_configuration_group SET sort_order=last_insert_id() WHERE configuration_group_id=last_insert_id();

    ALTER TABLE `YOUR PREFIX_products` ADD `products_carrot` tinyint(1) default '0' AFTER `products_status` ;

    That should solve all your problems.

    Regards
    Steve

  9. #9
    Join Date
    May 2005
    Location
    England
    Posts
    600
    Plugin Contributions
    0

    Default Re: Free Gifts-Dangling Carrot support

    Hello Steve,

    Many thanks, I had a strong feeling it was something like that. I will upload those two files again, and apply that modified SQL statement. I was wondering, could this also affect the way the shopping cart box and gifts box works? I have a random amount of 5 products in the gift box - but only made 1 free gift so far. And the message for free gift qualify doesn't appear in the shopping cart also. I have no error messages appearing anywhere.

    Thanks in advance,
    James

  10. #10
    Join Date
    Nov 2005
    Posts
    442
    Plugin Contributions
    4

    Default SQL updates

    Yes, the incorrect table alterations in the db will cause a lot of the mod to function incorrectly. The cart message relies on various information pulled from the database, if the relevant variables are not filled, then the message will not display.

    Let me know if you have any more problems.

    Regards
    Steve

 

 
Page 1 of 24 12311 ... LastLast

Similar Threads

  1. Free Gifts - Dangling Carrot installation question
    By simpledomaining in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 26 Oct 2011, 03:27 PM
  2. Dangling carrot
    By strelitzia in forum All Other Contributions/Addons
    Replies: 13
    Last Post: 8 Dec 2009, 10:43 PM
  3. Dangling Carrot - lost my admin
    By tonyb in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 5 Nov 2008, 11:19 PM
  4. Dangling Carrot Mod
    By strelitzia in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 5 Oct 2008, 11:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR