Testimonial Manager Support Thread

[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.

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?

[clydejones]

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)

[clydejones]

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.

[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!

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)

[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

[clydejones]

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.

[clydejones]

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

I'll check it.

Which version were you uploading?

[motti]

Hi

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

Thank you Clyde