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.Quote:
Originally Posted by lextechs
Printable View
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.Quote:
Originally Posted by lextechs
[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]
Yes it is!!Quote:
Originally Posted by motti
This is testimonial/feedback about the site, not a specific product.Quote:
Originally Posted by enderandrew
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,Quote:
Originally Posted by AlexT
Run this:
Copy and paste into your ZC admin -> tools -> install sql patches
Code:#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,Quote:
Originally Posted by clydejones
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 : 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:
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:Quote:
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']
i don't know SQL at all really. I would be very grateful for any help anyone could offer me with this.Quote:
ALTER TABLE `testimonials_manager` ADD `last_update` datetime NOT NULL default '0000-00-00 00:00:00 AFTER `testimonials_html_text ` ;
Thanks
Try running just this line:Quote:
Originally Posted by AlexT
Code: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());
The side box won't show because there is/are no testimonials to display in the sidebox.Quote:
Originally Posted by maza
run this sql statement:
Code: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());