Testimonial Manager Support Thread

guitarmong:

hi, i can't will my chinese code in the testimonials,, do u have any latest version to support UTF-8, i have code converter software but i dun know which files to effect this..

All of the information for Testimonial Manager is stored in the database table so there are no files to edit.

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

guitarmong:

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

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 ;

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?

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?

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

clydejones:

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 :smile: 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:

clydejones:

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

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.

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.

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>';

Many Thanks. Worked perfectly.

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.

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.

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.

clydejones:

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.

1. Ok, thanks for the clarification on the version.

2. Should I just delete that statement (line 59, for me) from the sql file?

autoace:

1. Ok, thanks for the clarification on the version.

2. Should I just delete that statement (line 59, for me) from the sql file?

You can delete it if you wish.

clydejones:

You can delete it if you wish.

Hi Clyde,

This is really just for anyone else who might be having the same issue I did (errors when running the sql patch for new installs.)

Just an FYI, I had to comment out lines 56-59 in the sql file for new installs. I had to go one by one until I finally got a success message from phpmyadmin. I'm assuming its because I do have a number of addons installed on my site.

Hope that helps someone else save some time.

ok i just installed this and where on the stylesheet do I place :

.testimonial {
color: #000;
padding: 0 5px 5px 5px;
text-align:left;
}
.testimonial p {
margin: 0; padding: 5px 0;
}
.testimonial span {
float:right;
}
.testimonialImage {
margin: 0;
padding: 0;
text-align: center;
}

metatags

//TESTIMONIALS:
case 'testimonials_manager_all_testimonials':

$sql = "select * from " . TABLE_TESTIMONIALS_MANAGER . " where status = 1 and language_id = '" . (int)$_SESSION['languages_id'] . "' order by date_added DESC, testimonials_title";
$testimonials = $db->Execute($sql);
while (!$testimonials->EOF) {
$testimonial_string_metatags .= zen_clean_html($testimonials->fields['testimonials_title']) . METATAGS_DIVIDER;

$testimonials->MoveNext();

} //EOF
define('META_TAG_TITLE', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
define('META_TAG_DESCRIPTION', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
define('META_TAG_KEYWORDS', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
break;

case 'testimonials_manager':
define('META_TAG_TITLE', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);
define('META_TAG_DESCRIPTION', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
define('META_TAG_KEYWORDS', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);
break;

open includes/templates/YOUR_TEMPLATE/css/stylesheet.css

scroll to the bottom of the page and add the following
.testimonial {
color: #000;
padding: 0 5px 5px 5px;
text-align:left;
}
.testimonial p {
margin: 0; padding: 5px 0;
}
.testimonial span {
float:right;
}
.testimonialImage {
margin: 0;
padding: 0;
text-align: center;
}

the other section is used to add meta tags when vewing your testimonial pages and is not included in the stylesheet.

There are instruction earlier in this support thread on add the meta tag section (I just don't remember where exactly)

I downloaded this mod from the free software section and installed it. I added the below code to /includes/modules/mytemplatename/meta_tags.php

//TESTIMONIALS:
case 'testimonials_manager_all_testimonials':

$sql = "select * from " . TABLE_TESTIMONIALS_MANAGER . " where status = 1 and language_id = '" . (int)$_SESSION['languages_id'] . "' order by date_added DESC, testimonials_title";
$testimonials = $db->Execute($sql);
while (!$testimonials->EOF) {
$testimonial_string_metatags .= zen_clean_html($testimonials->fields['testimonials_title']) . METATAGS_DIVIDER;

$testimonials->MoveNext();

} //EOF
define('META_TAG_TITLE', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
define('META_TAG_DESCRIPTION', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
define('META_TAG_KEYWORDS', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
break;

case 'testimonials_manager':
define('META_TAG_TITLE', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);
define('META_TAG_DESCRIPTION', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
define('META_TAG_KEYWORDS', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);
break;

Did this code need to be added to the meta_tags.php file or was that supplied for upgrades?

After adding it to the file, this string is showing up in the top/title of the browser window bar along with the title of the comment.

META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER

MyDigitalFixation:

I downloaded this mod from the free software section and installed it. I added the below code to /includes/modules/mytemplatename/meta_tags.php

Did this code need to be added to the meta_tags.php file or was that supplied for upgrades?

After adding it to the file, this string is showing up in the top/title of the browser window bar along with the title of the comment.

META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER

Adding this code is entirely optional

There is a post located in this thread on how to implement the code (I just don't remember where)

clydejones:

Adding this code is entirely optional
There is a post located in this thread on how to implement the code (I just don't remember where)

Oh, ok. I removed it for now. I'll get back to it when I have some more time to go through the threads again. Thank you and thanks for the mod too. I really like this one.

Clyde, first of all, thanks for all your contributions. I wanted to verify whether this was the proper way to add the code to the metatags.php.

When adding:

    define('META_TAG_TITLE', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);
    define('META_TAG_DESCRIPTION', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
    define('META_TAG_KEYWORDS', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);

I get the following on my metatags:

<title>META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGERGreat</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="keywords" content="META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGERGreat" />
<meta name="description" content="META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGERThis is just a test submission to show you how it looks, great, eh?" />

When deleting "META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER"

as in ```php
define('META_TAG_TITLE', $page_check->fields['testimonials_title']);
define('META_TAG_DESCRIPTION', zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
define('META_TAG_KEYWORDS', $page_check->fields['testimonials_title']);

my meta tags show as they should...
```html
<title>Great</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="keywords" content="Great" />
<meta name="description" content="This is just a test submission to show you how it looks, great, eh?" />

Will doing so will create any problems with other pages? I ask because I assume the original code worked for you and you added it for a reason...

Thanks