Testimonial Manager Support Thread

Quote:

---

Originally Posted by Phil020782

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

Thanks clyde that worked perfectly, fantastic contrib btw.

Quote:

---

Originally Posted by clydejones

Try running just this line:

Code:

---

INSERT INTO `testimonials_manager` VALUES (1, 'Great', '', 'Perfect Designing', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', 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 = '[email protected]', 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

Quote:

---

Originally Posted by AlexT

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 = '[email protected]', 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

Code:

---

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

Quote:

---

Originally Posted by clydejones

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

Code:

---

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

Quote:

---

Originally Posted by AlexT

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:

Code:

---

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

---

Quote:

---

Originally Posted by clydejones

Try this one:

Code:

---

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

Thanks Clyde, I got it worked now.

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?

Quote:

---

Originally Posted by 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?

---

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.