help with admin user update & testimonials

[clarocque]

I recently installed the admin_22 contibution. I seem to have it working ok, but I installed the Customer Testimonial previously and now I hav made enough changes to get it to show the option in the admin panel, but when I click on it i get this error:

 

Testimonials Manager

 

ID Name URL Testimonial Status Action

1146 - Table 'local.TABLE_CUSTOMER_TESTIMONIALS' doesn't exist

 

select count(*) as total from TABLE_CUSTOMER_TESTIMONIALS

 

[TEP STOP]

 

 

But it does - I am so frustrated - I have searched, but I couldnt find anything (maybe I missed it)

 

Any Help???

 

Chris

[RobAnderson]

Hi Chris, silly question, but have you added the Testimonials SQL table. There is a file "testimonials.sql" that you can run in phpmyadmin that will add this for you.

 

Looks like this:

 

#
# Table structure for table `customer_testimonials`
#

CREATE TABLE customer_testimonials (
 testimonials_title varchar(64) NOT NULL default '',
 testimonials_id int(5) NOT NULL auto_increment,
 testimonials_html_text longtext NOT NULL,
 testimonials_name varchar(50) NOT NULL default '',
 testimonials_url varchar(150) NOT NULL default '',
 date_added varchar(50) NOT NULL default '',
 status tinyint(1) NOT NULL default '1',
 PRIMARY KEY  (testimonials_id)
) TYPE=MyISAM;

 

Cheers, Rob

[Guest]

In admin/includes/database_tables.php, you need something like

define('TABLE_CUSTOMER_TESTIMONIALS', 'customer_testimonials');

Hth,

Matt

[RobAnderson]

Oh yeah, that's it...duh...

 

Rob <blush>