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

hervemlam
Topic Author
Offline
Elite Member

10 years 1 week ago - 9 years 1 week ago #59684 by hervemlam

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

Bonjour,

Je suis nouveau à la fois sur Joomla! et sur FLEXIcontent.
J'ai commencé par construire mon site en local, installé FLEXIcontent, m'en suis servi, impeccable.

Puis, de local, j'ai voulu passer en ligne. Pour cela j'ai utilisé l'extension Akeeba Backup.
Résultat : Mon site est bien visible, mais quand je vais sur le Panneau d'administration > Composants > FLEXIcontent, je ne peux plus voir tous les menus à gauche : sous "Edition de contenu", j'ai juste "Tableau de bord".

Dans la partie principale, je lis ceci :
FLEXIcontent Version
Erreur lors de connexion au serveur

Plus bas, sous "MAJ après installation", tout est coché vert sauf :
Créer les indexs de DB
# tables: 8 :
flexicontent_items_ext (2 indexes missing)
flexicontent_items_tmp (8 indexes missing)
flexicontent_fields_item_relations (2 indexes missing)
flexicontent_items_versions (2 indexes missing)
flexicontent_download_history (2 indexes missing)
flexicontent_download_coupons (4 indexes missing)
flexicontent_templates (1 indexes missing)
flexicontent_favourites (1 indexes missing)

Je clique donc sur MAJ, et là j'ai l'erreur suivante :
Duplicate key name 'lang_parent_id' SQL=ALTER TABLE `va2rq_flexicontent_items_ext` ADD INDEX lang_parent_id(`lang_parent_id`), ADD INDEX type_id(`type_id`)

Que dois-je faire ?

Bonne nuit.
HervE

PHP 8.1.16
Joomla! 4.3.3
FLEXIcontent 4.1.5

Last edit: 9 years 1 week ago by ggppdk.

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

10 years 1 week ago #59688 by micker

Replied by micker on topic Duplicate key name: Erreur à la restauration (avec Akeeba)

refais ta sauvegarde et ta migration à mon avis

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

hervemlam
Topic Author
Offline
Elite Member

10 years 1 week ago #59693 by hervemlam

Replied by hervemlam on topic Duplicate key name: Erreur à la restauration (avec Akeeba)

Merci pour ta réponse. Je vais recommencer sauvegarde+migration, et je te tiens au courant.

HervE

PHP 8.1.16
Joomla! 4.3.3
FLEXIcontent 4.1.5

Please Log in or Create an account to join the conversation.

hervemlam
Topic Author
Offline
Elite Member

10 years 1 week ago #59705 by hervemlam

Replied by hervemlam on topic Duplicate key name: Erreur à la restauration (avec Akeeba)

Pas de miracle : mêmes opérations, même résultat.

À quoi cela peut-il être dû ?

HervE

PHP 8.1.16
Joomla! 4.3.3
FLEXIcontent 4.1.5

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

10 years 1 week ago #59706 by micker

Replied by micker on topic Duplicate key name: Erreur à la restauration (avec Akeeba)

a mon avis ta sauvegarde akeeba est erroné
fait le tout a la mains export / import de bdd, upload de fichier, modification du configuration.php

Please Log in or Create an account to join the conversation.

hervemlam
Topic Author
Offline
Elite Member

10 years 6 days ago - 10 years 6 days ago #59725 by hervemlam

Replied by hervemlam on topic Duplicate key name: Erreur à la restauration (avec Akeeba)

micker wrote: a mon avis ta sauvegarde akeeba est erroné

Possible.
Aussi, pour arriver à mes fins, j'ai dû utiliser différentes versions de PHP entre mon site en local (qui doit être une 5.3), et les étapes Akeeba sur le site en ligne : la restauration (PHP 5.1) et l'installation (PHP 5.6.8 ). Est-ce que ça peut être la raison ?

micker wrote: fait le tout a la mains export / import de bdd, upload de fichier, modification du configuration.php

Je suis pas sûr de savoir faire. Je suis nouveau, je te rappelle.
Du reste, est-il nécessaire de tout refaire ? Vu qu'il s'agit d'une pb d'index, peut-être que l'export-import de la Base de Données suffirait ?

HervE

PHP 8.1.16
Joomla! 4.3.3
FLEXIcontent 4.1.5

Last edit: 10 years 6 days ago by hervemlam.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

10 years 6 days ago #59732 by ggppdk

Replied by ggppdk on topic Duplicate key name: Erreur à la restauration (avec Akeeba)

Hello

either the site was not transferred fully or your server software version are the issue of this

what do you mean PHP 5.1 ??

Joomla and FLEXIcontent requires PHP 5.3+

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

hervemlam
Topic Author
Offline
Elite Member

10 years 6 days ago - 10 years 6 days ago #59735 by hervemlam

Replied by hervemlam on topic Duplicate key name: Erreur à la restauration (avec Akeeba)

Hello and thanks for your answer.

ggppdk wrote: either the site was not transferred fully or your server software version are the issue of this

I guess so.
Yet the result of Akeeba Backup exportation says it's OK.

ggppdk wrote: what do you mean PHP 5.1 ??
Joomla and FLEXIcontent requires PHP 5.3+

I know. I managed to upgrade the storage space (given by my ISP) to PHP 5.6.8.
Unfortunately, the first steps of Akeeba Backup restoration (kickstart.php) didn't work with PHP 5.6.8 for some reason.
So I switched back to PHP 5.1.3, ran the first steps (mainly copying the files).
Then when coming to the next steps (installation, database and so), I had to upgrade to PHP 5.6.8 again!
Do you think it could be the reason?

By the way, observing the Akeeba configuration inside Joomla, I notice that the checkbox "Skip indexation" at the database section, is checked by default!
Maybe I could try to export/import the database again (only the database) with this option unchecked.
Your opinion?

Good night.
HervE

PHP 8.1.16
Joomla! 4.3.3
FLEXIcontent 4.1.5

Last edit: 10 years 6 days ago by hervemlam.

Please Log in or Create an account to join the conversation.