Support

Admin Tools

#15662 Backups

Posted in ‘Admin Tools 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
Admin Tools version
n/a

Latest post by nicholas on Tuesday, 09 April 2013 03:53 CDT

Monday, 08 April 2013 02:38 CDT

Abdel08200
Mandatory information on my setup:

I read related articles store above posting (not found)
I tried posting the tickets? not found
I read the documentation before posting (not found) no
Joomla! Version (1.5.26)
PHP Version: (5.2)
MySQL (5.1.66)
Host: (invicta.fr)
Admin Tools version (2.2.10)

Description of my problem:

Hello,
backups of my sites installed on my server fail since I changed the table prefix

I can not return to "_jos"

thank you

Abdel

message:

Dump MySQL database mysite in progress ..
.. the dump failed.

mysqldump: Could not execute 'SHOW FIELDS FROM `uoat_jf_languages​​`': View 'my_site.uoat_jf_languages​​' references invalid table (s) or column (s) or function (s) or definer / invoker of view rights to use' em Lack (1356 )

The backup failed. See above the report to determine the reason.

Monday, 08 April 2013 03:56 CDT

tampe125
Hi abdel,

this is an issue with Akeeba Backup or Akeeba Admin Tools?
How did you backup your site? With Akeeba Backup?
How are you restoring the backup?

Please let me know if I'm correct: you created a backup while you're using xxx_ as table prefix.
Then you changed your table prefix to yyy_ and you're trying to restore it, right?

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 08 April 2013 04:08 CDT

Abdel08200
Hi

I usually have an automatic backup of my server and therefore all my sites in Virtualmin.

Every night, the backup is automatic. But since I installed admintools pro, it does work more. I just find it blocks on the table "jf_languages​​" of joomfisch.

I have this message:

mysqldump: Could not execute 'SHOW FIELDS FROM `uoat_jf_languages​​`': View 'mon_site.uoat_jf_languages​​' references invalid table (s) or column (s) or function (s) or definer / invoker of view rights to use' em Lack (1356 )

I did not have it before

thank you

Abdel

Monday, 08 April 2013 04:15 CDT

tampe125
How did you backup your site? With Akeeba Backup?

How are you restoring the backup?



Please let me know if I'm correct: you created a backup while you're using xxx_ as table prefix.

Then you changed your table prefix to yyy_ and you're trying to restore it, right?

Please answer to my questions, since they are helpful to narrow down any potential issue.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 08 April 2013 04:21 CDT

nicholas
Hello Abdel,

I think I understand what you mean.

The table you mention is actually not a table. It is a view. In case you're wondering this is like a stored query. It seems that it refers to the old tables, not the ones on your site. The best way to handle this is to delete this view using phpMyAdmin and trying to reinstall JoomFish.

Alternatively, you need to manually rename your tables using the old JOS_ prefix. You can only do that manually. This means that you have to use phpMyAdmin to do that.

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!

Monday, 08 April 2013 08:29 CDT

Abdel08200
"I think i understand what you mean."
I also believe

The table you mention is Actually not a table. It is a view. In case you're wondering this is like a Stored query. It Seems That It Refers to the old tables, not the ones on your site. The best way to handle this is to delete this view using phpMyAdmin and trying to reinstall JoomFish.

I reinstalled 1/Si joomfish I'm afraid of losing my régléges and translated texts.
2 / impossible to remove the table in question, I have this message:
"# 1051 - Unknown table 'xxx_jf_languages​​"


Alternatively, you need to manually rename your tables using the old prefix jos_. You can only do that manually. This means clustering That You Have to use phpMyAdmin to do that.

I did but the site says it can not find the tables fame

Monday, 08 April 2013 08:51 CDT

nicholas
You should be able to remove the view. The error message you describe tells me that you're trying to remove their own table. I mean, you are typing the name wrong. I really cannot help with that.

Regarding renaming the tables, it is very easy and just takes quite a lot of time. I am not sure what the error message you describe is. There is no table named fame in Joomla!. I suspect that this is the result of a bad translation. Can you please paste the exact error message that you are receiving?

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!

Monday, 08 April 2013 09:12 CDT

Abdel08200
1 je cliquepour supprimer
2 j'ai ce message

voici le message (capture jpg):

Monday, 08 April 2013 09:22 CDT

nicholas
Est-il possible de demander à votre hébergeur de le faire pour vous?

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!

Monday, 08 April 2013 09:28 CDT

Abdel08200
humpf!
I am the host, sorry:-b

Monday, 08 April 2013 10:34 CDT

Abdel08200
Bonjour,

merci j'ai fini par trouver un moyen dans virtualmin.

Par contre je suis superadministrateur mais je n'arrive plus à créer de compte, j'ai l'erreur :

403 - Une erreur est survenue

Accès refusé !

Vous avez une idée SVP

Merci

Monday, 08 April 2013 10:37 CDT

nicholas
S'il vous plaît lire la page suivante: https://www.akeebabackup.com/documentation/troubleshooter/atspecialusers.html C'est une question très fréquente. Les instructions sur cette page résoudre toujours le problème.

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, 09 April 2013 02:34 CDT

Abdel08200
Bonjour,

merci pour tout, vous êtes disponible et réactif ce qui est très rare.
félicitations !

Merci

Abdel

Tuesday, 09 April 2013 03:53 CDT

nicholas
De rien! Nous sommes toujours heureux d'être de l'aide à nos utilisateurs :)

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 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!