Testimonial Manager Support Thread

[clydejones]

I have just installed testimonial manager for the first time (from downloads section), all seems to be working fine until it comes to review and update testimonials. When no country is added it is automatically filled with the customers email address, which is not a problem it can be deleted when updating.

But when i press update i get the following error:


From a previous post i think i can fix this by adding a last_update field to my database table. Before i try it can someone tell me if the following code is correct:



i don't know SQL at all really. I would be very grateful for any help anyone could offer me with this.

Thanks

Yes, Run that statement from your admin -> tools -> install sql patches

[Phil020782]

Thanks clyde that worked perfectly, fantastic contrib btw.

[AlexT]

Try running just this line:

INSERT INTO `testimonials_manager` VALUES (1, 'Great', '', 'Perfect Designing', '', 'This is just a test submission to show you how it looks, great, eh?', 'support@perfectdesigning.net', NULL, NULL, NULL, 1, 1, now());

Clyde,

Thanks for your help.

I ran this line and everyting seemed fine: I could add testimonials from both the webside and from Admin and they showed correctly. But, when I tried to edit a testimonial (I used your example and added city Perth), the following error message appeared:

1054 Unknown column 'last_update' in 'field list'
in:
[update zen_testimonials_manager set testimonials_title = 'Great', testimonials_url = 'http://', testimonials_name = 'Perfect Designing', testimonials_mail = 'support@perfectdesigning.net', testimonials_company = '', testimonials_city = 'Perth', testimonials_country = '', testimonials_html_text = 'This is just a test submission to show you how it looks, great, eh?', status = '1', last_update = now() where testimonials_id = '1']

Am I supposed to be able to edit them?

Thanks,
Alex

[clydejones]

Clyde,

Thanks for your help.

I ran this line and everyting seemed fine: I could add testimonials from both the webside and from Admin and they showed correctly. But, when I tried to edit a testimonial (I used your example and added city Perth), the following error message appeared:

1054 Unknown column 'last_update' in 'field list'
in:
[update zen_testimonials_manager set testimonials_title = 'Great', testimonials_url = 'http://', testimonials_name = 'Perfect Designing', testimonials_mail = 'support@perfectdesigning.net', testimonials_company = '', testimonials_city = 'Perth', testimonials_country = '', testimonials_html_text = 'This is just a test submission to show you how it looks, great, eh?', status = '1', last_update = now() where testimonials_id = '1']

Am I supposed to be able to edit them?

Thanks,
Alex

Run this from admin -> tools -> insert sql patches

ALTER TABLE `testimonials_manager` ADD `last_update` datetime NOT NULL default '0000-00-00 00:00:00 AFTER `testimonials_html_text ` ;

I've fixed this in the download and will upload it ASAP

[AlexT]

Run this from admin -> tools -> insert sql patches

ALTER TABLE `testimonials_manager` ADD `last_update` datetime NOT NULL default '0000-00-00 00:00:00 AFTER `testimonials_html_text ` ;

I've fixed this in the download and will upload it ASAP

Something is not quite right again, I've ran the line, the following message has appeared:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0000-00-00 00:00:00 AFTER testimonials_html_text' at line 1
in:
[ALTER TABLE zen_testimonials_manager ADD last_update datetime NOT NULL default '0000-00-00 00:00:00 AFTER testimonials_html_text ;]
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.

The versions are:
PHP Version: 5.2.1 (Zend: 2.2.0)
Database: MySQL 5.0.27-standard

Thank you,
Alex

[clydejones]

Something is not quite right again, I've ran the line, the following message has appeared:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0000-00-00 00:00:00 AFTER testimonials_html_text' at line 1
in:
[ALTER TABLE zen_testimonials_manager ADD last_update datetime NOT NULL default '0000-00-00 00:00:00 AFTER testimonials_html_text ;]
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.

The versions are:
PHP Version: 5.2.1 (Zend: 2.2.0)
Database: MySQL 5.0.27-standard

Thank you,
Alex

Try this one:

ALTER TABLE `testimonials_manager` ADD `last_update` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `testimonials_html_text` ;

[AlexT]

Try this one:

ALTER TABLE `testimonials_manager` ADD `last_update` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `testimonials_html_text` ;

Everything works fine now, thank you very much for your help!

Alex

[maza]

Thanks Clyde, I got it worked now.

[maza]

Hey Clyde, I have noticed new issue now.

I got a TEXT_FIELD_OPTIONAL appeared besides my 'fill in the blanks' form inside ZC admin.

Is TM giving this problem? Do you have any idea how to fix it?

[clydejones]

Hey Clyde, I have noticed new issue now.

I got a TEXT_FIELD_OPTIONAL appeared besides my 'fill in the blanks' form inside ZC admin.

Is TM giving this problem? Do you have any idea how to fix it?

Not sure it it is TM.

open admin/includes/functions/html_output.php

at around line 235 you should see:

if ($required == false) $field .= TEXT_FIELD_OPTIONAL;

Just delete this line and see if that clears that text string.