1

Error displaying the error page:

Application Instantiation Error:
No database selected SQL=SELECT `session_id` FROM `n0n8z_session` WHERE `session_id` = 'iqi1ntjfnva5c487rajj790a74' LIMIT 0, 1

This error occurs when I try to load a Joomla site into my localhost.

My configuration is correct. What can be problem?

|improve this question
  • 1
    From your Q 'Session doesn't exist joomla' posted on SO, I can see in your comment "in phpmyadmin, only some tables displayed. But in mysql/data folder all tables exist" that obviously process "I have copied my project and its database to wamp server." somehow went wrong. How did you restore live site on Wamp, did you use Akeeba Backup or something else? – Mikan Feb 27 '16 at 12:30
  • @MirkoMikan, what is Akeeba Backup? I just transfered my site from one pc to another – IT Engineer Feb 27 '16 at 13:30
1

From your Q 'Session doesn't exist joomla' posted on SO, I can see in your comment "in phpmyadmin, only some tables displayed. But in mysql/data folder all tables exist" that obviously process "I have copied my project and its database to wamp server." somehow went wrong.

For transfering Joomla site correctly I would recommend using leading Joomla extension Akeeba Backup. Install free Core version on source site, and follow documentation to create installable archive, which will have all it's files and database(s). That archive you will then unpack in the root folder of destination site, go to it's URL in browser, complete Mini-Installation process which will correctly upload database(s) to new location and create correct configuration file for the new site, thus creating exact copy of source site.

I have been using this extension since 2007 and Joomla 1.0, when it was still called JoomlaPack. Also, searching JSE for 'akeeba' will yield bunch of questions, answers and comments regrading this must-have J! Ext.

|improve this answer
  • 1
    very thanks! I will try it and write the result tomorrow. I hope your advice will help me. – IT Engineer Feb 28 '16 at 5:58
  • 1
    You're welcome. I didn't want to confuse you more with some tips&tricks, but I personally prefer NOT to follow instructions to the letter, and NOT to create .JPA file, for whose extracting on the destination site one needs kickstart.php file. For 99% of hosting environments which I have used (and I have worked on 20+ of them), it is safe enough to choose .ZIP file in backup job configuration, and to simply unpack that backup archive on destination site, using either Winzip for localhost, or built-in Extract Archive in every cPanel's File Manager for remote hosts. Anyway... – Mikan Feb 29 '16 at 13:50
  • 1
    thanks. Akeeba backup component has perfectly worked for me! That is cool! – IT Engineer Feb 29 '16 at 15:24
  • I didnt understand your last comment. Why dont u prefer using akeeba? – IT Engineer Feb 29 '16 at 15:25
  • @ITEngineer - Cause when you have experience backing up and restoring sites, it's quicker to do it manually in most cases. – Lodder♦ Feb 29 '16 at 15:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.