Quote Originally Posted by apemusic View Post
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

Code:
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)