Testimonial Manager Support Thread (for ZC v1.5.x)

DivaVocals:

Please re-read my post.. I state what's missing..

I read that but I am not good on sql so if you don't mind can you tell me what I need to type/put in for numinix column in sql to make it go through on my site?

jsarwar:

I read that but I am not good on sql so if you don't mind can you tell me what I need to type/put in for numinix column in sql to make it go through on my site?

so... basically, you have more or less columns in the configuration table then data you are trying to fit in. Should only be 11 for the standard ZC Config table. I for one have no idea what you have in there... or why anyone would change it. makes upgrading ZC very hard to do. So, look at the table with phpmyadmin and see what the structure is and fill in the blank... this is the standard 11 column table..

(configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

You will have to fill in the blank at the same location it shows with in your config structure.. hopefully at the end... so 'set_function', NULL) you would have to figure out what goes there... NULL is just a common guess, a coma would get you there too.

What ever mod you install that adds to the configuration table may have the same issues so keep notes and be aware of it.

davewest:

so... basically, you have more or less columns in the configuration table then data you are trying to fit in. Should only be 11 for the standard ZC Config table. I for one have no idea what you have in there... or why anyone would change it. makes upgrading ZC very hard to do. So, look at the table with phpmyadmin and see what the structure is and fill in the blank... this is the standard 11 column table..

(configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)

You will have to fill in the blank at the same location it shows with in your config structure.. hopefully at the end... so 'set_function', NULL) you would have to figure out what goes there... NULL is just a common guess, a coma would get you there too.

What ever mod you install that adds to the configuration table may have the same issues so keep notes and be aware of it.I will bet MONEY it's a Numinix module.. they are the ONLY mod devs that added a column to the configuration table to support their custom tabbed view of the configuration settings for their modules. The change makes an overall change to the look/feel of ALL the configuration menus not just their own.. However, only the Numinix modules explicitly use this tabbed view.. The Numinix mods aren't having issues at all.. only those module (like this one which use the shortcut SQL which omits the column names from the SQL script)

And before the question gets asked in response to your post "how do I add the columns back", Chad already posted a few threads back that he submitted an update..

DivaVocals:

I will bet MONEY it's a Numinix module.. they are the ONLY mod devs that added a column to the configuration table to support their custom tabbed view of the configuration settings for their modules. The change makes an overall change to the look/feel of ALL the configuration menus not just their own.. However, only the Numinix modules explicitly use this tabbed view.. The Numinix mods aren't having issues at all.. only those module (like this one which use the shortcut SQL which omits the column names from the SQL script)

And before the question gets asked in response to your post "how do I add the columns back", Chad already posted a few threads back that he submitted an update..

The update is considered available for download. Like davewest suggested, the additional field(s) added to. The table are not addressed per se in the update, ie. If the other plugin(s) expect a value in that row, install of this plugin will assign whatever default value is expected and it is up to that other plugin(s) to correct/handle that default value.

Jsarwar has indicated that at least one numinix module was installed, but review of the provided sql (which does not include sql embedded in the code) did not show indication of modifying the table(s) that were preventing the installation. The change made removes the reliance on the number of columns and also allows certain fields to populate with default information. (Configuration_id for example) rather than guessing at the data type necessary (NULL or 0) to populate the field. It is therefore up to the table altering code to handle the new data that did not assign anything to the new field(s). This action would be expected of any plugin that modified core table fields in this way.

This is why numinix posted that sql updates to the databse should not be done blindly and should include the column names.

yaritai:

This is why numinix posted that sql updates to the databse should not be done blindly and should include the column names.
Agreed:yes:; you never know when an additional field will be added to a table, whether by plugin or by Zen Cart upgrade.

Good day folks.

I tried to display testimonials at the footer, I've done this at the past but now I can't figure it out.

I guess I'm too old for this coding stuff already :D

Please kindly give me a hint how to do that

Thanks!!

How do I make the Testimonial Title field optional and delete it totally?

robbie269:

How do I make the Testimonial Title field optional and delete it totally?

I believe the file to edit is:
/includes/modules/pages/testimonials_add/header_php.php

countrycharm:

I believe the file to edit is:
/includes/modules/pages/testimonials_add/header_php.php
Thanks that did the trick.

robbie269:

Thanks that did the trick.

No problem, glad to help.

I got a questionabout install 1.5.3d in zen-cart 1.54 .I'm a little confused as to what I may have done wrong about install

I was running 1.3.8a before with this module, no problems

I then upgraded my store to 1.5.4.only thing that was carried over from the old installation was the old testimonial database tables.......all php files are the new versions for 1.5.

I get the following security message:

