Computersight -

Image via Wikipedia

E_NOLOGIN_ACCESS is a common error for Joomla users, and usually it happens when the user transfer his site from local machine, to the online server.

Non-expert users will like this trick, because maybe they don’t know how to modify the database or they are fearing to delete something necessary.

As the site is tranferred online for the first time, probably the userlist tables are not useful, because we don’t have users with their own account, and the table will be resetted with this procedure (and then can be easily rebuilt). We instead save all our content and site structure, and the database.

HOW TO DO

The program you used for the local building is not important, the important thing is that you can use at least a little phpmyadmin and an ftp program like filezilla (you can read their guides, they’re easy-to-learn softwares).

Let’s do a backup to be sure, and we can start. Please read all the article before, and then proceed with the work, reading again.

Open Filezilla (or your ftp software) and erase the content inside, excluding “configuration.php“, then transfer a new copy of Joomla from local.

Then, open the software you used for local building and open his phpmyadmin. Select the database that your website uses, and select export db. From the list of items to export, select all excluding ‘ jos_user ‘, ‘ jos_groups ‘ and all the  ‘jos_core_‘ (that are 7). Export and remember to “save as..”.

The same process must be done with another installation of Joomla, as you did to create the local website at the beginning. After reinstalling Joomla, open again phpmyadmin and this time export only ‘ jos_user ‘, ‘ jos_groups ‘ and all the  ‘jos_core_‘.

You now have a copy of your website database with all your edits and without the core tables, and another copy of a “virgin” Joomla database with only the core tables.

Now we can go to our online host, and we can load to the virgin Joomla installation also our files with all the personalizations, using the ftp software.

Then go to the online host phpmyadmin, select the database and delete all the tables. Now you can import your 2 files with the tables you saved from local.

Now all should be done and working without errors. If this doesn’t work, retry returning to your backup copy (note that is important to do a backup before), and follow the steps again, you will find the correct way to do this.

In some cases it maybe will not work, but usually this is not a bad procedure, and it’s not so easy to find solutions for this error from the net.

Good luck for your website!