Testimonial Manager Support Thread

skunkworx:

love your work clyde.

i wonder if you can help me please?

our site is at www.totalerc.com

I notice you had a slideshow sidebox...looks good...where did you get it?

Clyde,

I'm having a small issue when you view the testimonials page it has "HEADING_TITLE
TEXT_DISPLAY_NUMBER_OF_TESTIMONIALS_MANAGER_ITEMS"

At the top and bottom of the page. I searched the forum and didn't see an answer for this. Any ideas ?

Thanks

wccomp:

Clyde,

I'm having a small issue when you view the testimonials page it has "HEADING_TITLE
TEXT_DISPLAY_NUMBER_OF_TESTIMONIALS_MANAGER_ITEMS"

At the top and bottom of the page. I searched the forum and didn't see an answer for this. Any ideas ?

Thanks

Sounds like you forgot to upload one or more of the files in

in languages/english/YOUR_TEMPLATE

Clyde,

Thanks that was it. I thought I had double checked all that but every now and then you just miss something.

Thanks

wccomp:

Clyde,

Thanks that was it. I thought I had double checked all that but every now and then you just miss something.

Thanks

glad to help

Hi Clyde,

Just downloaded the latest version of this contribution. I was upgrading from 3.0.2.

Anyway... after installing, when trying to access the links.php page from the admin I received the following error.

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\server\xampp\htdocs\zencart\admin\links.php on line 164

I had a quick look at the code and believe that line 161 of links.php should be changed to the following.