"WARNING: An Error occurred, please refresh the page and try again."
When I remove all the files of TM, that error goes away but the module is not auto-installed.

Any idea what I could do in order to fix this problem?

I got the Debug log here:

[03-Feb-2015 03:44:51 America/New_York] PHP Fatal error: 1062: Duplicate entry 'DEFINE_TESTIMONIAL_STATUS' for key 'unq_config_key_zen' :: INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Define Testimonial Status', 'DEFINE_TESTIMONIAL_STATUS', '1', 'Enable the Defined Testimonial Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '42', 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),') ==> (as called by) /home/playscom/public_html/demo/admin/includes/init_includes/init_tm_config.php on line 121 <== in /home/playscom/public_html/demo/includes/classes/db/mysql/query_factory.php on line 155

Thank you

paranoia:

I got a questionabout install 1.5.3d in zen-cart 1.54 .I'm a little confused as to what I may have done wrong about install

I was running 1.3.8a before with this module, no problems

I then upgraded my store to 1.5.4.only thing that was carried over from the old installation was the old testimonial database tables.......all php files are the new versions for 1.5.

I get the following security message:

"WARNING: An Error occurred, please refresh the page and try again."
When I remove all the files of TM, that error goes away but the module is not auto-installed.

Any idea what I could do in order to fix this problem?

I got the Debug log here:

[03-Feb-2015 03:44:51 America/New_York] PHP Fatal error: 1062: Duplicate entry 'DEFINE_TESTIMONIAL_STATUS' for key 'unq_config_key_zen' :: INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Define Testimonial Status', 'DEFINE_TESTIMONIAL_STATUS', '1', 'Enable the Defined Testimonial Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '42', 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),') ==> (as called by) /home/playscom/public_html/demo/admin/includes/init_includes/init_tm_config.php on line 121 <== in /home/playscom/public_html/demo/includes/classes/db/mysql/query_factory.php on line 155

Thank you
Try replacing the ALL the code in YOUR_ADMIN/includes/init_includes with the following..

<?php
/**
 * Testimonial Manager
 *
 * @copyright Copyright 2003-2005 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: init_tm_config.php 2.3.3b 7/12/2014 mc12345678 $
 */

//$messageStack->add('Testimonials Manager v1.5.4 install started','success');

$sql = "CREATE TABLE IF NOT EXISTS ".DB_PREFIX."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)
)";
    $db->Execute($sql);

//check if sample testimonial exists and if it does not exist, then add it
    $tm_sample_name = 'Clyde Designs';
    $sql ="SELECT * FROM ".DB_PREFIX."testimonials_manager WHERE testimonials_name = '".$tm_sample_name."'";
    $result = $db->Execute($sql);
    if(!$result->RecordCount())
    {
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."testimonials_manager (language_id, testimonials_title, testimonials_url, testimonials_name, testimonials_image, testimonials_html_text, testimonials_mail, testimonials_company, testimonials_city, testimonials_country, testimonials_show_email, status, date_added, last_update) VALUES (1, 'Great', '', 'Clyde Designs', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 0, 1, now(), NULL)";
    $db->Execute($sql);
    }

    $tm_menu_title = 'Testimonials Manager';
    $tm_menu_text = 'Testimonials Manager Display Settings';

    /* find if Testimonial Manager Configuration Group Exists */
    $sql = "SELECT * FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title = '".$tm_menu_title."'";
    $original_config = $db->Execute($sql);

    if($original_config->RecordCount())
    {
        // if exists updating the existing Testimonial Manager configuration group entry
        $sql = "UPDATE ".TABLE_CONFIGURATION_GROUP." SET 
                configuration_group_description = '".$tm_menu_text."' 
                WHERE configuration_group_title = '".tm_menu_title."'";
        $db->Execute($sql);
        $sort = $original_config->fields['sort_order'];

    }else{
        /* Find max sort order in the configuation group table -- add 2 to this value to create the Testimonial Manager configuration group ID */
        $sql = "SELECT (MAX(sort_order)+2) as sort FROM ".TABLE_CONFIGURATION_GROUP;
        $result = $db->Execute($sql);
        $sort = $result->fields['sort'];

        /* Create Testimonial Manager configuration group */
        $sql = "INSERT IGNORE INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('".$tm_menu_title."', '".$tm_menu_text."', ".$sort.", '1')";
        $db->Execute($sql);
   }

    /* Find configuation group ID of Testimonial Manager */
    $sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='".$tm_menu_title."' LIMIT 1";
    $result = $db->Execute($sql);
        $tm_configuration_id = $result->fields['configuration_group_id'];

    /* Remove Testimonial Manager items from the configuration table */
    $sql = "DELETE FROM ".DB_PREFIX."configuration WHERE configuration_group_id ='".$tm_configuration_id."'";
        $db->Execute($sql);

