Mail nouveau message

Plus d'informations
11 Juil 2023 22:05 - 16 Juil 2023 18:50 #1 par Dilan
Mail nouveau message a été créé par Dilan
Suite à un problème sur mon site (promotion-linares.fr), j'ai du remonter une sauvegarde.
Depuis, mes utilisateurs ne sont plus avertis par mail d'un nouveau message sur les sujets auxquels ils sont abonnés.
J'ai pourtant paramétré de la même façon que sur le site précédent avec cette fonctionnalité opérante.
Ci-après, ma configuration :
Ce message contient des informations confidentielles

Database collation check:
20230706j4_kunena_aliases have wrong collation of type utf8mb3_general_ci on field alias  
20230706j4_kunena_aliases have wrong collation of type utf8mb3_general_ci on field type  
20230706j4_kunena_aliases have wrong collation of type utf8mb3_general_ci on field item  20230706j4_kunena_announcement have wrong collation of type utf8mb3_general_ci on field title  20230706j4_kunena_announcement have wrong collation of type utf8mb3_general_ci on field sdescription  20230706j4_kunena_announcement have wrong collation of type utf8mb3_general_ci on field description  20230706j4_kunena_attachments have wrong collation of type utf8mb3_general_ci on field hash  20230706j4_kunena_attachments have wrong collation of type utf8mb3_general_ci on field folder  20230706j4_kunena_attachments have wrong collation of type utf8mb3_general_ci on field filename  20230706j4_kunena_attachments have wrong collation of type utf8mb3_general_ci on field filename_real  20230706j4_kunena_attachments have wrong collation of type utf8mb3_general_ci on field caption  20230706j4_kunena_categories have wrong collation of type utf8mb3_general_ci on field name  20230706j4_kunena_categories have wrong collation of type utf8mb3_general_ci on field alias  20230706j4_kunena_categories have wrong collation of type utf8mb3_general_ci on field icon  20230706j4_kunena_categories have wrong collation of type utf8mb3_general_ci on field accesstype  20230706j4_kunena_categories have wrong collation of type utf8mb3_general_ci on field channels  20230706j4_kunena_categories have wrong collation of type utf8mb3_general_ci on field description  20230706j4_kunena_categories have wrong collation of type utf8mb3_general_ci on field headerdesc  20230706j4_kunena_categories have wrong collation of type utf8mb3_general_ci on field topictemplate  20230706j4_kunena_categories have wrong collation of type utf8mb3_general_ci on field class_sfx  20230706j4_kunena_categories have wrong collation of type utf8mb3_general_ci on field iconset  20230706j4_kunena_categories have wrong collation of type utf8mb3_general_ci on field params  20230706j4_kunena_configuration have wrong collation of type utf8mb3_general_ci on field params  20230706j4_kunena_logs have wrong collation of type utf8mb3_general_ci on field ip  
20230706j4_kunena_logs have wrong collation of type utf8mb3_general_ci on field operation  20230706j4_kunena_messages have wrong collation of type utf8mb3_general_ci on field name  20230706j4_kunena_messages have wrong collation of type utf8mb3_general_ci on field email  20230706j4_kunena_messages have wrong collation of type utf8mb3_general_ci on field subject  20230706j4_kunena_messages have wrong collation of type utf8mb3_general_ci on field ip  20230706j4_kunena_messages have wrong collation of type utf8mb3_general_ci on field modified_reason  20230706j4_kunena_messages_text have wrong collation of type utf8mb3_general_ci on field message  20230706j4_kunena_polls have wrong collation of type utf8mb3_general_ci on field title  20230706j4_kunena_polls_options have wrong collation of type utf8mb3_general_ci on field text  20230706j4_kunena_sessions have wrong collation of type utf8mb3_general_ci on field allowed  20230706j4_kunena_sessions have wrong collation of type utf8mb3_general_ci on field readtopics  20230706j4_kunena_smileys have wrong collation of type utf8mb3_general_ci on field code  
20230706j4_kunena_smileys have wrong collation of type utf8mb3_general_ci on field location  20230706j4_kunena_smileys have wrong collation of type utf8mb3_general_ci on field greylocation  20230706j4_kunena_topics have wrong collation of type utf8mb3_general_ci on field subject  
20230706j4_kunena_topics have wrong collation of type utf8mb3_general_ci on field first_post_message  20230706j4_kunena_topics have wrong collation of type utf8mb3_general_ci on field first_post_guest_name  20230706j4_kunena_topics have wrong collation of type utf8mb3_general_ci on field last_post_message  20230706j4_kunena_topics have wrong collation of type utf8mb3_general_ci on field last_post_guest_name  20230706j4_kunena_topics have wrong collation of type utf8mb3_general_ci on field params  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field status_text  20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field view  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field signature  20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field avatar  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field personalText  20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field location  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field friendfeed  20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field bebo  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field digg  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field icq  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field telegram  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field vk  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field microsoft  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field skype  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field twitter  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field facebook  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field google  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field myspace  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field linkedin  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field linkedin_company  20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field delicious  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field instagram  20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field blogspot  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field flickr  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field apple  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field qzone  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field weibo  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field wechat  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field yim  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field whatsapp  20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field youtube  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field ok  
20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field websitename  20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field websiteurl  20230706j4_kunena_users have wrong collation of type utf8mb3_general_ci on field ip  20230706j4_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field ip  20230706j4_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field reason_private  20230706j4_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field reason_public  20230706j4_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field comments  20230706j4_kunena_users_banned have wrong collation of type utf8mb3_general_ci on field params  20230706j4_kunena_version have wrong collation of type utf8mb3_general_ci on field version  20230706j4_kunena_version have wrong collation of type utf8mb3_general_ci on field build  20230706j4_kunena_version have wrong collation of type utf8mb3_general_ci on field versionname  20230706j4_kunena_version have wrong collation of type utf8mb3_general_ci on field state  
        

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |
        

