lextechs:

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.

Hi Lextechs

From my end it is all perfect, Thanks to Clyde personal help.

Clyde is that bug fix on my version?

motti:

Hi Lextechs

From my end it is all perfect, Thanks to Clyde personal help.

Clyde is that bug fix on my version?

Yes it is!!

enderandrew:

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.

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

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

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

clydejones:

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

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 : https://www.radiomeal.com

Hope you could help, thanks.

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 = '[email protected]', 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

AlexT:

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

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 : https://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());

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:

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:

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

Thanks
Yes, Run that statement from your admin -> tools -> install sql patches

Thanks clyde that worked perfectly, fantastic contrib btw.

clydejones:

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

 
 
Clyde, 
 
Thanks for your help.
 
I ran this line and everyting seemed fine: I could add testimonials from both the webside and from Admin and they showed correctly. But, when I tried to edit a testimonial (I used your example and added city Perth), the following error message appeared:
 
1054 Unknown column 'last_update' in 'field list'
in:
[update zen_testimonials_manager set testimonials_title = 'Great', testimonials_url = 'http://', testimonials_name = 'Perfect Designing', testimonials_mail = '[email protected]', testimonials_company = '', testimonials_city = 'Perth', testimonials_country = '', testimonials_html_text = 'This is just a test submission to show you how it looks, great, eh?', status = '1', last_update = now() where testimonials_id = '1']
 
Am I supposed to be able to edit them?
 
Thanks, 
Alex

AlexT:

Clyde,

Thanks for your help.

I ran this line and everyting seemed fine: I could add testimonials from both the webside and from Admin and they showed correctly. But, when I tried to edit a testimonial (I used your example and added city Perth), the following error message appeared:

1054 Unknown column 'last_update' in 'field list'
in:
[update zen_testimonials_manager set testimonials_title = 'Great', testimonials_url = 'http://', testimonials_name = 'Perfect Designing', testimonials_mail = '[email protected]', testimonials_company = '', testimonials_city = 'Perth', testimonials_country = '', testimonials_html_text = 'This is just a test submission to show you how it looks, great, eh?', status = '1', last_update = now() where testimonials_id = '1']

Am I supposed to be able to edit them?

Thanks,
Alex

Run this from admin -> tools -> insert sql patches

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

I've fixed this in the download and will upload it ASAP

clydejones:

Run this from admin -> tools -> insert sql patches

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

>  
> I've fixed this in the download and will upload it ASAP
 
Something is not quite right again, I've ran the line, the following message has appeared:
 
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 ''0000-00-00 00:00:00 AFTER testimonials_html_text' at line 1
in:
[ALTER TABLE zen_testimonials_manager ADD last_update datetime NOT NULL default '0000-00-00 00:00:00 AFTER testimonials_html_text ;]
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.
 
The versions are:
**PHP Version: **5.2.1 (Zend: 2.2.0)
**Database: **MySQL 5.0.27-standard 
 
Thank you, 
Alex

AlexT:

Something is not quite right again, I've ran the line, the following message has appeared:

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 ''0000-00-00 00:00:00 AFTER testimonials_html_text' at line 1
in:
[ALTER TABLE zen_testimonials_manager ADD last_update datetime NOT NULL default '0000-00-00 00:00:00 AFTER testimonials_html_text ;]
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.

The versions are:
**PHP Version: **5.2.1 (Zend: 2.2.0)
**Database: **MySQL 5.0.27-standard

Thank you,
Alex

Try this one:

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

clydejones:

Try this one:

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

 
 
Everything works fine now, thank you very much for your help!
 
Alex

Thanks Clyde, I got it worked now.

Hey Clyde, I have noticed new issue now.

I got a TEXT_FIELD_OPTIONAL appeared besides my 'fill in the blanks' form inside ZC admin.

Is TM giving this problem? Do you have any idea how to fix it?

maza:

Hey Clyde, I have noticed new issue now.

I got a TEXT_FIELD_OPTIONAL appeared besides my 'fill in the blanks' form inside ZC admin.

Is TM giving this problem? Do you have any idea how to fix it?

Not sure it it is TM.

open admin/includes/functions/html_output.php

at around line 235 you should see:

if ($required == false) $field .= TEXT_FIELD_OPTIONAL;

Just delete this line and see if that clears that text string.