Printable View
Hi Wendy I have tested this module and have found not bugs what so ever. I just downloaded the copy I uploaded and tried the new_install.sql statement and it works without any problems. I don't know why you are getting the error. Look in your cache folder to see what myDEBUG is telling you.Quote:
Originally Posted by LadyArlette
Is there a way to not have testimonials show the person's last name? Just for privacy reasons I'd much rather have it show them as "John" or "John S." than "John Smith"... is this a hack I could do easily?
Yes there is a way. Login to your admin/tools/testimonials and click on the persons name and delete the last name and update.Quote:
Originally Posted by WebKat
Oh thanks, I guess that is one solution!
I should not write up a problem report at 2 in the morning and expect to get it right! :oops:
I have installed version 1.3.9h on my computer with the intent to make it match my online system. Then I will figure out how to bring the system to 1.5 on my computer before doing it online.
So - I was installing zen_1.3.9 (not 1.5 as I said incorrectly in my previous post) when I received the error message.
Uninstalling with the sql uninstall patch works perfectly with no errors.
I tried installing the sql patch from the earlier version v1.5.2 of testimonial manager, and received the same error message.
I (finally) have gotten testimonial manager to show up in the admin>tools>layout boxes controller section (a small victory) - but on my catalog where the testimonial box should be I receive the following message instead of the testimonials:
1146 Table 'pillaged_zen.pvtestimonials_manager' doesn't exist
in:
[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from PVtestimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit 5]
:dontgetit When I installed this mod in my original, live site, I had no trouble at all... I just don't get it!
Although I am grateful that if I have to have trouble, it is on my test site, not on the live site!
So which version of testimonial manager did you download first and install? If you you downloaded version v1.5.3 and installed the folder zen_1.5.0 there is a difference in that version and zen_1.3.9 version. You would have to uninstall it just like you installed it. After that install the v.1.3.9. I think you have files left over from v1.5.0 if that is the original version you first installed.Quote:
Originally Posted by LadyArlette
I'm having a similar problem installing the SQL for a brand-new use of Testimonial Manager 1.5.3a. I've got a fresh 1.5.0 install on my local machine (PHP 5.3.8, mySQL 5.5.16) and ran the new_install.sql (without the lead-in comments) in my admin. Here's what's in my debug log:
[15-Mar-2012 13:44:58] PHP Fatal error: 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 'TYPE=MyISAM' at line 1 :: 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) ) TYPE=MyISAM ; in C:\xampp\htdocs\v1.5.0\includes\classes\db\mysql\query_factory.php on line 101
Any ideas?
I haven't tried Testimonial Manager on anything higher than a PHP Version 5.2.17. I don't know if it will run on a PHP 5.3 mySQL or above. I have no way of checking this out yet but I think this is whats causing this error you two are getting.. I'll have to download xampp and see whats going on.Quote:
Originally Posted by lat9
FWIW, the problem has nothing to do with the PHP version. If I copy & paste the install_sql data directly into phpMyAdmin, I get the following message:
The problem is with the creation of the testimonials table ...Code:Error
SQL query:
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' )
) TYPE = MYISAM ;
MySQL said: Documentation
#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 ''testimonials_id' int(11) NOT NULL auto_increment,
'language_id' int(11) NOT N' at line 2
OK, I finally got it sorted out. I've attached my updated version (that worked for me on MySQL 5.5.16):
Essentially, it was (1) removing the quotes around the column names and (2) changing the TYPE= to ENGINE= on the table creation statement (TYPE= is deprecated).Code:#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);
/*
zencart 1.5 mods
*/
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('TestimonialsManager', 'BOX_TOOLS_TESTIMONIALS_MANAGER', 'FILENAME_TESTIMONIALS_MANAGER', '', 'tools', 'Y', 35);
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configTestimonialsManager','BOX_CONFIGURATION_TESTIMONIALS_MANAGER','FILENAME_CONFIGURATION',CONCAT('gID=',@t4), 'configuration', 'Y', @t4);