Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

adminstrator login


Recommended Posts



Log into the hosting control panel and use phpmyadmin to truncate the administrators table. Once that's done, log back into the admin area and create a NEW administrator account.






Link to comment
Share on other sites



Forgive my ignorance, but can you offer a little more detail as to how to truncate the administrators table.




login to the sites cpanel

select phpMYadmin (usually located in the Databases section)

Load the Oscommerce database

In the SQL tab

run this:

TRUNCATE TABLE "administrators"


That should drop the data and require you to make a new password when you first hit the admin panel on oscommerce.

Link to comment
Share on other sites

Adminstrators table no longer appears on the list and now i get this error when running the command you suggested.



SQL query:


TRUNCATE TABLE "administrators"


MySQL said:


#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"administrators"' at line 1


I'm not sure what to do now. i did back up the database 3 days ago.

Link to comment
Share on other sites


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

  • Create New...