Testimonial Manager Support Thread

[KarmaCharms]

this thing caused my entire shop to break, there were SQL errors on every page. Had to immediately uninstall it. Sucks, because I really would have liked to use this mod, but not at the cost of breaking my shop.

[thomasw98]

this thing caused my entire shop to break, there were SQL errors on every page. Had to immediately uninstall it. Sucks, because I really would have liked to use this mod, but not at the cost of breaking my shop.

I got it working with no problems at all, and I am not a real computer nerd (just a fake one!).

Of course, with all of these zencart modules things, you have to be very careful when uploading all the new files and making the needed modifications. It is really easy to forget something or to put it in the wrong folder by accident. (the one that always confuses me is the temples/YOURTEMPLATENAME/templates folder...that just doesn't make sense to me...how can a "templates" folder be inside another "templates" folder?! Not very good librarian logic on that one).

Always backup any files that might be replaced and backup your database before starting. It sounds like you did that and were able to get back to square one, so that's good news.

If you want to give it another go, let us know first what version zencart you have and what version of testimonials manager you are trying to install. Also explain what problems your encountered last time.

Good luck!

[KarmaCharms]

OK, I'm running ZC 1.3.7 and I'm trying to install the newest release of this mod. If it helps at all, I'm also running other mods that this might not be compatible with. I've got the Google Analytics mod on board as well as SEO Urls, a few custom pages, Google Sitemaps, Google Base Feeder, Referrals mod... I think that's it.

If you have some sort of instant messenger and would be willing to lend me a hand, I'd greatly appreciate it!

I don't have my template renamed as anything, I just made CSS edits to the original template and I'm pretty sure I uploaded all the files to the right directories (I have template folders called classic and template_default FWIW and most mods I have installed have gone in the template_default folders without issue).

[KarmaCharms]

Oh and I am also running Cross Sell mod

[KarmaCharms]

And Quick Updates LOL

[KarmaCharms]

OK I reuploaded everything double checking file structure, and reinstalled the SQL patch...

I get these errors:

Warning: Variable passed to each() is not an array or object in /home/karmarc/public_html/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/karmarc/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/karmarc/public_html/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/karmarc/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/karmarc/public_html/includes/init_includes/init_templates.php on line 78

Warning: Division by zero in /home/karmarc/public_html/includes/classes/split_page_results.php on line 76
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_PRODUCTS_LISTING' at line 7
in:
[select p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '45' limit -0, MAX_DISPLAY_PRODUCTS_LISTING]

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUC' at line 13
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20071007 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

[thomasw98]

Sounds like you will need to wait for "super Clyde" to help on this one since it is a mess of SQL errors. But I would bet money that he can figure it out for you. Sorry to not be able to help.

By the way, "Karma Charms" is a great name for your product and target customer. Nice marketing strategy!

[clydejones]

OK I reuploaded everything double checking file structure, and reinstalled the SQL patch...

I get these errors:

Warning: Variable passed to each() is not an array or object in /home/karmarc/public_html/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/karmarc/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/karmarc/public_html/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/karmarc/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/karmarc/public_html/includes/init_includes/init_templates.php on line 78

Warning: Division by zero in /home/karmarc/public_html/includes/classes/split_page_results.php on line 76
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_PRODUCTS_LISTING' at line 7
in:
[select p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '45' limit -0, MAX_DISPLAY_PRODUCTS_LISTING]

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUC' at line 13
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20071007 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

Sorry, None of these errors has anything to do with Testimonial Manager.

It appears to have something to do with displaying the upcoming products.

[clydejones]

Hi Clyde:

Is there any way I can turn off the need for the admin to moerate every testimonial (i.e. approve each one before they appear on the site)?

I have already adjusted the setting in admin/config/testimonials manager menu to allow users that are not logged in to leave testimonials. But I can not find anywhere to turn off moderation. I looked in the config menu and also the tools/tesimonials manager menu, but no luck.

Thanks,

Thomas

The status should be set to approved by default.

But let me double check just to be sure.

[Moonq]

Hi i have an issue with my sidebox.
it simply doesnt want to show up - niether on the right side or the left side. I have defined all the paths correctly. Any idea what might be the issue?

im running ZC 1.3.8. and the latest version of Testimonial Manager.
My template name is iC_AthemeV1.3

In admin everything is fine. I didnt get any errors during the sql installation etc. I just cannot make the siebox to show up on my site
www.g2play.pl

Any tips are appriciated.