1146 error in admin

[nihanshe]

Hi I have tried to install this contribution professional&packing slip and I have this in the English file and have this error below and I'm not sure what to do, can any point me in the right direction.

Regards Nicky

 

http://addons.oscommerce.com/info/2604

 

 

 

 

 

 

/* Please, modify your lenguage file with this string */ // page title define('TITLE', '' . STORE_NAME . ''); 1146 - Table 'ukpenkicom.TABLE_ADMINISTRATORS' doesn't exist

 

select id from TABLE_ADMINISTRATORS limit 1

 

[TEP STOP]

[ricksteruk2005]

You need to use PHPMYADMIN and run this sql query

 

 

CREATE TABLE `administrators` (

`id` int(11) NOT NULL auto_increment,

`user_name` varchar(32) character set latin1 collate latin1_bin NOT NULL,

`user_password` varchar(40) NOT NULL,

PRIMARY KEY (`id`)

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

 

--

-- Data dump for tabellen `administrators`

--

 

INSERT INTO `administrators` VALUES (1, CHANGE ME TO A USERNAME, 'CHANGE ME TO A VERY HARD TO GUESS PASSWORD USING NUMBERS AND SYMBOLS LIKE@ ');

[germ]

You might want to check your /includes/database_tables.php to see if you have lost this:

 

  define('TABLE_ADMINISTRATORS', 'administrators');

The fact that the error has TABLE_ADMINISTRATORS (upper case) makes me think you've lost the definition for it.

:blush:

[nihanshe]

Hi Many thanks for the reply, on the admin sign in page I now have this error

 

This seemed to missing so I installed it into admin/includes/database_tables.php define('TABLE_ADMINISTRATORS', 'administrators');

 

but I know have this error, sorry guys

 

 

/* Please, modify your lenguage file with this string */ // page title define('TITLE', '' . ukpenkits . '');

Warning: Cannot modify header information - headers already sent by (output started at /home/ukpenkicom/public_html/catalog/admin/includes/languages/english.php:6) in /home/ukpenkicom/public_html/catalog/admin/includes/functions/general.php on line 22

[germ]

Headers Already Sent

 

Click the link above for an explanation.

 

The problem is in /catalog/admin/includes/languages/english.php (line 6)

 

If you want you can post the first 10 or so lines from the file.

 

I'm sure someone will see the malfunction.

[nihanshe]

Thanks all for trying to help me, OK here's what I have done I have put backed-up files back in place and will try another install later, now that I have uploaded the original files I can now can enter the admin section of my shop and all is fine apart from view customers invoices, it gives me this error when i click the invoice tab, I have ran the sql file and it say that this is already installed.

 

 

This the message below when I go to my admin invoice, the packing slip works fine

 

1146 - Table 'ukpenkicom.TABLE_INVOICE' doesn't exist

 

select date_invoice from TABLE_INVOICE where substring(date_invoice,7) < '2009'

 

[TEP STOP]

 

this is within mysql

 

SQL-query:

 

/* Table struture for table_invoice */ CREATE TABLE `table_invoice` (

`orders_id` int( 11 ) NOT NULL default '0',

`date_invoice` varchar( 11 ) default NULL ,

`invoice_id` int( 11 ) NOT NULL AUTO_INCREMENT ,

`num_invoice` int( 6 ) NOT NULL default '0',

PRIMARY KEY ( `invoice_id` )

) TYPE = MYISAM AUTO_INCREMENT =1

 

MySQL said:

#1050 - Table 'table_invoice' already exists

[germ]

Do you have this in /admin/includes/database_tables.php

 

  define('TABLE_INVOICE', 'table_invoice');

:unsure:

[nihanshe]

Thanks for your reply germ I have done what you told me to and all was going well with a few minor title/headingerrors s I just reinstalled the contribution and all was going well until I had this error looks like I will have to uninstall again

 

 

Warning: main(includes/database_tables.php) [function.main]: failed to open stream: No such file or directory in /home/ukpenkicom/public_html/catalog/includes/application_top.php on line 58

 

Fatal error: main() [function.require]: Failed opening required 'includes/database_tables.php' (include_path='.:/usr/share/pear') in /home/ukpenkicom/public_html/catalog/includes/application_top.php on line 58

 

Regards Nicky

[Guest]

My Error 1146 message occurs when trying to go through the checkout process ... says my "osc1.visitor" table doesn't exist.

If only I knew what code to say -- and where to say it. Does this error message come from a database that is supposed to be defined in admin/includes/database_tables.php ?? or includes/database_tables.php ?? And how do I set up this missing table anyway?

[Sardonic76]

My Error 1146 message occurs when trying to go through the checkout process ... says my "osc1.visitor" table doesn't exist.

If only I knew what code to say -- and where to say it. Does this error message come from a database that is supposed to be defined in admin/includes/database_tables.php ?? or includes/database_tables.php ?? And how do I set up this missing table anyway?

 

I have the EXACT same issue.

Anyone has any thoughts???? Please???