Free Gifts-Dangling Carrot support

[strelitzia]

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

[HeathenMagic]

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

[strelitzia]

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

[HeathenMagic]

Hello there,

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

[HeathenMagic]

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

[strelitzia]

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

[HeathenMagic]

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

[strelitzia]

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

[HeathenMagic]

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

[strelitzia]

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