Akeeba Backup for Joomla!

Tuesday, 23 August 2011 05:30 CDT

user44856

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? No
Have I searched the forum before posting? No
Have I read the documentation before posting (which pages?)? No
Joomla! version: (unknown)
PHP version: (unknown)
MySQL version: (unknown)
Host: (optional, but it helps us help you)
Akeeba Backup version: (unknown)

EXTREMELY IMPORTANT: Please attach your Akeeba Backup log file in order for us to help you with any backup or restoration issue.

Description of my issue:
I'm having the 'could not connect to database. check parameters' error! at database restore. I've (AGAIN) done all you have told me to do but still having this error. see attached.

Tuesday, 23 August 2011 05:55 CDT

nicholas

With all due respect, I beg to differ. Your problem is that you are using the wrong database name and user name. You are using cPanel. When your cPanel username is "foo" and the name of the database you create is "bar", the complete database name (that you have to use with Joomla!, Akeeba Backup, WordPress, Drupal or any other MySQL-powered script) is foo_bar (cPanel username, underscore, the database name you used).

Likewise, when you are creating a database user e.g. named "jazz", the real username created is foo_jazz (cPanel username, underscore, the username you used).

All of this information is clearly mentioned in our troubleshooting guide for your convenience. Please see https://www.akeebabackup.com/documentation/troubleshooter/abidatabase.html Access to this document is free of charge and does not require a subscription.

It's a good thing that you inadvertently gave me cPanel access instead of only FTP access that I had originally requested. If you hadn't we'd probably have a very serious misunderstanding going on here. Anyway, logging in to your cPanel I was able to see the database connection details and I am now sending you a PM with this information so that you can restore your site :)

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!

Tuesday, 23 August 2011 06:40 CDT

user44856

thankyou for clarification. i've managed to go past database restore up to the very end. However, I'm having the following error when I type the uRL: www.kptf.org.zm;

jtablesession::Store Failed
DB function failed with error number 1146
Table 'ic4713_pension.session' doesn't exist SQL=INSERT INTO `session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '3255d8749b012b6bba15ca597eae4a3c','1314098737','','0','1','0' )
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 44 bytes) in /home/ic4713/public_html/libraries/joomla/error/exception.php on line 117

Tuesday, 23 August 2011 08:47 CDT

nicholas

This does not look correct. The table name (pension) lacks a prefix. Was your site created using Fantastico's Joomla! installer? In this case, let it be noted that Fantastico installs Joomla! in a very broken way, against the Joomla! guidelines, and you have to do some manual editing of the configuration.php file.

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!

Tuesday, 23 August 2011 09:17 CDT

user44856

Please close this thread.

my site is now up after following your instructions closely (refer to PM sent to u)

Thanks for all the help! you are the best!

Tuesday, 23 August 2011 09:21 CDT

nicholas

You're welcome! Thank you for your kind words and your PM :)

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!

Support