Testimonial Manager Support Thread

[gaffettape]

Hi Clyde,

I have a problem: When in Admin>Tools>Testimonials Manager their are all the testimonials listed 10 per page. I have 30 testimonials: ie 3 pages of 10 testimonials listed. When on page 1 of the testimonials I have a sidebox on the right which contains



Edit Button / Delete Button

Status: Approved

IMAGE DOES NOT EXIST

Contact Name: #####

Contact Email: #####

Testimonial:
####

Testimonial Submitted: ####
Last Modified: ####



This box is very handy as it shows a breakdown of details for each testimonial. HOWEVER this sidebox only appears on page 1 of 3. On page 2 and so on this box disappears?? Leaving me unable to edit any testimonial not listed on page 1. Is this deliberate or have I installed something wrong?

Thanks.

[clydejones]

Hi Clyde,

I have a problem: When in Admin>Tools>Testimonials Manager their are all the testimonials listed 10 per page. I have 30 testimonials: ie 3 pages of 10 testimonials listed. When on page 1 of the testimonials I have a sidebox on the right which contains



Edit Button / Delete Button

Status: Approved

IMAGE DOES NOT EXIST

Contact Name: #####

Contact Email: #####

Testimonial:
####

Testimonial Submitted: ####
Last Modified: ####



This box is very handy as it shows a breakdown of details for each testimonial. HOWEVER this sidebox only appears on page 1 of 3. On page 2 and so on this box disappears?? Leaving me unable to edit any testimonial not listed on page 1. Is this deliberate or have I installed something wrong?

Thanks.

It should be displayed on each page.

But without actually seeing the problem "live" I can't offer a viable solution.

You could try uploading a clean copy of:

admin/testimonials_manager.php

from the the mod zip package.

[annav]

Hi, I couldn't find an answer to this. I have two testimonials and both show on the home page testimonials side box. I only want one to show one on the home page only but can't find where to change this setting. Thanks.

[clydejones]

Hi, I couldn't find an answer to this. I have two testimonials and both show on the home page testimonials side box. I only want one to show one on the home page only but can't find where to change this setting. Thanks.

admin -> configuration -> testimonial manager ->
Number Of Testimonials to display in Testimonials Sidebox

[annav]

admin -> configuration -> testimonial manager ->
Number Of Testimonials to display in Testimonials Sidebox

Thanks, I had looked there previously but I don't actually have that option for some reason. The only options I have are:

Define Testimonial, which give the following options:

Enable the Defined Testimonial Link/Text?
0= Link ON, Define Text OFF
1= Link ON, Define Text ON
2= Link OFF, Define Text ON
3= Link OFF, Define Text OFF

0
1
2
3

(set on 1)

and

Testimonial Manager Version 1.5.1

Anna

[clydejones]

Thanks, I had looked there previously but I don't actually have that option for some reason. The only options I have are:

Define Testimonial, which give the following options:

Enable the Defined Testimonial Link/Text?
0= Link ON, Define Text OFF
1= Link ON, Define Text ON
2= Link OFF, Define Text ON
3= Link OFF, Define Text OFF

0
1
2
3

(set on 1)

and

Testimonial Manager Version 1.5.1

Anna

Then it sounds like you need to run the following sql statement:
(admin -> tools -> install sql patches)
For best results, copy-and-paste the code into the query field and press 'Send'.


#Testimonials Manager upgrade SQL
# For Zen-Cart 1.3.8
# Version: 1.5.1
# Updated: 1/29/2010
# For best results, run this sql patch using the Zen-Cart Sql Patches tool
# (admin -> tools -> install sql patches)
# Cut-and-paste the code into the query field and press 'Send.
# New configuration options are added to the zen_configuration table.

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';

INSERT INTO configuration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager';

