Testimonial Manager Support Thread

Thanks Country charm, Diva.
You guys rock!
Will try it now

Hi,
How do I know if the table is created ?
When I go to the layout box controller activate the new sidebox I get an error on the place where the side box should have appeared which says the table does not exist.

devyani:

Hi,
How do I know if the table is created ?
When I go to the layout box controller activate the new sidebox I get an error on the place where the side box should have appeared which says the table does not exist.

When you run the install script, you will get a success message.. if you did not then the module is not installed correctly..

You need to double check that you've installed this completely.. trying to figure out what's missing is difficult when it appears that the module has not been installed completely..

Thanks !
Loos great .
I don't know why it didn't get installed the first time..
I simply uninstalled and installed the SQL again. And its looking great

DivaVocals:

Did you verify that these files are in your admin folder?? Has your admin folder been renamed??

Apologies for putting such a old thread in the loop.
But I have exactly the same issue.
I am not seeing testimonial manager option under tools.
I read this thread and understood that admin folder has to be renamed. Which admin folder ? There is one under root; which i never renamed. Then there is another one under root that I have renamed.
Which admin folder are we talking about ?
Sorry if the question sounds naive or confusing... because that's what I have become now :)

devyani:

Apologies for putting such a old thread in the loop.
But I have exactly the same issue.
I am not seeing testimonial manager option under tools.
I read this thread and understood that admin folder has to be renamed. Which admin folder ? There is one under root; which i never renamed. Then there is another one under root that I have renamed.
Which admin folder are we talking about ?
Sorry if the question sounds naive or confusing... because that's what I have become now :)

There should be ONE and only one admin folder in your store, period. I suggest you backup then copy/merge all files from your admin folder into your renamedadmin folder.

installation instructions clearly say to re-named the admin folder in the fileset for this module. This should be done BEFORE uploading the files.. this is true for every module which includes admin or template override changes> devyani:

Apologies for putting such a old thread in the loop.
But I have exactly the same issue.
I am not seeing testimonial manager option under tools.
I read this thread and understood that admin folder has to be renamed. Which admin folder ? There is one under root; which i never renamed. Then there is another one under root that I have renamed.
Which admin folder are we talking about ?
Sorry if the question sounds naive or confusing... because that's what I have become now :)

DivaVocals:

installation instructions clearly say to re-named the admin folder in the fileset for this module. This should be done BEFORE uploading the files.. this is true for every module which includes admin or template override changes

Yes, thanks!
I had installed the referral module before this and that was the folder that I did not rename.
I am counting my good stars that nothing went wrong.
All good now.
Thanks Picandix, Thanks Diva !

picandnix:

There should be ONE and only one admin folder in your store, period. I suggest you backup then copy/merge all files from your admin folder into your renamedadmin folder.

Did this, and all's fine.
Thanks

Does anyone know if I can add an additional field to this without it feeding into the database but have it notated on the notification email?

clydejones:

Try this: run this sql patch using the Zen-Cart Sql Patches tool
(admin -> tools -> install sql patches) copy-and-paste the code into the query field and press 'Send' instead.

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 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', @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.2', 'Testimonial Manager version', @t4, 21, NULL, now(), NULL, NULL);

DROP TABLE IF EXISTS testimonials_manager;
CREATE TABLE testimonials_manager (
testimonials_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
testimonials_title varchar(64) NOT NULL default '',
testimonials_url VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_name text NOT NULL,
testimonials_image varchar(254) NOT NULL default '',
testimonials_html_text text,
testimonials_mail text NOT NULL,
testimonials_company VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_city VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_country VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_show_email char(1) default '0',
status int(1) NOT NULL default '0',
date_added datetime NOT NULL default '0000-00-00 00:00:00',
last_update datetime NULL default NULL,
PRIMARY KEY (testimonials_id)
) ENGINE=MyISAM;

INSERT INTO testimonials_manager VALUES (1, 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);

Awesome...that worked for me!!! Thanks. :)

amandavz:

Awesome...that worked for me!!! Thanks. :)

And so that it is clear for anyone else who is following this thread, the install script you ran is old incorrect and should not be run. The only install script you should be running is the one that comes with the current version of this module.

Hi Everyone...Any idea what file I would need to change to have the image show to the left and the test to the right? Also...is the text size controlled by the site css or the testimonials css files? I couldn't seem to find it anywhere.

Thanks...

For the text size, I think you can add or edit css of testimonial.css

What's the image that you want to show ?

For the text size, I think you can add or edit css of testimonial.css

What's the image that you want to show ?

You can add an image to the testimonials. Like I added a testimonial to my new site from a woman that wrote one on my old site and I wanted to add her site banner to it. I added the site banner but it sits on top of the text. I would like it to sit side by side so that if anyone ever writes a testimonial with their image, it will automatically line up correctly.

Thanks for the tip on the css.

I think I found a solution I am happy with. I centered everything and gave it all proper spacing and I think it will work. Thanks for your help!!! :)

I'm glad you found the solution but, care to share the exact details of what you did.. it will benefit others..> amandavz:

I think I found a solution I am happy with. I centered everything and gave it all proper spacing and I think it will work. Thanks for your help!!! :)

I added the following (in red) to both css files:

- display_all_testimonials.css -
#testimonialDefault h1{margin:0;padding:10px 0;font-size:1.5em;font-weight:700;}

blockquote {
margin:0 !important;
padding:0 !important;
border:0px solid ;
height:1%;
text-align: center;
font-size:12px;
font-weight:bold;
font-style: italic;
}

blockquote div {
padding:20px 50px;
height:1%;
}

.testimonialImage {
margin: 0;
padding: 0.8em;
text-align: center;
}

- testimonials_manager.css -
#testimonialDefault h1{margin:0;padding:10px 0;font-size:1.5em;font-weight:700;}

blockquote {
margin:0 !important;
padding:0 !important;
border:0px solid navy;
height:1%;
text-align: center;
font-size:12px;
font-weight:bold;
font-style: italic;
}

blockquote div {
padding:20px 50px;
height:1%;
}

.testimonialImage {
margin: 0;
padding: 0;
text-align: center;
}

Hope this helps someone!!! :)

Thanks for sharing!!!:D

amandavz:

I added the following (in red) to both css files:

- display_all_testimonials.css -
#testimonialDefault h1{margin:0;padding:10px 0;font-size:1.5em;font-weight:700;}

blockquote {
margin:0 !important;
padding:0 !important;
border:0px solid ;
height:1%;
text-align: center;
font-size:12px;
font-weight:bold;
font-style: italic;
}

blockquote div {
padding:20px 50px;
height:1%;
}

.testimonialImage {
margin: 0;
padding: 0.8em;
text-align: center;
}

- testimonials_manager.css -
#testimonialDefault h1{margin:0;padding:10px 0;font-size:1.5em;font-weight:700;}

blockquote {
margin:0 !important;
padding:0 !important;
border:0px solid navy;
height:1%;
text-align: center;
font-size:12px;
font-weight:bold;
font-style: italic;
}

blockquote div {
padding:20px 50px;
height:1%;
}

.testimonialImage {
margin: 0;
padding: 0;
text-align: center;
}

Hope this helps someone!!! :)