Error 1146

[koalaphil]

1146 - Table 'dabstedd_osc1.customers' doesn't exist

 

select count(*) as count from customers

 

[TEP STOP]

 

This is message on admin page of osCommerce.

 

Trying to delete the customer requirement of telephone number, I seemed to have deleted a whole section (Do i need to get my IT man back to help) or is there a way i can undo what i have done

can't access oscommerce admin area at all.

[chowhan]

run this

 

DROP TABLE IF EXISTS `customers`;

CREATE TABLE `customers` (

`customers_id` int(11) NOT NULL auto_increment,

`customers_gender` char(1) NOT NULL default '',

`customers_firstname` varchar(32) NOT NULL default '',

`customers_lastname` varchar(32) NOT NULL default '',

`customers_dob` datetime NOT NULL default '0000-00-00 00:00:00',

`customers_email_address` varchar(96) NOT NULL default '',

`customers_default_address_id` int(11) default NULL,

`customers_telephone` varchar(32) NOT NULL default '',

`customers_fax` varchar(32) default NULL,

`customers_password` varchar(40) NOT NULL default '',

`customers_newsletter` char(1) default NULL,

PRIMARY KEY (`customers_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1061 ;

[♥Vger]

Try this instead:

 

DROP TABLE IF EXISTS customers;

CREATE TABLE customers (

customers_id int(11) NOT NULL auto_increment,

customers_gender char(1) NOT NULL default '',

customers_firstname varchar(32) NOT NULL default '',

customers_lastname varchar(32) NOT NULL default '',

customers_dob datetime NOT NULL default '0000-00-00 00:00:00',

customers_email_address varchar(96) NOT NULL default '',

customers_default_address_id int(11) default NULL,

customers_telephone varchar(32) NOT NULL default '',

customers_fax varchar(32) default NULL,

customers_password varchar(40) NOT NULL default '',

customers_newsletter char(1) default NULL,

PRIMARY KEY (customers_id)

) ENGINE=MyISAM AUTO_INCREMENT=1;

 

Vger