Testimonial Manager Support Thread

[guitarmong]

oh my god,, so will u issue a latest version to support UTF-8? i looking forward on this,, thanks!

[clydejones]

oh my god,, so will u issue a latest version to support UTF-8? i looking forward on this,, thanks!

run this sql patch using the Zen-Cart Sql Patches tool (admin -> tools -> install sql patches)

copy and past this code into the text area and click the send button.

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 '0',
  `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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

[largomike1]

Hi there again,

I was working on the site locally on my Windows PC (WAMP), when you asked for the URL, so I decided to upload what I had done at this point. What's interesting is that everything works correctly after I uploaded the whole site. The url to the correctly working, copied site is: http://pursebling.com. If you look at the bottom left sidebox, you will see that the testimonial box is displaying correctly. However, on my local machine it looks like this:


So to recap:
It's working in the following conditions:
- Locally for my memoriesinchocolate.com site.
- Production server for memoriesinchocolate.com
- Production server for pursebling.com

It's not working for my local version of pursebling.com (which I copied the entire site up to the production server a few minutes ago).

Any ideas?

[clydejones]

Hi there again,

I was working on the site locally on my Windows PC (WAMP), when you asked for the URL, so I decided to upload what I had done at this point. What's interesting is that everything works correctly after I uploaded the whole site. The url to the correctly working, copied site is: http://pursebling.com. If you look at the bottom left sidebox, you will see that the testimonial box is displaying correctly. However, on my local machine it looks like this:


So to recap:
It's working in the following conditions:
- Locally for my memoriesinchocolate.com site.
- Production server for memoriesinchocolate.com
- Production server for pursebling.com

It's not working for my local version of pursebling.com (which I copied the entire site up to the production server a few minutes ago).

Any ideas?

Generally, it means that a language file is missing or was corrupted during the transfer/upload

You should check includes/languages/english/extra_definitions/YOUR_TEMPLATE/testimonials_manager_defines.php

[hedron]

look in includes/modules/pages/product_reviews_write/header_php.php

You'll find the following constant
SEND_EXTRA_REVIEW_NOTIFICATION_EMAILS_TO

It works! Thank you I wish I had some of your php genius.



In brief, here is the How To:

If you need Testimonial Manager to send Testimonial Submission updates to the same email address used to alert the store admin about Review submissions, follow these instructions:

Modify the section that sends the admin e-mail in
includes/modules/pages/testimonials_add/header_php.php

look for the following section: lines 119 - 121)

////SEND ADMIN EMAIL

zen_mail($name, STORE_OWNER_EMAIL_ADDRESS, EMAIL_OWNER_SUBJECT, EMAIL_OWNER_TEXT, STORE_NAME, EMAIL_FROM, $html_msg, 'testimonial_add');


You need to substitute STORE_OWNER_EMAIL_ADDRESS [...]

... with this code: SEND_EXTRA_REVIEW_NOTIFICATION_EMAILS_TO

[shaqadamus]

Hi Clyde,
How can I add a link "Testimonial" in Information Sidebox which will point to all testimonial page.
I do not want to display in seperate side box.
Thanks in advance.

[clydejones]

Hi Clyde,
How can I add a link "Testimonial" in Information Sidebox which will point to all testimonial page.
I do not want to display in seperate side box.
Thanks in advance.

open includes/modules/sideboxes/YOUR_TEMPLATE/informtion.php

add the following where you want the link to appear.

    $information[] = '<a href="' . zen_href_link(FILENAME_TESTIMONIALS_MANAGER_ALL) . '">' . TESTIMONIALS_MANAGER_DISPLAY_ALL_TESTIMONIALS . '</a>';

[shaqadamus]

Many Thanks. Worked perfectly.

[autoace]

2 questions:

1. In the downloads section it states the most current version is 1.5. However, in the readme file, the support link goes to the first post which states there is a v1.7 available - a little clarification please. Is 1.7 avail?

2. I received the following error for the sql patch:
Error

SQL query:

INSERT INTO `configuration`
VALUES (
NULL , 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL , now( ) , NULL , 'zen_cfg_textarea_small('
);

MySQL said: Documentation
#1062 - Duplicate entry 'IH_VERSION' for key 2

Any ideas on what to do, thanks.

[clydejones]

2 questions:

1. In the downloads section it states the most current version is 1.5. However, in the readme file, the support link goes to the first post which states there is a v1.7 available - a little clarification please. Is 1.7 avail?

2. I received the following error for the sql patch:
Error

SQL query:

INSERT INTO `configuration`
VALUES (
NULL , 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL , now( ) , NULL , 'zen_cfg_textarea_small('
);

MySQL said: Documentation
#1062 - Duplicate entry 'IH_VERSION' for key 2

Any ideas on what to do, thanks.

1 - I think it actually says that "Testimonial Manager 1.3.7 is available in the downloads section" (the current version is 1.5

2 - This can be safely ignored. It means that there is already an entry for that information in the data base and that particular statement will be ignored.