• Registered: 08/24/2010
  • Posts: 2

Topic: Login problem after server upgrade

I am setting up FA locally using Uniform Server and have just updated to a newer server version. I am having trouble logging in to front accounting now.

I backed up my FA folder from the server root and exported my database to a backup file using phpmyadmin. After updating server files I restored the FA folder to the root and re-imported my database. I have not been able to log back in after this procedure.

Any help / insights on how to log in to my FA install will be appreciated.

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Login problem after server upgrade

No idea where is the source of problem, but if you just cannot login because of lost/changed password, you can (using phpmyadmin) update it with the standard one ('password')  found in sql/en_US.sql  file.
Janusz

  • Registered: 08/24/2010
  • Posts: 2

Re: Login problem after server upgrade

Thanks itronics.

Not sure how I would change that. Is the file in the FA folder? Can't seem to find it. I changed the MD5 in my users table on the DB in phpmyadmin (based on a post by Joe some time back) but that didn't work.

Also, is there a way I can just create a new database, re-install FA and THEN retrieve my previous data from the install I can't log in to and place it in my new DB.

Thanks.

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Login problem after server upgrade

Providing your old database use 0_ prefix you can also:
. install FA from scratch with new database;
. copy backup file you have created to company/0/baclups directory;
. login, go to Backup and Restore, select the backupfile and restore it.

Janusz