zen_mail($links_contact_name, $links_contact_email, EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

This error (the ' character) only appears in the upgrade links.php file and not the new installation one.

I hope this helps someone else! :)

Great work with this contribution.

Alex Clarke:

Hi Clyde,

Just downloaded the latest version of this contribution. I was upgrading from 3.0.2.

Anyway... after installing, when trying to access the links.php page from the admin I received the following error.

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\server\xampp\htdocs\zencart\admin\links.php on line 164

I had a quick look at the code and believe that line 161 of links.php should be changed to the following.

zen_mail($links_contact_name, $links_contact_email, EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

> 
> This error (the ' character) only appears in the upgrade links.php file and not the new installation one.
> 
> I hope this helps someone else! :)
> 
> Great work with this contribution.

Alex,

Are you talking about **Testimonial Manager** or **Links Manager**

I'm talking about Links Manager and now realise that I've posted in the wrong thread. Silly me. I better get some sleep now.

Sorry about that!

sal4888:

I notice you had a slideshow sidebox...looks good...where did you get it?

I keep pimping it out, but there is a brilliant rewrite of Lightbox 2 that includes native slide-show functionality, and it wouldn't require a seperate sidebox. I'm hoping that it can be dropped into the Lightbox module without too much fuss. The Lightbox 2 site says that Lightbox 2 is called in the same way as the original Lightbox JS. However, in order to do a slideshow, you do have to change the call a bit so that it nows there are images in a series.

http://www.justinbarkhuff.com/lab/lightbox_slideshow/

I have a stupid question. Doesn't ZC have the ability for users/customers to leave reviews as is? So does this module just move those reviews into a sidebox, or are the testimonials new and seperate from the existing review system?

enderandrew:

I have a stupid question. Doesn't ZC have the ability for users/customers to leave reviews as is? So does this module just move those reviews into a sidebox, or are the testimonials new and seperate from the existing review system?

Testimonial is separate from the review system since it isn't tied to any particular product as are the reviews.

Re: Cannot edit testimonials - 1054 Unknown column 'testimonials_url' in 'field list'

Hi Clyde and Everyone,

I have Testimonials Manager v1.4.2 installed with Zen-Cart v1.3.7

Problem is I cannot edit any testimonials

I go in Admin to Tools > Testimonials Manager

Select a testimonial and click "edit" on the right

Even if I don’t change anything when I click UPDATE I get this error message:

1054 Unknown column 'testimonials_url' in 'field list'
in:
[update testimonials_manager set testimonials_title = 'No Dramas', testimonials_url = 'http://', testimonials_name = 'John, Australia', testimonials_mail = '[email protected]', testimonials_html_text = 'I am completely happy with the service I got etc', date_added = now() where testimonials_id = '135']
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.

FYI any changes I make do not register because of this error.

I believe the problem is "Author's URL" on this testimonials manager edit page has an asterix for required, but on my submit testimonials page there is NO FIELD for the customer to enter a URL it is missing so maybe that is causing the error later. (field is filled with http:// if I change it to a real website or even leave blank, same error)

I want to be able to use the edit testimonials function but it always has that error, mainly I just want to fix some testimonials where the customer has put their name or title in the wrong field etc.

2. Also the old testimonials manager let the customer tick a box "Hide my email" or "Show my email" but that no longer appears with my v1.4.2 testimonials manager, how can I get this back? Also if it does show the email can it show in a spam proof way, such as link to john[AT]example.com instead of [email protected]?

3. While I am here I would also like on the submit testimonials page to change the text "Name" to "Name, Company, City, Country" and I have worked out how to change this text trouble is the width allows is so small it then goes over 2-3 lines which I don’t want, is there any way to make this text field wider? or is it easy to add some extra fields for this?

apemusic:

Re: Cannot edit testimonials - 1054 Unknown column 'testimonials_url' in 'field list'

Hi Clyde and Everyone,

I have Testimonials Manager v1.4.2 installed with Zen-Cart v1.3.7

Problem is I cannot edit any testimonials

I go in Admin to Tools > Testimonials Manager

Select a testimonial and click "edit" on the right

Even if I don’t change anything when I click UPDATE I get this error message:

1054 Unknown column 'testimonials_url' in 'field list'
in:
[update testimonials_manager set testimonials_title = 'No Dramas', testimonials_url = 'http://', testimonials_name = 'John, Australia', testimonials_mail = '[email protected]', testimonials_html_text = 'I am completely happy with the service I got etc', date_added = now() where testimonials_id = '135']
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.
...........
From your description above, sounds like you didn't run the upgrade sql.

copy and paste the following in you admin -> tools -> install SQL patches

ALTER TABLE `testimonials_manager` ADD `testimonials_url` VARCHAR( 255 ) NULL DEFAULT NULL AFTER `testimonials_title` ;

2. Also the old testimonials manager let the customer tick a box "Hide my email" or "Show my email" but that no longer appears with my v1.4.2 testimonials manager, how can I get this back? Also if it does show the email can it show in a spam proof way, such as link to john[AT]example.com instead of [email protected]?
   Those options were deliberately left out because of privacy/spam issues.

3. While I am here I would also like on the submit testimonials page to change the text "Name" to "Name, Company, City, Country" and I have worked out how to change this text trouble is the width allows is so small it then goes over 2-3 lines which I don’t want, is there any way to make this text field wider? or is it easy to add some extra fields for this?
   No easy way to add extra fields without re-writting some of the code and making changes to the database table (please note that this is being worked on for a future update)

Version 1.4.3 of Testimonial Manager is now available in the download section.

This update adds options in admin to display "Company", "City" and "State/Country" fields on the Add testimonial page. admin -> configuration -> Testimonial Manager.
If you are upgrading from a previous version don't forget to run the upgrade.sql.

Hi Clyde!!

Wow thanks you are a champ!!

That worked, thanks for the quick help - I see you have a new version out already with those things added too, awesome!

cheers from Sydney, AUS!

clydejones:

From your description above, sounds like you didn't run the upgrade sql.

copy and paste the following in you admin -> tools -> install SQL patches

ALTER TABLE testimonials_manager ADD testimonials_url VARCHAR( 255 ) NULL DEFAULT NULL AFTER testimonials_title ;

> 
> 
> Those options were deliberately left out because of privacy/spam issues.
> 
> 
> No easy way to add extra fields without re-writting some of the code and making changes to the database table (**please note that this is being worked on for a future update**)

Hi Clyde

After uploading all the files to my demostore, I run the SQL , I got an error,

1146 Table 'tiledepo_zc1.zen_zen_testimonials_manager' doesn't exist
in:
[show fields from zen_zen_testimonials_manager]
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.

I try 3 time and re upload the fileS , I dubble check I changed my_template names,
well i must have forgat somthing, I alwyes do:smile:

apemusic:

Hi Clyde!!

Wow thanks you are a champ!!

That worked, thanks for the quick help - I see you have a new version out already with those things added too, awesome!

cheers from Sydney, AUS!

Glad it worked out.

motti:

Hi Clyde

After uploading all the files to my demostore, I run the SQL , I got an error,

1146 Table 'tiledepo_zc1.zen_zen_testimonials_manager' doesn't exist
in:
[show fields from zen_zen_testimonials_manager]
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.

I try 3 time and re upload the fileS , I dubble check I changed my_template names,
well i must have forgat somthing, I alwyes do:smile:

I'll check it.

Which version were you uploading?

Hi

I install Version 1.4.3 and i use the uppgrade folder with the U6grade SQL

Thank you Clyde

Is version 1.4.3 stable now?