Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error when trying to open Admin... Administrators table doesn't exist


shana.jk

Recommended Posts

Posted

Im getting this error when i try to open my Admin.... i checked my mysql and the administrators is there.

 

 

 

1146 - Table 'bpbponl_store.TABLE_ADMINISTRATORS' doesn't exist

 

select id from TABLE_ADMINISTRATORS limit 1

 

[TEP STOP]

 

 

 

what can i do???

Posted

probably a language definitoin? what version? if a new install, reinstall the database.

Posted
probably a language definitoin? what version? if a new install, reinstall the database.

 

 

Its the RC2a

 

is there anyway to fix without reinstalling the database. I dont have alot to lose but i would prefer not to have to start over if possible.

Posted

Did you make any changes to admin/administrators.php? I think is the line you need to check around line 25 this is what it says in mine

		$check_query = tep_db_query("select id from " . TABLE_ADMINISTRATORS . " where user_name = '" . tep_db_input($username) . "' limit 1");

Posted
Did you make any changes to admin/administrators.php? I think is the line you need to check around line 25 this is what it says in mine

$check_query = tep_db_query("select id from " . TABLE_ADMINISTRATORS . " where user_name = '" . tep_db_input($username) . "' limit 1");

       if (tep_db_num_rows($check_query) < 1) {
         tep_db_query("insert into " . TABLE_ADMINISTRATORS . " (user_name, user_password) values ('" . tep_db_input($username) . "', '" . tep_db_input(tep_encrypt_password($password)) . "')");
       } else {

Posted
i guess ill just start over.... :(

 

this is happening because TABLE_ADMINISTRATORS isn't defined. TABLE_ADMINISTRATORS should be defined in admin/includes/database_tables.php. make sure this declaration is present and that the database_tables.php is being included before it's being referenced.

Archived

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

×
×
  • Create New...