INSERT INTO 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.', @t4, 1, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Testimonial Title Minimum Length', 'ENTRY_TESTIMONIALS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @t4, 2, NULL, now(), NULL, NULL), (NULL, 'Testimonial Text Minimum Length', 'ENTRY_TESTIMONIALS_TEXT_MIN_LENGTH', '10', 'Minimum length of Testimonial description.', @t4, 3, NULL, now(), NULL, NULL), (NULL, 'Testimonial Text Maximum Length', 'ENTRY_TESTIMONIALS_TEXT_MAX_LENGTH', '1000', 'Maximum length of Testimonial description.', @t4, 3, NULL, now(), NULL, NULL), (NULL, 'Testimonial Contact Name Minimum Length', 'ENTRY_TESTIMONIALS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', @t4, 4, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Display Truncated Testimonials in Sidebox', 'DISPLAY_TESTIMONIALS_MANAGER_TRUNCATED_TEXT', 'true', 'Display truncated text in sidebox', @t4, 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, '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.', @t4, 6, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, '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.', @t4, 7, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Display Date Published on Testimonials page', 'DISPLAY_TESTIMONIALS_DATE_PUBLISHED', 'true', 'Display date published on testimonials page', @t4, 8, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display View All Testimonials Link In Sidebox', 'DISPLAY_ALL_TESTIMONIALS_TESTIMONIALS_MANAGER_LINK', 'true', 'Display View All Testimonials Link In Sidebox', @t4, 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Display Add New Testimonial Link In Sidebox', 'DISPLAY_ADD_TESTIMONIAL_LINK', 'true', 'Display Add New Testimonial Link In Sidebox', @t4, 10, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Testimonial Image Width', 'TESTIMONIAL_IMAGE_WIDTH', '80', 'Set the Width of the Testimonial Image', @t4, 11, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Testimonial Image Height', 'TESTIMONIAL_IMAGE_HEIGHT', '80', 'Set the Height of the Testimonial Image', @t4, 12, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Testimonial Image Directory', 'TESTIMONIAL_IMAGE_DIRECTORY', 'testimonials/', 'Set the Directory for the Testimonial Image', @t4, 13, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Display Company Name field', 'TESTIMONIALS_COMPANY', 'true', 'Display Company Name field', @t4, 14, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Display City field', 'TESTIMONIALS_CITY', 'true', 'Display City field', @t4, 15, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Display Country field', 'TESTIMONIALS_COUNTRY', 'true', 'Display Country field', @t4, 16, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Only registered customers may submit a testimonial', 'REGISTERED_TESTIMONIAL', 'true', 'Only registered customers may submit a testimonial', @t4, 17, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Display All Languages', 'TESTIMONIALS_DISPLAY_ALL_LANGUAGES', 'true', 'Display All Languages', @t4, 18, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Testimonial - Show Store Name and Address', 'TESTIMONIAL_STORE_NAME_ADDRESS', 'true', 'Include Store Name and Address', @t4, 19, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Define Testimonial', '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', @t4, 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');
INSERT INTO `configuration` VALUES (NULL, 'Testimonial Manager Version', 'TM_VERSION', '1.5.1', 'Testimonial Manager version', @t4, 21, NULL, now(), NULL, NULL);

[annav]

Thanks for that.

Cut and paste ..... sounds easy enough!

Anna

www.toycrazy.com.au

[Twaddle]

admin -> configuration -> testimonial manager ->
Number Of Testimonials to display in Testimonials Sidebox

I don't have that option either, and I've installed all the SQL patches

[clydejones]

I don't have that option either, and I've installed all the SQL patches

There are only 3 sql statements included with this MOD

In the package upgrade folder you'll find this one

upgrade_testimonial_manager.sql

in the package new_installation folder you'll find this one

install_testimonials_manager.sql

and you'll also find this one

uninstall_testimonials_manager.sql

[Twaddle]

Hmmm, just uninstalled it and reinstalled it to the letter, and still the same.

No worries, it does what we need it to do out of the tin and don't need any options