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

micker wrote: ai ta base est peut être abimée ... fait une réparation / optimisation via php my admin (une simple recherche sur google te donnera la marche asuivre)

Bonjour,

Oui, j'ai trouvé, et j'ai essayé.
Résultat OK partout, sauf sur les 2 tables : va2rq_finder_tokens et va2rq_finder_tokens_aggregate, où j'ai le message : "The storage engine for the table doesn't support repair" (respectivement "The storage engine for the table doesn't support optimize").

Je ne sais pas si ça a à voir avec mon pb, toujours est-il qu'il est toujours là

Bonne nuit.
HervE

Hello

these tables are not FLEXIcontent tables
- but in any case FLEXIcontent will work only if site is transfered properly

the video that i posted is good knowledge, and it is not long,
- will be useful for you to know how to do it
and if you had used it initially it would have save you a lot of time

ggppdk wrote: - but in any case FLEXIcontent will work only if site is transfered properly

Hello,
Still wondering what I've done wrong in the transfer process... (if I ever did something wrong).

ggppdk wrote: the video that i posted is good knowledge, and it is not long,
- will be useful for you to know how to do it

Yes! I watched it yesterday. Very interesting indeed. I think I'll give it a try soon (even though I don't use cPanel hosting).

ggppdk wrote: and if you had used it initially it would have save you a lot of time

Maybe. But who could predict the troubles I would encounter?

Thanks again for your answers and advice!

Good night.
HervE

I did the whole thing again! (Not with Akeeba this time. So Akeeba is not the cause.)
First I removed all files and folders from my distant site.
From local site I zipped all files and folders, copied the zipfile to distant site, and unzipped it.
With phpMyAdmin, I exported database from localhost and imported it into distant site.
I made the appropriate modifications to configuration.php.

And... result is still the same! Have a look at it yourself:


What should I do now? I've got no idea anymore

HervE

Hello

- since INDEX exists you should not be asked to re-create it !!

so if you get this message then the DB was not restored as your local site

many column indexes are missing, something went wrong with the transfer, i suspect your remote MySql server is bogus or misconfigured

In fact i suspect that you do not have enough privileges on the MySql server

Just curious
also test this: go to Joomla Extensions
- Click Manage and then click DATABASE at LEFT column
Does it say that Joomla DB tables are update to date ?

ggppdk wrote: i suspect your remote MySql server is bogus or misconfigured
In fact i suspect that you do not have enough privileges on the MySql server

Thanks for your help again!
I also suspect a DB configuration issue, or a privilege issue at Free server...

Listen: When I use System > Global Configuration > Save, I got this:
An error has occurred.
1044 Access denied for user 'mywebsite'@'172.20.%' to database 'mywebsite' SQL=LOCK TABLES `va2rq_assets` WRITE
Call stack
# Function Location
1 JApplicationCms->execute() /var/www/sdb/n/n/mywebsite/administrator/index.php:47
2 JApplicationAdministrator->doExecute() /var/www/sdb/n/n/mywebsite/libraries/cms/application/cms.php:252
3 JApplicationAdministrator->dispatch() /var/www/sdb/n/n/mywebsite/libraries/cms/application/administrator.php:152
4 JComponentHelper::renderComponent() /var/www/sdb/n/n/mywebsite/libraries/cms/application/administrator.php:98
5 JComponentHelper::executeComponent() /var/www/sdb/n/n/mywebsite/libraries/cms/component/helper.php:372
6 require_once() /var/www/sdb/n/n/mywebsite/libraries/cms/component/helper.php:392
7 ConfigControllerApplicationSave->execute() /var/www/sdb/n/n/mywebsite/administrator/components/com_config/config.php:31
8 ConfigModelApplication->save() /var/www/sdb/n/n/mywebsite/administrator/components/com_config/controller/application/save.php:90
9 JTableNested->store() /var/www/sdb/n/n/mywebsite/administrator/components/com_config/model/application.php:145
10 JTable->_lock() /var/www/sdb/n/n/mywebsite/libraries/joomla/table/nested.php:848
11 JDatabaseDriverMysqli->lockTable() /var/www/sdb/n/n/mywebsite/libraries/joomla/table/table.php:1639
12 JDatabaseDriverMysqli->execute() /var/www/sdb/n/n/mywebsite/libraries/joomla/database/driver/mysqli.php:500

ggppdk wrote: also test this: go to Joomla Extensions
- Click Manage and then click DATABASE at LEFT column
Does it say that Joomla DB tables are update to date ?

Database table structure is up to date.
Other Information
Database schema version (in #__schemas): 3.4.0-2015-02-26.
Update version (in #__extensions): 3.4.4.
Database driver: mysqli.
79 database changes were checked successfully.
142 database changes did not alter table structure and were skipped.

What do you think of this?

HervE