many �� appears

**mc12345678** · 12 Jul 2014, 05:48 PM

Replace YOUR_ADMIN/includes/init_includes/init_tm_config.php with the following code there are other improvements that could be made to it, but this should resolve this issue.

Code:

<?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_ra_config.php 2.3.3a 7/15/2012 C Jones $
 */

//$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);

(testimonials_id, 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)


//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 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 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 = "INSERT 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)";
    $db->Execute($sql);
    $sql = "INSERT 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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);

**jsarwar** · 12 Jul 2014, 06:31 PM

Changed and now admin does not load login section, only blank page.

**mc12345678** · 12 Jul 2014, 06:34 PM

Originally Posted by jsarwar

See attached. The only difference I can see in sort order and ids I think. Attachment 14275

In your 1.3.9 environment, if you still have the ability, could you try the following SQL commands in your myphpadmin environment and identify the results? (one at a time should do the trick).

Code:

SELECT * FROM configuration_group WHERE `configuration_group_title` LIKE 'Manufacturers All Config' LIMIT 2;
SELECT * FROM configuration WHERE `configuration_description` LIKE 'Manufacturers All Listing:%' LIMIT 7;

If you have a table prefix, include it prior to the configuration_group or configuration statement as applicable. (You seem to know what you are doing, but others may not follow without that type of additional instruction.)

**mc12345678** · 12 Jul 2014, 06:40 PM

Ooops, I left a string of text in the code that should not have been there when run. Sorry... :) It is highlighted in red between the new comment tags. You can completely remove that line or leave as commented, but it is what caused the blank screen. Again sorry...

That should have also generated an error log in your cache directory (ZC 1.5.0, or logs directory in ZC 1.5.1) BTW, you should really at least upgrade to 1.5.1 if you are going to use a 1.5.x version. You may be able to go as far as 1.5.3, but until the plugins you are using are upgraded, I would hold off to do that.

Originally Posted by mc12345678

Replace YOUR_ADMIN/includes/init_includes/init_tm_config.php with the following code there are other improvements that could be made to it, but this should resolve this issue.

Code:

<?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_ra_config.php 2.3.3a 7/15/2012 C Jones $
 */

//$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);

 /*(testimonials_id, 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)*/


//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 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 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 = "INSERT 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)";
    $db->Execute($sql);
    $sql = "INSERT 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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);

**jsarwar** · 12 Jul 2014, 06:48 PM

Originally Posted by mc12345678

Ooops, I left a string of text in the code that should not have been there when run. Sorry... :) It is highlighted in red between the new comment tags. You can completely remove that line or leave as commented, but it is what caused the blank screen. Again sorry...

That should have also generated an error log in your cache directory (ZC 1.5.0, or logs directory in ZC 1.5.1) BTW, you should really at least upgrade to 1.5.1 if you are going to use a 1.5.x version. You may be able to go as far as 1.5.3, but until the plugins you are using are upgraded, I would hold off to do that.

Worked now.

Thank you so much.

**mc12345678** · 12 Jul 2014, 08:30 PM

Originally Posted by jsarwar

Worked now.

Thank you so much.

Originally Posted by mc12345678

In your 1.3.9 environment, if you still have the ability, could you try the following SQL commands in your myphpadmin environment and identify the results? (one at a time should do the trick).

Code:

SELECT * FROM configuration_group WHERE `configuration_group_title` LIKE 'Manufacturers All Config' LIMIT 2;
SELECT * FROM configuration WHERE `configuration_description` LIKE 'Manufacturers All Listing:%' LIMIT 7;

If you have a table prefix, include it prior to the configuration_group or configuration statement as applicable. (You seem to know what you are doing, but others may not follow without that type of additional instruction.)

Welcome, still trying to resolve why the script didn't work on it's own and why you had to go into the myphpadmin to do what it was supposed to do. Could you please see the above request, take action and respond. An update can then be offered to the community, otherwise nothing really was accomplished for anyone else.

**jsarwar** · 12 Jul 2014, 10:20 PM

Originally Posted by mc12345678

Welcome, still trying to resolve why the script didn't work on it's own and why you had to go into the myphpadmin to do what it was supposed to do. Could you please see the above request, take action and respond. An update can then be offered to the community, otherwise nothing really was accomplished for anyone else.

I ran on a test site which is also 1.5.0 and it says "Success 2 statements processed."
So these two lines worked.
Question. Why these does not have word delete like the first one?

**jsarwar** · 12 Jul 2014, 10:32 PM

So far what we have gone over I noticed that modules files does work on fresh installation of ZC 1.5 but if upgrading from 1.3 to 1.5 then we have to use the sql you sent me for both plug in "Manufacturer All" and "Testimonial Manager".

So may be you can upload these plugins again on ZC Plug in page with included information and files for community members.

These two lines did remove Manufacturer Config... options from configuration. So these did work how I don't know because I don't see delete in there.

SELECT * FROM configuration_group WHERE `configuration_group_title` LIKE 'Manufacturers All Config' LIMIT 2;
SELECT * FROM configuration WHERE `configuration_description` LIKE 'Manufacturers All Listing:%' LIMIT 7;

**mc12345678** · 12 Jul 2014, 11:06 PM

Originally Posted by jsarwar

I ran on a test site which is also 1.5.0 and it says "Success 2 statements processed."So these two lines worked. Question. Why these does not have word delete like the first one?

The delete statement would modify your database and I didn't want to do that. All I wanted to do was see was what the sql command would try to act on. This is a standard way to identify that when the desired database modification is finally programmed in, what data will be modified. I wanted to see if your 1.3.9 database understood the "question" (sql query) and was trying to delete the desired code, because as reported earlier you had to manually delete information in your updated database which meant to me that the 1.3.9 data had something different in it than what the 1.5.0 queries were looking for. (By the way, sorry for the poor english, sentences should not end with prepositions such as for, on,of, etc.. :) )

**mc12345678** · 12 Jul 2014, 11:09 PM

Originally Posted by jsarwar

So far what we have gone over I noticed that modules files does work on fresh installation of ZC 1.5 but if upgrading from 1.3 to 1.5 then we have to use the sql you sent me for both plug in "Manufacturer All" and "Testimonial Manager". So may be you can upload these plugins again on ZC Plug in page with included information and files for community members. These two lines did remove Manufacturer Config... options from configuration. So these did work how I don't know because I don't see delete in there. SELECT * FROM configuration_group WHERE `configuration_group_title` LIKE 'Manufacturers All Config' LIMIT 2;SELECT * FROM configuration WHERE `configuration_description` LIKE 'Manufacturers All Listing:%' LIMIT 7;

I would aver that unless you specifically checked the database before running those queries to verify that the data was present, that actually they were deleted in the earlier efforts to get this to work.A select query does not modify the database.

Thread: many �� appears

Thread Tools

Search Thread

Display

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Similar Threads

category longer than 16 characters �

how do I get rid of �

� - Can't figure out how to remove

spanish accents show up as �

what is this? �

Posting Permissions

Thread: many ���� appears

Re: many ���� appears

Re: many ���� appears

Re: many ���� appears

Re: many ���� appears

Re: many ���� appears

Re: many ���� appears

Re: many ���� appears

Re: many ���� appears

Re: many ���� appears

Re: many ���� appears

Similar Threads

Posting Permissions

Thread: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears

Re: many �� appears