//-- ADD VALUES TO TESTIMONIAL MANAGER CONFIGURATION GROUP (Admin > Configuration > Testimonial Manager) --
    $sql = " ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '".$tm_configuration_id."', 1, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Title Minimum Length', 'ENTRY_TESTIMONIALS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', '".$tm_configuration_id."', 2, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Text Minimum Length', 'ENTRY_TESTIMONIALS_TEXT_MIN_LENGTH', '10', 'Minimum length of Testimonial description.', '".$tm_configuration_id."', 3, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Text Maximum Length', 'ENTRY_TESTIMONIALS_TEXT_MAX_LENGTH', '1000', 'Maximum length of Testimonial description.', '".$tm_configuration_id."', 3, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Contact Name Minimum Length', 'ENTRY_TESTIMONIALS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', '".$tm_configuration_id."', 4, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Truncated Testimonials in Sidebox', 'DISPLAY_TESTIMONIALS_MANAGER_TRUNCATED_TEXT', 'true', 'Display truncated text in sidebox', '".$tm_configuration_id."', 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Length of truncated testimonials to display', 'TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH', '150', 'If Display Truncated Testimonials in Sidebox is true - set the amount of characters to display from the Testimonials in the Testimonials Manager sidebox.', '".$tm_configuration_id."', 6, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Number Of Testimonials to display on all testimonials page', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS', '5', 'Set the number of testimonials to display on the all testimonials page.', '".$tm_configuration_id."', 7, NULL, now(), NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Date Published on Testimonials page', 'DISPLAY_TESTIMONIALS_DATE_PUBLISHED', 'true', 'Display date published on testimonials page', '".$tm_configuration_id."', 8, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display View All Testimonials Link In Sidebox', 'DISPLAY_ALL_TESTIMONIALS_TESTIMONIALS_MANAGER_LINK', 'true', 'Display View All Testimonials Link In Sidebox', '".$tm_configuration_id."', 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Add New Testimonial Link In Sidebox', 'DISPLAY_ADD_TESTIMONIAL_LINK', 'true', 'Display Add New Testimonial Link In Sidebox', '".$tm_configuration_id."', 10, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Image Width', 'TESTIMONIAL_IMAGE_WIDTH', '80', 'Set the Width of the Testimonial Image', '".$tm_configuration_id."', 11, NULL, '2007-08-21 12:04:10', NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Image Height', 'TESTIMONIAL_IMAGE_HEIGHT', '80', 'Set the Height of the Testimonial Image', '".$tm_configuration_id."', 12, NULL, '2007-08-21 12:04:10', NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Image Directory', 'TESTIMONIAL_IMAGE_DIRECTORY', 'testimonials/', 'Set the Directory for the Testimonial Image', '".$tm_configuration_id."', 13, NULL, '2007-08-21 12:04:10', NULL, NULL)";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Company Name field', 'TESTIMONIALS_COMPANY', 'true', 'Display Company Name field', '".$tm_configuration_id."', 14, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display City field', 'TESTIMONIALS_CITY', 'true', 'Display City field', '".$tm_configuration_id."', 15, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display Country field', 'TESTIMONIALS_COUNTRY', 'true', 'Display Country field', '".$tm_configuration_id."', 16, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Only registered customers may submit a testimonial', 'REGISTERED_TESTIMONIAL', 'true', 'Only registered customers may submit a testimonial', '".$tm_configuration_id."', 17, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display All Languages', 'TESTIMONIALS_DISPLAY_ALL_LANGUAGES', 'true', 'Display All Languages', '".$tm_configuration_id."', 18, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial - Show Store Name and Address', 'TESTIMONIAL_STORE_NAME_ADDRESS', 'true', 'Include Store Name and Address', '".$tm_configuration_id."', 19, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Define Testimonial Status', 'DEFINE_TESTIMONIAL_STATUS', '1', 'Enable the Defined Testimonial Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '".$tm_configuration_id."', 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),')";
    $db->Execute($sql);
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Testimonial Manager Version', 'TM_VERSION', '1.5.4', 'Testimonial Manager version', '".$tm_configuration_id."', 21, NULL, now(), NULL, NULL)";
    $db->Execute($sql);

   if(file_exists(DIR_FS_ADMIN . DIR_WS_INCLUDES . 'auto_loaders/config.tm.php'))
    {
        if(!unlink(DIR_FS_ADMIN . DIR_WS_INCLUDES . 'auto_loaders/config.tm.php'))
    {
        $messageStack->add('The auto-loader file '.DIR_FS_ADMIN.'includes/auto_loaders/config.tm.php has not been deleted. For this module to work you must delete the '.DIR_FS_ADMIN.'includes/auto_loaders/config.tm.php file manually.  Before you post on the Zen Cart forum to ask, YES you are REALLY supposed to follow these instructions and delete the '.DIR_FS_ADMIN.'includes/auto_loaders/config.tm.php file.','error');
    };
    }

       $messageStack->add('Testimonials Manager v1.5.4 install completed!','success');

    // find next sort order in admin_pages table
    $sql = "SELECT (MAX(sort_order)+2) as sort FROM ".TABLE_ADMIN_PAGES;
    $result = $db->Execute($sql);
    $admin_page_sort = $result->fields['sort'];

    // now register the admin pages
    // Admin Menu for Testimonial Manager Configuration Menu
    zen_deregister_admin_pages('configTestimonialsManager');
    zen_register_admin_page('configTestimonialsManager',
        'BOX_CONFIGURATION_TESTIMONIALS_MANAGER', 'FILENAME_CONFIGURATION',
        'gID=' . $tm_configuration_id, 'configuration', 'Y',
        $admin_page_sort);

    //-- Admin Menu for Testimonial Manager Tools Menu
    zen_deregister_admin_pages('TestimonialsManager');
    zen_deregister_admin_pages('toolsTestimonialsManager');
    zen_register_admin_page('toolsTestimonialsManager',
        'BOX_TOOLS_TESTIMONIALS_MANAGER', 'FILENAME_TESTIMONIALS_MANAGER',
        '', 'tools', 'Y',
        $admin_page_sort);

