many ���� appears

mc12345678:

Also, what version of PHP is your system using and same for your SQL server? Was the above SQL from testimonials manager or a different plugin? I know the rexent author of testimonials manager and it has worked on 1.5.0/.1 in most cases. There are some systems that do not like the method used by the auto installer, but a majority of them are okay. I have seen recently though that statements need to be rewritten like what I did above in order to be acceptedm

PHP Version 5.2.17

The Above SQL is for Manufacturers All plug in. I typed TM in error that's why I mentioned in next message to ignore first message.

Testimonial Manager sql is giving same error and even TM side box is also showing this message now on live site

"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 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES' at line 1
in:
[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from zen_testimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES]
"

with no site footer at bottom. If I turn off TM sidebox it will make footer to appear. Can you please rearrange TM SQL file so I can get this work ok?

IN TM init.config.php file author mentioned :

$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');
};

If we delete autoloader it will not load TM to admin and if we keep it it gives column counts vs row count error.

Thank you.

jsarwar:

I have been running website on ZC 1.3.9 and installed this module and it was working ok. Then I upload ZC 1.5 files to root and ran zc_install to upgrade to 1.5.0 which upgrade the data base to 1.5.0 and most of modules are still appearing on live site but not in admin including this one. I try to install modules again but they did not work because zencart 1.5 structure is different then zencart 1.3 The MySQL error message thrown by phpMyAdmin ("#1136 - Column count doesn't match value count at row 1") tells us that the database structure has changed in this newer release of ZC. Now you sent me sql so I ran it but it still did not show module in admin so I though let's check phpmyadmin and I found this module under configuration/configuration_group which was probably for the sql I ran on 1.3.9 so I deleted it and then ran sql you sent and it showed up module. So what I think sql ran on 1.3.9 ZC tables/values were still in data base but as 1.5 structure is different so they were appearing in admin and nor letting sql generate/show new one. That's exactly I did and may need to do for other modules too.Thank you for so complete of a description. I apologize that I should have been clearer. I was only asking/needing the last part regarding what action was taken after the rewritten script was provided. I almost hate to ask if part of the process could be repeated to make this work one time rather than having to go back into the database.Supposedly the first two statements in the script should have cleared all "necessary" data. ```
DELETE FROM configuration_group WHERE configuration_group_title LIKE 'Manufacturers All Config' LIMIT 2;DELETE FROM configuration WHERE configuration_description LIKE 'Manufacturers All Listing:%' LIMIT 7;

mc12345678:

Thank you for so complete of a description. I apologize that I should have been clearer. I was only asking/needing the last part regarding what action was taken after the rewritten script was provided. I almost hate to ask if part of the process could be repeated to make this work one time rather than having to go back into the database.Supposedly the first two statements in the script should have cleared all "necessary" data. ```
DELETE FROM configuration_group WHERE configuration_group_title LIKE 'Manufacturers All Config' LIMIT 2;DELETE FROM configuration WHERE configuration_description LIKE 'Manufacturers All Listing:%' LIMIT 7;

I talked with Alex Clarke but he said he is no longer working with zencart but he tried to assist me after I sent him DB details and last message I received was 
"The MySQL error message thrown by phpMyAdmin ("#1136 - Column count doesn't match value count at row 1") tells us that the database structure has changed in this newer release of ZC.
 
You will need to compare the new structure with the SQL code and see where the discrepancies lie.
 "

Since then I have not heard from him. 


May be we can remove limit in first two lines as LIKE 'Manufacturers All Listing  is mentioned so it will delete only these or may be increase limit to test.


If you can please let me know the compatible sql for 1.5 for TM so I can finish this today as I want to start working next on a module where customer can store their payment information for future like amazon etc. I am sourcing information on it but want to start after done with current because working on more than 1 is always confusing and cause issued of mixing files like I did in 1 post above. 



Thank you.

jsarwar:

PHP Version 5.2.17The Above SQL is for Manufacturers All plug in. I typed TM in error that's why I mentioned in next message to ignore first message. Testimonial Manager sql is giving same error and even TM side box is also showing this message now on live site"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 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES' at line 1in:[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from zen_testimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES]"with no site footer at bottom. If I turn off TM sidebox it will make footer to appear. Can you please rearrange TM SQL file so I can get this work ok?IN TM init.config.php file author mentioned :$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'); };If we delete autoloader it will not load TM to admin and if we keep it it gives column counts vs row count error. Thank you.Hmm, so what version of SQL server is that? Because there is nothing special about the php version that would make these statements not work. I'll have to have a chat with the recent author. :) I think your system falls into what has been described the "rare" few, though the changes I made to the manufacturer's all module are the same that I have been coding recently because even though it is "more work" it seems to be the method that has to be used by more and more servers. As for the error message, at least one language define file has not been uploaded to your system or it can not be found. Perhaps try to upload the files again? (Sometimes a file doesn't actually make it to the server or errors part wy in transfer.) The define for MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES isn't present so that is why everything else after that doesn't work.

jsarwar:

I talked with Alex Clarke but he said he is no longer working with zencart but he tried to assist me after I sent him DB details and last message I received was "The MySQL error message thrown by phpMyAdmin ("#1136 - Column count doesn't match value count at row 1") tells us that the database structure has changed in this newer release of ZC. You will need to compare the new structure with the SQL code and see where the discrepancies lie. "Since then I have not heard from him. May be we can remove limit in first two lines as LIKE 'Manufacturers All Listing is mentioned so it will delete only these or may be increase limit to test.If you can please let me know the compatible sql for 1.5 for TM so I can finish this today as I want to start working next on a module where customer can store their payment information for future like amazon etc. I am sourcing information on it but want to start after done with current because working on more than 1 is always confusing and cause issued of mixing files like I did in 1 post above. Thank you.Is the needed fix a "one time" thing or is it something you need to be able to reproduce again?If I am not mistaken, the typical action for when the autoinstaller does not work as designed/corrected by Diva Vocals is to perform each action manually. I'll take a look again, but want to be sure that I understand all of the issues.As for the limit issue, right now only you would be able to tell me. If you were to drop all the tables in your database, reload your 1.3.9 data, then perform a database upgrade using zc_install, then look at the entries in those two tables related to this plugin and be able to tell what is "special" about them. I think we would find that there are options installed under 1.3 that are not shown in the 1.5 sql and that actually right now you probably have less options available on 1.5 than you do under 1.3. (Can you confirm this with your current setups?)

