Akeeba Backup for Joomla!

Sunday, 10 November 2024 08:20 CST

HDcms

Hello

I installed a localhost server on my ubuntu 24.04 according to the documentation https://doc.ubuntu-fr.org/phpmyadmin#acces_root
I have created several new sites with no problems.

I can't manage to restore 2 akeeba backups of joomla sites that were online last week before the domain name was stopped.
Each time I use the script in the documentation

CREATE USER 'nom_utilisateur_choisi'@'localhost' IDENTIFIED BY 'mot_de_passe_solide';
GRANT ALL ON *.* TO 'nom_utilisateur_choisi'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
QUIT;

The restoration goes all the way
But when I connect the site I get errors. What should I do?

****************
...

DatabaseDriver->setQuery() in /var/www/html/aza/libraries/src/Menu/SiteMenu.php (line 166)

)
->bind(':currentDate2', $currentDate)
->order($this->db->quoteName('m.lft'));
$items = [];
$iterator = $this->db->setQuery($query)->getIterator();
foreach ($iterator as $item) {
$items[$item->id] = new MenuItem((array) $item);
}

...

regards

Edited by HDcms on 2024-11-10 08:21 CST

Sunday, 10 November 2024 16:43 CST

nicholas

Can you please check that the new username and password have been transcribed in your configuration.php file?

You should be looking for the following lines (note that they are NOT together in the file):

public $host = 'localhost';
public $db = 'my_database_name';
public $user = 'my_database_username';
public $password = 'my_database_users_password';

If they have not been transcribed, next time you restore your site pause at the last screen of the restoration and check if it tells you that you need to manually modify your configuration.php file. If it does, follow the instructions before closing that browser tab.

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, 12 November 2024 05:20 CST

HDcms

Hi
I started again with the same script to generate the database with the member. The installation goes perfectly.

No error message with debug mode enabled but I have a white screen with the message:

"An error occurred while connecting to localhost.
The site may be temporarily unavailable or overloaded. Try again later;
If you cannot navigate any site, check your computer's network connection;
If your computer or network is protected by a firewall or proxy, make sure that Firefox is allowed to access the Web"

Regards

Tuesday, 12 November 2024 05:43 CST

nicholas

Not much of an error message to go by, but let's see if you have bumped against the same thing I see most of the time. Check your .htaccess. There is an AddHandler or SetHandler line. Remove it. Does that help?

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, 12 November 2024 06:22 CST

HDcms

Hi

I don't have these lines. I renamed .htaccess to .htaccessEX
I have the same message!

Tuesday, 12 November 2024 07:54 CST

nicholas

Are you sure the Apache service is started? If you are using PHP-FPM you must make sure that the PHP-FPM service for the version of PHP you are using by default is also started. If either service is not started then, of course, you will not be able to access your site as there is no server to serve it.

Check your configuration.php file. Find this line:

public $force_ssl = 0;

Make sure that the number in the right hand side is 0 (zero), NOT 1, NOT 2. The reason for that is that you have probably not set up HTTPS on your local server.

If you see an automatic redirection from HTTP to HTTPS and you don't know why it's happening you will have to set up HTTPS on your Apache server.

Kindly note that all of that falls under "hosting issues" and is well outside the scope of our support. All the information I am giving you here is basically from the goodness of my heart, as one Linux user to another. I would also like to note that I am mostly using Arch Linux these days, but I still have applicable knowledge for Ubuntu Server. I may mix the two, though (e.g. I don't remember if the Apache service on Ubuntu is called apache2 or httpd).

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, 12 November 2024 08:46 CST

HDcms

Hi

Luckily you have a heart :-) :-)

Bingo I had put public $force_ssl = '2';

Thank you very much

Regards

Tuesday, 12 November 2024 10:03 CST

nicholas

You're welcome! I love helping people; it's why I am a Free and Open Source Software developer instead of a proprietary business software developer – it was actually going that way until I found Mambo and its amazing community (which transmuted to Joomla!) around 20 years ago!

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