Testimonial Manager Support Thread

[clydejones]

Is version 1.4.3 stable now?

I just (not more than 5 minutes ago) uploaded a minor bug fix to the download section. Once that is approved everything should be fine.

[motti]

[FONT=Times New Roman]Hi Lextechs[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]From my end it is all perfect, Thanks to Clyde personal help.[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Clyde is that bug fix on my version?[/FONT]

[clydejones]

[FONT=Times New Roman]Hi Lextechs[/FONT]

[FONT=Times New Roman]From my end it is all perfect, Thanks to Clyde personal help.[/FONT]

[FONT=Times New Roman]Clyde is that bug fix on my version?[/FONT]

Yes it is!!

[yellow1912]

I have a stupid question. Doesn't ZC have the ability for users/customers to leave reviews as is? So does this module just move those reviews into a sidebox, or are the testimonials new and seperate from the existing review system?

This is testimonial/feedback about the site, not a specific product.

[AlexT]

Hi Clyde,

I am trying to install the Testimonials Manager 1.4.3. When I run install_testimonials_manager.sql, the following error is produced:

1060 Duplicate column name 'testimonials_mail'
in:
[CREATE TABLE zen_testimonials_manager ( testimonials_id int(11) NOT NULL auto_increment,
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_mail VARCHAR( 255 )
NULL DEFAULT NULL, testimonials_mail VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_mail VARCHAR(
255 ) NULL DEFAULT NULL, testimonials_show_email char(1) default '0', status int(1) NOT NULL
default '1', date_added datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY
(testimonials_id) ) TYPE=MyISAM AUTO_INCREMENT=2 ;]
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.

Is there any fix for this? The Zencart version is 1.3.7.

Many thanks,
Alex

[clydejones]

Hi Clyde,

I am trying to install the Testimonials Manager 1.4.3. When I run install_testimonials_manager.sql, the following error is produced:

1060 Duplicate column name 'testimonials_mail'
in:
[CREATE TABLE zen_testimonials_manager ( testimonials_id int(11) NOT NULL auto_increment,
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_mail VARCHAR( 255 )
NULL DEFAULT NULL, testimonials_mail VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_mail VARCHAR(
255 ) NULL DEFAULT NULL, testimonials_show_email char(1) default '0', status int(1) NOT NULL
default '1', date_added datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY
(testimonials_id) ) TYPE=MyISAM AUTO_INCREMENT=2 ;]
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.

Is there any fix for this? The Zencart version is 1.3.7.

Many thanks,
Alex

Alex,

Run this:

Copy and paste into your ZC admin -> tools -> install sql patches

#Testimonials Manager v1.4.3 upgrade SQL
# For Zen-Cart 1.3.7
# Last Updated: 7/25/2007

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager'
LIMIT 1;

DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

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


INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display in Latest Testimonials box', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', @configuration_group_id, 1, 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', @configuration_group_id, 2, 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.', @configuration_group_id, 3, 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.', @configuration_group_id, 4, 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', @configuration_group_id, 5, 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', @configuration_group_id, 6, 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', @configuration_group_id, 7, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Display Company Name field', 'TESTIMONIALS_COMPANY', 'true', 'Display Company Name field', @configuration_group_id, 8, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Display City field', 'TESTIMONIALS_CITY', 'true', 'Display City field', @configuration_group_id, 9, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (NULL, 'Display Country field', 'TESTIMONIALS_COUNTRY', 'true', 'Display Country field', @configuration_group_id, 10, 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', @configuration_group_id, 11, 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', 25, 999, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');


DROP TABLE IF EXISTS testimonials_manager;
CREATE TABLE testimonials_manager (
  `testimonials_id` int(11) NOT NULL auto_increment,
  `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 '1',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`testimonials_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `testimonials_manager` VALUES (1, 'Great', '', 'Perfect Designing', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', 1, 1, now());

[AlexT]

Alex,

Run this:

Copy and paste into your ZC admin -> tools -> install sql patches

#Testimonials Manager v1.4.3 upgrade SQL
# For Zen-Cart 1.3.7
# Last Updated: 7/25/2007
 
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager'
LIMIT 1;
 
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
 
INSERT INTO configuration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
 
 
INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display in Latest Testimonials box', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', @configuration_group_id, 1, 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', @configuration_group_id, 2, 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.', @configuration_group_id, 3, 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.', @configuration_group_id, 4, 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', @configuration_group_id, 5, 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', @configuration_group_id, 6, 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', @configuration_group_id, 7, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
 
INSERT INTO `configuration` VALUES (NULL, 'Display Company Name field', 'TESTIMONIALS_COMPANY', 'true', 'Display Company Name field', @configuration_group_id, 8, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
 
INSERT INTO `configuration` VALUES (NULL, 'Display City field', 'TESTIMONIALS_CITY', 'true', 'Display City field', @configuration_group_id, 9, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
 
INSERT INTO `configuration` VALUES (NULL, 'Display Country field', 'TESTIMONIALS_COUNTRY', 'true', 'Display Country field', @configuration_group_id, 10, 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', @configuration_group_id, 11, 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', 25, 999, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');
 
 
DROP TABLE IF EXISTS testimonials_manager;
CREATE TABLE testimonials_manager (
  `testimonials_id` int(11) NOT NULL auto_increment,
  `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 '1',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`testimonials_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
 
INSERT INTO `testimonials_manager` VALUES (1, 'Great', '', 'Perfect Designing', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', 1, 1, now());

Hi Clyde,

Done. The error message is now:

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_testimonials_manager VALUES (1, 'Great', '', 'Perfect Designing', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', 1, 1, now());]
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.


Is it something important or I should ignore it?

Thank you,
Alex

[maza]

Hello Clyde,

Another guy having problem installing your TM.

I downloaded the latest TM as of today, and I did the new installation procedures. I think I have done all in the install.txt file. CSS, SQL, renaming template, enabling inside Admin panel and what not.

I have not seen any new box appear in my site.

BTW, I have deleted that test testimonial lines inside the SQL patch because it returned some error when trying to patch it into ZC.

My site is : www.radiomeal.com

Hope you could help, thanks.

[Phil020782]

I have just installed testimonial manager for the first time (from downloads section), all seems to be working fine until it comes to review and update testimonials. When no country is added it is automatically filled with the customers email address, which is not a problem it can be deleted when updating.

But when i press update i get the following error:

1054 Unknown column 'last_update' in 'field list'
in:
[update testimonials_manager set testimonials_title = 'test4', testimonials_url = 'http://', testimonials_name = 'test test', testimonials_mail = 'phil_king2##########################', testimonials_company = '', testimonials_city = '', testimonials_country = '', testimonials_html_text = 'test4', status = '1', last_update = now() where testimonials_id = '5']

From a previous post i think i can fix this by adding a last_update field to my database table. Before i try it can someone tell me if the following code is correct:

ALTER TABLE `testimonials_manager` ADD `last_update` datetime NOT NULL default '0000-00-00 00:00:00 AFTER `testimonials_html_text ` ;

i don't know SQL at all really. I would be very grateful for any help anyone could offer me with this.

Thanks

[clydejones]

Hi Clyde,

Done. The error message is now:

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_testimonials_manager VALUES (1, 'Great', '', 'Perfect Designing', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', 1, 1, now());]
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.


Is it something important or I should ignore it?

Thank you,
Alex

Try running just this line:

INSERT INTO `testimonials_manager` VALUES (1, 'Great', '', 'Perfect Designing', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 1, 1, now());

Hello Clyde,

Another guy having problem installing your TM.

I downloaded the latest TM as of today, and I did the new installation procedures. I think I have done all in the install.txt file. CSS, SQL, renaming template, enabling inside Admin panel and what not.

I have not seen any new box appear in my site.

BTW, I have deleted that test testimonial lines inside the SQL patch because it returned some error when trying to patch it into ZC.

My site is : www.radiomeal.com

Hope you could help, thanks.

The side box won't show because there is/are no testimonials to display in the sidebox.

run this sql statement:

INSERT INTO `testimonials_manager` VALUES (1, 'Great', '', 'Perfect Designing', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 1, 1, now());