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

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

re essai une mise jour de joomla et de flexi

Bonjour,

Tu es sur quel type d'hébergement
Gratuit ou Payant ?
Si c'est du gratuit, il se pourrait que tu soit limité.

Cordialement,