Sorry for the delay reply,when I use this code ,still have error message: WARNING: An Error occurred, please refresh the page and try again.

But this time Debugs log different.:frusty:

[04-Feb-2015 10:43:54 America/New_York] PHP Fatal error: 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 'zen_configuration (configuration_title, configuration_key, configuration_value, ' at line 1 :: zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '42', 1, NULL, now(), NULL, NULL) ==> (as called by) /home/playscom/public_html/demo/admin/includes/init_includes/init_tm_config.php on line 81 <== in /home/playscom/public_html/demo/includes/classes/db/mysql/query_factory.php on line 155

paranoia:

Sorry for the delay reply,when I use this code ,still have error message: WARNING: An Error occurred, please refresh the page and try again.

But this time Debugs log different.:frusty:

[04-Feb-2015 10:43:54 America/New_York] PHP Fatal error: 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 'zen_configuration (configuration_title, configuration_key, configuration_value, ' at line 1 :: zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '42', 1, NULL, now(), NULL, NULL) ==> (as called by) /home/playscom/public_html/demo/admin/includes/init_includes/init_tm_config.php on line 81 <== in /home/playscom/public_html/demo/includes/classes/db/mysql/query_factory.php on line 155

Modify this:

//-- ADD VALUES TO TESTIMONIAL MANAGER CONFIGURATION GROUP (Admin > Configuration > Testimonial Manager) --    
 $sql = " ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '".$tm_configuration_id."', 1, NULL, now(), NULL, NULL)"; 

to this:

//-- ADD VALUES TO TESTIMONIAL MANAGER CONFIGURATION GROUP (Admin > Configuration > Testimonial Manager) --  
    $sql = "INSERT IGNORE INTO ".DB_PREFIX."configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '".$tm_configuration_id."', 1, NULL, now(), NULL, NULL)"; 

Also going forward, it helps if you use the forum codes to enclose error logs.. so they are readable and not going to be parsed and "mis-interpreted" by the form software..

wow !!　It's works like a charm!!!!!!

awesome!!!
Thank for your fantastic help!!

paranoia:

wow !!　It's works like a charm!!!!!!

awesome!!!
Thank for your fantastic help!!

Thanks for confirming that this worked for you!! (I hadn't had a chance to test it..)

So I have gone through most of the 14 pages here. I've been using the Testimonials Manager on my 1.3.9h site for years. Quite thrilled with the addon.
If I follow all the install instructions for the new version to add this mod to my brand new 1.5.4 site, are there any changes I need to make (assuming, of course, that I follow the instructions and do it correctly...)???

To answer my own question - as long as I do the two most recent mods, it works great. Thanks again!

Hi there :)

I'm hoping someone might be able to help me with an issue I just noticed. I'm using ZC version 1.5.4. The quotes on my testimonials are HUGE! So big that they cover part of the testimonial text. Any way to either make these smaller or remove them all together?

Thanks :)