Archived

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

Bear77

1146 Table administrators doesn't exist

11 posts in this topic

Hello everyone,

 

I'm a newbee at this and am having problems that I was hoping someone could help me with. I did a default install of oscommerce using fantastico provided by my hosting company. I then put a template that I bought on the server and can view it fine; however, when I try to log into the Administrator portion of the site I get the following error:

 

1146 - Table 'db_osc1.administrators' doesn't exist select id from administrators limit 1. When I look at the database sure enough the table doesn't exist. Then I installed another default installation on the server to see what had changed and the table doesn't exist in this install either, but I can log into the administrator without a problem.

 

Has anyone seen this problem before? Can anyone give me some clues as to how to fix it. The template files are different than the default install.

 

Thanks in advance

Share this post


Link to post
Share on other sites
Hello everyone,

 

I'm a newbee at this and am having problems that I was hoping someone could help me with. I did a default install of oscommerce using fantastico provided by my hosting company. I then put a template that I bought on the server and can view it fine; however, when I try to log into the Administrator portion of the site I get the following error:

 

1146 - Table 'db_osc1.administrators' doesn't exist select id from administrators limit 1. When I look at the database sure enough the table doesn't exist. Then I installed another default installation on the server to see what had changed and the table doesn't exist in this install either, but I can log into the administrator without a problem.

 

Has anyone seen this problem before? Can anyone give me some clues as to how to fix it. The template files are different than the default install.

 

Thanks in advance

 

Try this: go to: admin/includes/database_tables.php

Enter this: define('TABLE_ADMINISTRATORS', 'administrators');

Share this post


Link to post
Share on other sites

did you install the sql that came with your template?

 

the admin must have a login page with the template

 

verify by seeing if you have a file under admin titled something like login.php

 

HTH

Share this post


Link to post
Share on other sites
did you install the sql that came with your template?

 

the admin must have a login page with the template

 

verify by seeing if you have a file under admin titled something like login.php

 

HTH

Share this post


Link to post
Share on other sites

Hi Rabbit,

 

Thanks for taking the time to help me out I really, really appreciate it!

 

What I did was this; I create a default load of oscommerce on my server, then just over wrote all the files in that folder with the oscommerce template folder.

 

The funny thing is this; the database created by the default load using fantastico really doesn't have an administrator table in it, and also doesn't have a login.php file in the admin folder, which is included in the oscommerce template.

 

The default load of the oscommerce system works fine without having the login.php file in the admin folder. How is the login being processed with the default load may be a good place to start.

 

What do you think, any thoughts?

 

:blush:

Share this post


Link to post
Share on other sites
Try this: go to: admin/includes/database_tables.php

Enter this: define('TABLE_ADMINISTRATORS', 'administrators');

 

Hi cyberdentist thank you for taking the time to help me I really appreciate it. I'll give it a shot to see how it works.

Share this post


Link to post
Share on other sites

Cyberdentist,

 

So I checked the database_table.php file and the statement is there in the template version, but the table in the database that was created by the default load of the OSCommerce system, isn't. The default load of the database_table.php file doesn't have this statement in it.

 

Everything works fine with the default load, so how is the login being processed with the default load. Login credentials on the default load seem to be part of the folder password protection of the hosting service as that is where the password and user id are managed. With the template there's a login.php file that then checks the oscommerce database administrators table to comfirm userid and password, but this table doesn't exist with the default load.

 

Maybe I need to removed the login routine from the admin folder and just use the server folder password protection, but I'm not sure?

 

What do you think?

Share this post


Link to post
Share on other sites

I'm having the same problem, and I added that part to the database_tables.php with no luck. Anyone have any ideas on this? Please!!??

Share this post


Link to post
Share on other sites

chek thru PhpMyAdmin if the table exist.

If Yes then in database tables file make a proper define.

 

Satish

Share this post


Link to post
Share on other sites

I am having the exact same problem. On a clean Fantastico install of osCommerce there is no administrator table in the database. I really would like to know how the administrator is authenticated. I've been digging through the forums and can not come up with anything.

Share this post


Link to post
Share on other sites