mc12345678:

Hmm, so what version of SQL server is that? Because there is nothing special about the php version that would make these statements not work. I'll have to have a chat with the recent author. :) I think your system falls into what has been described the "rare" few, though the changes I made to the manufacturer's all module are the same that I have been coding recently because even though it is "more work" it seems to be the method that has to be used by more and more servers. As for the error message, at least one language define file has not been uploaded to your system or it can not be found. Perhaps try to upload the files again? (Sometimes a file doesn't actually make it to the server or errors part wy in transfer.) The define for MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES isn't present so that is why everything else after that doesn't work.

Software: MySQL
mysql Ver 14.12 Distrib 5.0.92, for pc-linux-gnu (i686) using readline 5.1

I have uploaded all TM files few times and just make sure again and all language files are uploaded correctly. But when try to access admin following error still exists.

""1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_configuration VALUES (NULL, '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.', '82', 1, NULL, now(), NULL, NULL)]
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."

Which disappear if I delete auto_loader file in admin for testimonial manager but then also no Testimonial Manager module in admin.

mc12345678:

Is the needed fix a "one time" thing or is it something you need to be able to reproduce again?If I am not mistaken, the typical action for when the autoinstaller does not work as designed/corrected by Diva Vocals is to perform each action manually. I'll take a look again, but want to be sure that I understand all of the issues.As for the limit issue, right now only you would be able to tell me. If you were to drop all the tables in your database, reload your 1.3.9 data, then perform a database upgrade using zc_install, then look at the entries in those two tables related to this plugin and be able to tell what is "special" about them. I think we would find that there are options installed under 1.3 that are not shown in the 1.5 sql and that actually right now you probably have less options available on 1.5 than you do under 1.3. (Can you confirm this with your current setups?)

After you sent me revised sql "Manufacturer all" Plugin is installed on ZC 1.5.0 and working ok now. The only difference I see is in sort order of rows. For example"

Zencart 1.3.9

Title Value Action
Display Empty Manufacturers 0
Display Manufacturer Image 1 Info
Display Manufacturer URL 0 Info
Manufacturers Per Row 4 Info
Manufacturer Image Width 100px Info
Manufacturer Image Height 100px Info

Zencart 1.5.0

Title Value Action
Manufacturer Image Width 100px
Manufacturer Image Height 100px Info
Display Manufacturer URL 1 Info
Manufacturers Per Row 4 Info
Display Empty Manufacturers 0 Info
Display Manufacturer Image 1 Info

So all options are still same for ZC 1.5 as you can see above.

I just need 1 time fix to have modules on my website ZC 1.5. And SQL you sent me here on forum can also help others to solve similar problems.

jsarwar:

Software: MySQLmysql Ver 14.12 Distrib 5.0.92, for pc-linux-gnu (i686) using readline 5.1I have uploaded all TM files few times and just make sure again and all language files are uploaded correctly. But when try to access admin following error still exists. ""1136 Column count doesn't match value count at row 1in:[INSERT INTO zen_configuration VALUES (NULL, '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.', '82', 1, NULL, now(), NULL, NULL)]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."Which disappear if I delete auto_loader file in admin for testimonial manager but then also no Testimonial Manager module in admin.Thank you for clearing this up in the above summary. Sorry I just recently awoke so memory is not fully engaged. :)

jsarwar:

After you sent me revised sql "Manufacturer all" Plugin is installed on ZC 1.5.0 and working ok now. The only difference I see is in sort order of rows. For example"Zencart 1.3.9 Title Value Action Display Empty Manufacturers 0 Display Manufacturer Image 1 Info Display Manufacturer URL 0 Info Manufacturers Per Row 4 Info Manufacturer Image Width 100px Info Manufacturer Image Height 100px InfoZencart 1.5.0 Title Value Action Manufacturer Image Width 100px Manufacturer Image Height 100px Info Display Manufacturer URL 1 Info Manufacturers Per Row 4 Info Display Empty Manufacturers 0 Info Display Manufacturer Image 1 InfoSo all options are still same for ZC 1.5 as you can see above. I just need 1 time fix to have modules on my website ZC 1.5. And SQL you sent me here on forum can also help others to solve similar problems.So, there is still the question of what specific entries did you have to manually delete to make this work? Can you compare the entries in the databases between the two versions? (Post the configuration and configuration_group table entries for this plugin?) I understand that there will be some things that are completely different, but looking to see what was wrong about the delete statements that didn't clear the settings expected.

mc12345678:

So, there is still the question of what specific entries did you have to manually delete to make this work? Can you compare the entries in the databases between the two versions? (Post the configuration and configuration_group table entries for this plugin?) I understand that there will be some things that are completely different, but looking to see what was wrong about the delete statements that didn't clear the settings expected.

See attached. The only difference I can see in sort order and ids I think. [Attachment no longer available]

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.

<?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);

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

jsarwar:

See attached. The only difference I can see in sort order and ids I think. [Attachment no longer available]

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

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

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.

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.

<?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); ```

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.

jsarwar:

Worked now.

Thank you so much.

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

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.

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?

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;

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

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.