Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

help with admin user update & testimonials


clarocque

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

 

[TEP STOP]

 

 

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

 

Any Help???

 

Chris

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)
) TYPE=MyISAM;

 

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');

Hth,

Matt

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...