Testimonial Manager Support Thread

[countrycharm]

Hi Diva I basically redid sql statement like you said in the first place. The only thing I didn't do was take out the engine part. Thank You for pointing that out. I did some reserch on MyISAM vs InnoDB and found out With the release of MySQL 5.5, InnoDB has become the default storage engine so thank you again. This will maybe cause others not to have the error when installing this module.
And thanks for the other 2 links for the sql errors.



Yes you did, but I we decided to remove them just in case others might not have understood what that was for.

Has been updated and submitted to the downloads. Thanks again Diva, lat9 for the help you provided.

[DivaVocals]

I did some reserch on MyISAM vs InnoDB and found out With the release of MySQL 5.5, InnoDB has become the default storage engine so thank you again. This will maybe cause others not to have the error when installing this module.

You didn't specify InnoDB in your SQL did you?? It would be better to take out the engine altogether than to include one that may not be supported by the shopowner's host.. Not including an engine won't harm anything as the default will be used. Unless there is a reason why a specific DB engine is needed, not including it in the create table statement won't affect the add-on.. (You can take a look at other add-ons and see that it's not always included in create table statements)

Has been updated and submitted to the downloads. Thanks again Diva, lat9 for the help you provided.

You're welcome..

[countrycharm]

You didn't specify InnoDB in your SQL did you?? It would be better to take out the engine altogether than to include one that may not be supported by the shopowner's host.. Not including an engine won't harm anything as the default will be used. Unless there is a reason why a specific DB engine is needed, not including it in the create table statement won't affect the add-on.. (You can take a look at other add-ons and see that it's not always included in create table statements)

You're welcome..

Na I didn't include and engine at all.
I was just letting you know what I read and learned.....

[DivaVocals]

Na I didn't include and engine at all.
I was just letting you know what I read and learned.....

Cool!!

[lat9]

I've got a multilingual site and enabled the "Display All Languages" in the Testimonial Manager admin section (TESTIMONIALS_DISPLAY_ALL_LANGUAGES is the database key). I had a couple of test testimonials in English and switched to a Spanish display ... and none were displayed. Turns out that the database key (above) isn't used at all.

Here's an updated version of /includes/modules/pages/display_all_testimonials/header_php.php that corrects the problem:

<?php
/**
 * Testimonials Manager
 *
 * @package Template System
 * @copyright 2007 Clyde Jones
  * @copyright Portions Copyright 2003-2007 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: Testimonials_Manager.php v1.5.2 4-16-2010 Clyde Jones $
 */
 
  require(DIR_WS_MODULES . 'require_languages.php');
  $breadcrumb->add(NAVBAR_TITLE);
  
  $which_languages = (TESTIMONIALS_DISPLAY_ALL_LANGUAGES == 'true') ? '' : (" and language_id = '" . (int)$_SESSION['languages_id'] . "'");
  
  $testimonials_query_raw = "select * from " . TABLE_TESTIMONIALS_MANAGER . " where status = 1" . $which_languages . " order by date_added DESC, testimonials_title";

  $testimonials_split = new splitPageResults($testimonials_query_raw, MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS);
//EOF

[lat9]

testimonial don't send email to customer when them add testimonial. Why?

The reason that the customer email is not being sent is this line in /includes/languages/english/YOUR_TEMPLATE/testimonials_add.php:

define('EMAIL_SUBJECT', 'Your Testimonial Submission At ' . STORE_NAME . '.' . "\n\n");

The trailing "\n\n" causes the zen_mail function to abort the send because there are new-line characters in the email subject. Simply removing those characters as below enables the customer emails to be sent.

define('EMAIL_SUBJECT', 'Your Testimonial Submission At ' . STORE_NAME . '.');

[stoneroses6300]

I would like to manually put all the testimonials in myself.
I would like to get rid of the "Author's name", "Author's email", and "Testimonial's Title" requirements.

I basically want it setup where I format the whole testimonial in the Testimonial box. I would want to put the name, and company of the testimonial here without their email address.

Also, how would I get rid of "view all testimonials" and "add a testimonial"?

I'm basically looking to use this sidebox to input my own text through the testimonials manager.

Thank you!

-Brian

[BillyBoyle]

@ Brian
you could use a blank sidebox available through the download section and set up a static page for your detailed testimonials. Putting a link in the sidebox to your page.

[DivaVocals]

@ Brian
you could use a blank sidebox available through the download section and set up a static page for your detailed testimonials. Putting a link in the sidebox to your page.

The admin editable sidebox would probably be better.. BUT if we continue this line of discussion (alternatives to this add-on) we should move it off of this support thread..

[mdo82]

I am currently busy with my site to convert to 139, but I am getting an error when installing this script.

I am currently working in Xampp for my site to get right before I go live

What am I doing wrong?

I get also this error by installing a new version of the software.
And the SQL version of Xampp is 5.5.20

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 'TYPE=MyISAM' at line 1
in:
[CREATE TABLE testimonials_manager ( testimonials_id int(11) NOT NULL auto_increment, language_id int(11) NOT NULL default '1', testimonials_title varchar(64) NOT NULL default '', testimonials_url VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_name text NOT NULL, testimonials_image varchar(254) NOT NULL default '', testimonials_html_text text, testimonials_mail text NOT NULL, testimonials_company VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_city VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_country VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_show_email char(1) default '0', status int(1) NOT NULL default '0', date_added datetime NOT NULL default '0000-00-00 00:00:00', last_update datetime NULL default NULL, PRIMARY KEY (testimonials_id) ) TYPE=MyISAM ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields. 

Please help!!