Testimonial Manager Support Thread

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

1054 Unknown column 'last_update' in 'field list'
in:
[update testimonials_manager set testimonials_title = 'test4', testimonials_url = 'http://', testimonials_name = 'test test', testimonials_mail = 'phil_king2##########################', testimonials_company = '', testimonials_city = '', testimonials_country = '', testimonials_html_text = 'test4', status = '1', last_update = now() where testimonials_id = '5']

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:

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

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

Thanks