Testimonial Manager Support Thread

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

[clydejones]

The status should be set to approved by default.

But let me double check just to be sure.

thomasw98,

If you want to have the status to always be approved,

open includes/modules/pages/testimonials_add/header_php.php
find the following lines of code:

$insert_sql_data = array('date_added' => 'now()',
'status' => '0');

change the highlighted portion to 1

save the file and upload to your server.

[thomasw98]

Thanks again!

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

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

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

I just made sure that all settings for upcoming products were disabled and now I am getting a whole new slew of errors:

Header 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

and then where my products should be:

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 = '2' limit -0, MAX_DISPLAY_PRODUCTS_LISTING]

Take a look at my site if you can, I'm going to leave it for now with the errors so you can see what it's doing. The second I uninstall the testimonials SQL, everything works as it should, which leads me to believe it's the mod causing it.

[KarmaCharms]

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!

Thanks! Karma is actually my dog and the name was a play on the product offering and the dog LOL!

[clydejones]

I just made sure that all settings for upcoming products were disabled and now I am getting a whole new slew of errors:

Header errors:




and then where my products should be:



Take a look at my site if you can, I'm going to leave it for now with the errors so you can see what it's doing. The second I uninstall the testimonials SQL, everything works as it should, which leads me to believe it's the mod causing it.

I checked your site and didn't see any of the errors you indicated.

On which page (s) do they occur?

[KarmaCharms]

OK I had to disable it again as it was totally breaking the shop and I noticed that I had a ton of customers online. I'll reenable it now and you can feel free to click around.

Here's the super odd part... install the SQL patch for this mod, everything goes bonkers... uninstall it, everything works just fine. Didn't remove any of the uploaded files for this mod, they are all still there, so it has something to do with the SQL.

Thanks!

[KarmaCharms]

OK got the SQL reinstalled and plan to leave it now overnite (I'm in Spain so it's overnight for me) and will check this thread in the morning, hope we can figure this out because I REALLY want to use this mod.