Perfect, thanks for your help Clyde :smile:
Printable View
Hello,
I have tried to install this module on my test offline site which is running Zen v1.3.9h, php version 5.3.5, database MySQL 5.5.8 and I am getting the following error in Zen when I run the install sql for the testimonial addon, can you please advise what issue is and let me know if you need any additional information. (I have changed YOUR_TEMPLATE folders to match mine which is CUSTOM.
:dontgetit
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
in:
[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 ;]
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.
Look forward to receiving assistance as this sound like a good addition to Zen.
Regards Cheryl.
Ok silly me didn't upload files. I have added install part to my style sheet and uploaded files, activated sidebox and am now getting below error on site where sideboxes should appear.
1146 Table 'aescrapb.testimonials_manager' doesn't exist
in:
[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from testimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit 5].
Any suggestions?
Regards Cheryl.
Sorry, me again :smile: This now goes back to original problem I think. I ran the install sql in my phpMyAdmin on my data base and got the same error as before; #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 18
As I don't know to much about syntax I cannot workout what is not right in sql. The end of the install script has the following;
... `last_update` datetime NULL default NULL,
PRIMARY KEY (`testimonials_id`)
) TYPE=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);
Can you please advise what issue is with syntax in install script, thanks.
Cheryl.
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);
Hi there.
Installed Testemonials manager but for some reason it does't display images neither links to the sites.
When I tray to upload image it always says Image Doesn't Exist.
Please help.
www.auction-bay.com (site in russian language)
Hi. Thank you for replay.
That's exactly what I do but the image and the link does not show up. I trayed to upload an image and it's only says Image doesn't exist.
Thank you.