Testimonial Manager Support Thread

[clydejones]

OK got the SQL reinstalled and plan to leave it now overnite (I'm in Spain so it's overnight for me) and will check this thread in the morning, hope we can figure this out because I REALLY want to use this mod.

Check your PM

[clydejones]

OK got the SQL reinstalled and plan to leave it now overnite (I'm in Spain so it's overnight for me) and will check this thread in the morning, hope we can figure this out because I REALLY want to use this mod.

When you say SQL installed I'm not sure what you mean.

All you need to do is copy the entire sql file and then
paste it into:

admin -> tools -> install sql patches and then click the send button.

That sql statement adds some admin options in the Zen Cart configuration table for Testimonial Manager and adds the testimonial manager admin interface in the tools menu and finally it creates the testimonials table in the database.

The sql statement does not run from the front end (shop) of your installation and is only a one time run from the ZC admin panel as indicated above.

So where are you "installing" the sql?

[KarmaCharms]

Exactly as the instructions said. Pasted the contents of the install sql file and hit send, then the problems start. If I then copy and paste the uninstall sql file and hit send, problems gone.

[clydejones]

For anyone else having this problem:

Warning: Variable passed to each() is not an array or object in /path/to/your catalog files/includes/classes/db/mysql/query_factory.php on line 114

The solution can be found here

Note: this error has nothing to do with the testimonial manager mod but rather with the db_cache table in the database.

[KarmaCharms]

I was totally clueless but you figured it out and fixed it. THANK YOU for taking the time to help a newbie, one day I hope to be able to pay it forward!

[Butterfliege]

I have got problems to install this module. When I cut and paste the code of install_testimonials_manager.sql and press 'send', I always get this error:

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_configuration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');]
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.

Can you help me? What did I wrong?

[clydejones]

I have got problems to install this module. When I cut and paste the code of install_testimonials_manager.sql and press 'send', I always get this error:



Can you help me? What did I wrong?

Try running this: just copy the code and paste it into admin -> tools -> install sql patches and press the send button.

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, 'Testimonial Title Minimum Length', 'ENTRY_TESTIMONIALS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @configuration_group_id, 2, NULL, now(), NULL, NULL), (NULL, 'Testimonial Text Minimum Length', 'ENTRY_TESTIMONIALS_TEXT_MIN_LENGTH', '10', 'Minimum length of link description.', @configuration_group_id, 3, NULL, now(), NULL, NULL), (NULL, 'Testimonial Contact Name Minimum Length', 'ENTRY_TESTIMONIALS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', @configuration_group_id, 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', @configuration_group_id, 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.', @configuration_group_id, 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.', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 17, 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 '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 AUTO_INCREMENT=2 ;

INSERT INTO `testimonials_manager` VALUES (1, 'Great', '', 'Clyde\'s Test Site', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 0, 1, now(), '0000-00-00 00:00:00');

[Butterfliege]

I have done it, and now I get tihs 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 'p_id=0' at line 1
in:
[p_id=0;]
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.

[clydejones]

I have done it, and now I get tihs 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 'p_id=0' at line 1
in:
[p_id=0;]
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.

p_id=0 does NOT exist in the SQL statement provided for Testimonials Manager.

URL to your site please

[Butterfliege]

Sorry, the site is on my local system, so I can't give you a url.
Do you have any ideas?