[USE full Database name in Joomla Configuration] Duplicate key name: Erreur à la restauration

Hi George,

I tried it but with no more success.

thanks.

Hello

i still suspect it is because of bad SQL privileges,

you may send me a PM with super admin access to look at this

Hello

i have looked at it
Quering the INFORMATION_SCHEMA
does not work

Contact your webhost and ask them if the DB user that you are using has privileges to query the INFORMATION_SCHEMA

e.g. if you go to Joomla Database "Fix" it will always report "Update-to-date" without really being able to check if DB is update-to-date, (this can become a problem if some day you update Joomla manually or if Joomla update process is interrupted, in this case Database check will not be able to find the needed information)

Hello

I edited configuration.php of Joomla and use the other DB user you have sent me, still not working

But i found why it is not working,
- it was not about privileges of INFORMATION_SCHEMA

The database name has a prefix:

neys_sensorialite

But you in your Joomla configuration you have used DB name:
sensorialite

After using the full / proper Database name it is working !

Thank you ! Great job George !
My webhost uses a new procedure for the database names with a prefix choosed by it.
In the admin panel they say that this prefix is optional.
But in fact... We can see it is not !!!
On my other sites with the same webhost, I have not this new procedure, it's why it works !

Thanks a lot again.

For the information_schema, I forgot to give you access, sorry !
Infomaniak is a very good webhost. Limitations are very rare with a high level of security. It's why I was very surprised about the hypothesis of reduced privileges.

Hello

it would be good to tell your webhost that quering the
information_schema

only works with the fullname DB
so the should
- either fix it to work with the short DB name
- or to stop saying that it is compatible to use the short name
as it is NOT