Testimonial Manager Support Thread

[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?', '[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

[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 = '[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

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?