Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

help with admin user update & testimonials


Recommended Posts

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





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


Any Help???



osC Contributions I have published.


Note: Some I only provided minor changes, updates or additions!

Link to comment
Share on other sites

  • 5 weeks later...

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)


Cheers, Rob

Link to comment
Share on other sites

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

define('TABLE_CUSTOMER_TESTIMONIALS', 'customer_testimonials');



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...