Migrating joomla site to a new server returns error 1142

[mwbarican]

Hi,

I am migrating a joomla installation from one server to another. What I only have though is a copy of all the joomla files and database.

I have already imported the database and files but when I access the site, it returns a 1142 error code and says

Code: Select all

"SELECT command denied to user 'aas47637_user'@'localhost' for table 'aas_translation_reference' SQL=SELECT B.`imac` , B.`text` FROM `aasorgsg_db`.`aas_translation_reference` AS A LEFT JOIN `aasorgsg_db`.`aas_translation_en` AS B ON A.`imac` = B.`imac` WHERE A.`load` = '1' AND A.`wid` = '17' LIMIT 2000"

I already applied the necessary privileges to the db user but it still returns that error.

https://prnt.sc/kz2vgr

Anybody have any idea how to fix this? please?

Thank you.

[wojsmol]

Hi
1. Check if user is associated with database.
2. Check if database does not exceed limits enforced by hosting.

[annahersh]

That DB table 'aas_translation_reference' is not for Joomla core. That is a third party extension. However it just means you haven't given all DB privileges to the user.

Run the following query in your database manager (phpmyadmin or similar) to allow the user permission to select on all tables

Code: Select all

// replace dbname with your database name
GRANT ALL PRIVILEGES ON dbname.* TO 'aas47637_user'@'localhost' WITH GRANT OPTION;

See https://dev.mysql.com/doc/refman/8.0/en/grant.html

[mwbarican]

That DB table 'aas_translation_reference' is not for Joomla core. That is a third party extension. However it just means you haven't given all DB privileges to the user.

Run the following query in your database manager (phpmyadmin or similar) to allow the user permission to select on all tables

Code: Select all

// replace dbname with your database name
GRANT ALL PRIVILEGES ON dbname.* TO 'aas47637_user'@'localhost' WITH GRANT OPTION;

See https://dev.mysql.com/doc/refman/8.0/en/grant.html

@annahersh thank you for your reply!

I tried running this but it still returned me an error.

#1044 - Access denied for user 'aas47637'@'localhost' to database 'aas47637'

But as I said, the privileges for the existing user is already provided when I set up the site.

https://prnt.sc/kz2vgr

This might help: http://77.104.168.73/~aas47637/

[mwbarican]

Hi
1. Check if user is associated with database.
2. Check if database does not exceed limits enforced by hosting.

Thank you @wojsmol.

Can you elaborate no.2 please?

For no.1, as stated, it is associated with db. https://prnt.sc/kz9q2v

Thanks!

[AMurray]

An easier way to transfer would have been with Akeeba Backup, and Akeeba Kickstart. All you need to load are two files - kickstart.php and the backup archive *.jpa file. Run the restore script and it's done within a few minutes. You might need to do create the database first and specify those details when prompted in the restoration.

Regards Point #2, would suggest you ask your host about the limits they might impose, and/or refer to the Terms and Conditions of Use (of the hosting service).