Ce message contient des informations confidentielles
htaccess: Exists | PHP environment: Max execution time: 50000 seconds | Max execution memory: -1 | Max file upload:  

Kunena menu details:

Attention : Spoiler !

Joomla default template details : cassiopeia_linares | author: Didier LANQUETOT | version: 1.0 | creationdate: Avril 2023

Kunena default template details : Aurelia | author: Kunena Team | version: 6.1.2 | creationdate: 2023-07-08

Kunena template params:

Attention : Spoiler !

Kunena version detailed: Kunena 6.1.2 | 2023-07-08 [ Git Repository ]
        | Kunena detailed configuration:

Attention : Spoiler !
| Kunena integration settings:
Attention : Spoiler !
| Joomla! detailed language files installed:
Attention : Spoiler !

Third-party components: None

Third-party SEF components: None

Plugins: None

Modules: None


Quelle erreur ai-je bien pu faire ?
Merci de votre aide
Dernière édition: 16 Juil 2023 18:50 par Dilan.

Veuillez vous connecter ou vous enregistrer pour rejoindre la conversation.

Plus d'informations
12 Juil 2023 18:35 - 12 Juil 2023 18:35 #2 par Dilan
Réponse de Dilan sur le sujet Mail nouveau message

J'ai solutionné le problème. C'était simplement une question de flux RSS mal paramétré.
Mais à quoi correspondent les erreurs (have wrong collation of type utf8mb3_general_ci) qui apparaissent dans mon CR de config ?
Comment y remédier et les corriger ?
Dernière édition: 12 Juil 2023 18:35 par Dilan.

Veuillez vous connecter ou vous enregistrer pour rejoindre la conversation.

Plus d'informations
13 Juil 2023 11:47 - 13 Juil 2023 11:47 #3 par failrOn
Réponse de failrOn sur le sujet Mail nouveau message
Bonjour,

Pour les erreurs "wrong collation of type utf8mb3_general_ci" c'est juste que Joomla ! par défaut depuis quelques versions définit les tables en utf8mb4_general_ci. Dans ce cas-là pour y remédier il faudrait corriger pour chaque table de Kunena et chaque colonne dans chaque table ce qui peut-être laborieux, avant faire une sauvegarde de ta base de données

Pour chaque table de Kunena :
Code:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Pour chaque colonne :
Code:
ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Pour plus d'informations voir: dba.stackexchange.com/questions/8239/how...utf8mb4-in-mysql-5-5

Pour soutenir le projet Kunena : soutenir via le système de sponsor de github
Dernière édition: 13 Juil 2023 11:47 par failrOn.
Les utilisateur(s) suivant ont remercié: Dilan

Veuillez vous connecter ou vous enregistrer pour rejoindre la conversation.

Plus d'informations
16 Juil 2023 18:49 #4 par Dilan
Réponse de Dilan sur le sujet Mail nouveau message
Merci pour l'information !
C'est effectivement un peu fastidieux de lancer toutes ces requêtes.
Si cela n'empêche pas  la base de fonctionner correctement, je vais laisser comme ça pour l'instant.
Je procèderai aux modifications quand j'aurai un peu plus de disponibilité pour le faire.
Encore merci pour ton aide.
 

Veuillez vous connecter ou vous enregistrer pour rejoindre la conversation.

Temps de génération de la page : 0.821 secondes
Propulsé par Kunena