Support

Akeeba Backup for Joomla!

#14420 No database definitions were found or no database was selected

Posted in ‘Akeeba Backup for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by cas on Tuesday, 18 December 2012 03:50 CST

cas

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 1.5
PHP version: 5.3.8
MySQL version: 5.1.65-cll
Host: www.thisisboss.com
Akeeba Backup version: 3.4.3

EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 2Mb, please upload it on your server and post a link to it.

Description of my issue:

Hi Nicholas,

I cannot get a restore to work.  During the restore, I tried both Kickstart 3.5.2 and 3.0.rc1, and they both return: "No database definitions were found or no database was selected."

In reading about this same issue in other tickets, I tried:

1) Running it in Firefox 10.0.11, IE 8.0 (Win7 64), and Chrome 23.0.1271.97 m.

2) I changed the properties to 777 for databases.ini file inside the installation/sql directory. 

3) I tried creating "storagedata.dat" and uploading it to "installation" directory and setting the properties to 777.

But none of these fixed the problem.

When I extracted the backup to look for the akeeba.backend.log in the backup folder to send you, there is no file akeeba.backend.log.  Is this something that is not backed up? 

What should I try now?

Thanks,

Chuck

nicholas
Akeeba Staff
Manager

The version of Kickstart is unrelated to your issue. Remember, Kickstart simply extracts the archive. The actual restoration is performed by the Akeeba Backup Installer, the restoration script which is included in your backup archive. This is only related to the Akeeba Backup version you used to backup your site with.

Please check the extracted installation/sql directory. What are the files included there and what are their sizes?

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

cas

Hi Nicholas,

I attached a screenshot of the installation/sql directory. 

FYI, this is a fresh extract, so the properties for databases.ini file is set to 644, but I did try to run this when set to 777.

Thanks,

Chuck

nicholas
Akeeba Staff
Manager

OK. I think I know what this is. Can you please try continuing the restoration despite the warning message?

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

cas

I tried it about 8 times with different settings based on the other ticket recommendations, but the end result is that the website never works properly.

nicholas
Akeeba Staff
Manager

This is a bit ambiguous. After proceeding with the restoration, does it ask you to restore the database? Do you see a adatabase restoration progress bar? Do you see tables written to the database?

When you say "the website never works properly" is just like saying "my car doesn't work as it should". It means absolutely nothing. Tell me EXACTLY what the error message and problem is. If the database didn't restore at all then your site would simply display an error message about not being able to connect to MySQL and would die. If something loads then the database restoration DID work and you have a completely different issue. If you want me to help you please don't make me look in my crystal ball or read your mind; I am a lousy psychic ;) Tell me what the error message and the problem is and I can help you.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

cas

Hi Nicholas,

Sorry, but with 8 different restore tries, the final results varied, and since his production website is down, I was hoping you had resolved this problem before and had a solution ready to go without me wasting your valuable time by detailing everything.  Okay, with that excuse out of the way :-), the first time it was restored, most of the site worked, but some of the banners were missing, which were done using Joomla Modules.  The other issue was when adding a product into the shopping cart (VirtueMart), it caused the website to fail. I don't remember the exact error, and since I knew the restore didn't complete properly, I figured I would just rerun the restore to a successful completion, and the website should work properly.  Since your restores always worked perfectly for years, I got over confident. ;)   The next several restores, resulted in the same restore error "No database definitions were found or no database was selected.", but the website and the admin would not come up most of these times.  It got this error most of time: [an error occurred while processing this directive].  I say most of the time, because I've lost track.  There may have been other errors, but at 3am my memory was spotty.  If these spotty details don't help you, I can run the restore again and better document the results.  Perhaps you have a specific way you want me to run it again? 

Thanks,

Chuck

 

nicholas
Akeeba Staff
Manager

Searching the error message on Google yields this top result: http://www.bluehostforum.com/showthread.php?32117-an-error-occurred-while-processing-this-directive Quoting:

ISSUE RESOLVED: For the benefit of anyone encountering a similar problem, try the steps that follow:

- Go to cPanel
- Open File Manager from Files section
- Navigate to domain folder
- Check "Perms" column on far right hand side
- Files should be set to: 0644 (this is the UNIX file permissions)
- Folders should be set to: 0755

This seems unrelated to database restoration. If all else fails you can try the emergency manual restoration procedure: https://www.akeebabackup.com/documentation/akeeba-backup-documentation/unorthodox-emergency-restoration.html

Does that help?

PS: It's 45 minutes past midnight over here. I am going to sleep. It will take me a while to see your reply.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

cas

Hi Nicholas,

I got it working!  First I used Kickstart to extract the files on the host server, but I didn't run the next steps.  I then went through the manual process you sent me to rebuild the database.  All the database steps worked without any errors. 

The website and admin seems to work perfectly for all the pages I tested. 

FYI, initialy the admin worked, but only the website home page would came up, but all the other website pages get this error: [an error occurred while processing this directive].  I checked the permissions and they were fine, so as a lucky guess, I ran ATP to rebuild the .htaccess file and then everything started working perfectly!  Somedays it's better to be lucky than good! :-) 

Thanks for your help!

Chuck

nicholas
Akeeba Staff
Manager

Oh, the .htaccess was the obvious culprit, already documented, and I skipped it from my reply. Yeah, I should have told you to check the .htaccess first.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

cas

Thats okay... I'm just glad it's working.

Have a great day!

Cheers,

Chuck

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!