1146 - Table 'database.administrators' doesn't exist

[blavaud]

Hello,

When i try to login on my admin there is this message which appears :

 

1146 - Table 'mydatabase.administrators' doesn't exist

select id from administrators limit 1

 

I really dont know how to fix it !

 

I am beginer so i relly apologize if answer is easy, and of course thanx you in advance for your help !

[web-project]

simply create the table mydatabase.administrators...

[blavaud]

simply create the table mydatabase.administrators...

 

Hello, thanx for your answer.

But as i begin, i dont know what is a administor "table" or how to create it.

 

Could you help me ?

Already thanx for the time you spend to answer.

bye.

[Slowmoe]

Hello, thanx for your answer.

But as i begin, i dont know what is a administor "table" or how to create it.

 

Could you help me ?

Already thanx for the time you spend to answer.

bye.

Not that I can give you much help. But what needs to be done is that you have to create

the table in the configuration file in your myphp section....

[Slowmoe]

Not that I can give you much help. But what needs to be done is that you have to create

the table in the configuration file in your myphp section....

Ups wrong info ...very sorry....

[Slowmoe]

Ok i'm back again... :thumbsup:

And have solve the problem, well at least for my self.

 

What i did was I downloaded from myphp on one of my domains the administrator table.

and uploaded it to the site where my problem was.

 

I think it could work for you to and if you drop me pm with a mail adress

i will sent you the file with instructions.... :blush: i don't know if I can upload i here :blush:

 

regards

[blavaud]

ecellent.

i have done what you suggest and it works perfectly.

 

thanx a lot for your help !

bye.

[Slowmoe]

There have been a couple of inquires on this problem. :rolleyes:

So I have put the file up here

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

 

The file contains an install text as well.

 

Regards

Slowmoe

[alexpui]

There have been a couple of inquires on this problem. :

Regards

Slowmoe

Slowmoe,

 

How about :

 

1146 - Table 'mysite.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

Where and how can I create the table?

 

Thanks

 

Alex

[osdude]

There have been a couple of inquires on this problem. :rolleyes:

So I have put the file up here

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

 

The file contains an install text as well.

 

Regards

Slowmoe

 

thank you!!!!

 

I had used a previous SQL to 'fix' this problem, but it didn't work for me.

The instructions were very helpful.

[Slowmoe]

Slowmoe,

 

How about :

 

1146 - Table 'mysite.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

Where and how can I create the table?

 

Thanks

 

Alex

 

 

Hi ALex

Have this something to do with the admin login in problem?

I havent experienced this error. But you can add/deleted data fields in your myphp admin area. You should have recieved information about where you can find myphp from your internet provider.

I am no wiz in databases and only solved the admin problem using a little logic.

 

Sorry I can't help more

Regards

Slowmoe

[Vury]

Hello,

This is a Database problem. Installation Wizard can not create the required Table (like DBNAME.administrators), because MySQL 4 does not support the required (CHARACTER SET latin1 COLLATE latin1_bin) command like MySQL 5.

 

A 'modification' or an 'Update' with MySQL 4 will be fixed this problem.

[SafeerQ]

There have been a couple of inquires on this problem. :rolleyes:

So I have put the file up here

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

 

The file contains an install text as well.

 

Regards

Slowmoe

 

 

For some reason i can't download the file.... can you email it to me if i give you my email in pm?