Kunena 7.0.2 Released
The Kunena team has announce the arrival of Kunena 7.0.2 [K 7.0.2] in stable which is now available for download as a native Joomla extension for J! 5.3.x/5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0
Les sujets sont déplacés dans ce domaine ne sont fermés parce qu'ils se rapportent à des versions non prises en charge de Kunena.
Question Error 1054 Unknown column 'socials' in 'field list'
1 month 2 weeks ago - 1 month 2 weeks ago #234482
by xillibit
I don't provide support by PM, because this can be useful for someone else.
Replied by xillibit on topic Error 1054 Unknown column 'socials' in 'field list'
Il faudrait créer la colonne manquante (socials) mais ça ne suffira pas car toutes les valeurs dans les colonnes (github, microsoft, X, instagram...) ne seront pas reprises. Donc je suis en train d'ajouter une fonctionnalité qui sera disponible sous Outils qui reprend ce qui est conçu pour faire la mise à jour des réseaux sociaux, ne l'améliorant un peu. Cela devrait être disponible dans une future version (7.0.2).
I don't provide support by PM, because this can be useful for someone else.
Last edit: 1 month 2 weeks ago by xillibit.
Please Log in or Create an account to join the conversation.
1 month 2 weeks ago #234484
by lr8607
Replied by lr8607 on topic Error 1054 Unknown column 'socials' in 'field list'
Merci xillibit pour votre réponse.
Dans l'attente d'une version 7.0.2, il n'y a donc pas de solution de contournement pour faire fonctionner le forum ?
Dans l'attente d'une version 7.0.2, il n'y a donc pas de solution de contournement pour faire fonctionner le forum ?
Please Log in or Create an account to join the conversation.
1 month 2 weeks ago #234487
by xillibit
I don't provide support by PM, because this can be useful for someone else.
Replied by xillibit on topic Error 1054 Unknown column 'socials' in 'field list'
Bonjour,
Vous pouvez appliquer cette requête qui va faire disparaitre l'erreur, les utilisateurs n'auront pas les données qu'ils avaient avant concernant instagram, github, microsoft, facebook... dans leur profil :
Puis il faut appliquer ensuite celle-ci :
Vous pouvez appliquer cette requête qui va faire disparaitre l'erreur, les utilisateurs n'auront pas les données qu'ils avaient avant concernant instagram, github, microsoft, facebook... dans leur profil :
Code:
ALTER TABLE `#__kunena_users` ADD `socials` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `ip`;
Puis il faut appliquer ensuite celle-ci :
Code:
UPDATE `#__kunena_users` SET `socials` = '{
"x_social": {
"value": "",
"url": "https://x.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_X_SOCIAL",
"nourl": 0,
"fa": "fa-brands fa-x-twitter"
},
"facebook": {
"value": "",
"url": "https://www.facebook.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_FACEBOOK",
"nourl": 0,
"fa": "fa-brands fa-facebook"
},
"myspace": {
"value": "",
"url": "https://www.myspace.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_MYSPACE",
"nourl": 0,
"fa": "fa-solid fa-square-share-nodes"
},
"linkedin": {
"value": "",
"url": "https://www.linkedin.com/in/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_LINKEDIN",
"nourl": 0,
"fa": "fa-brands fa-linkedin"
},
"linkedin_company": {
"value": "",
"url": "https://www.linkedin.com/company/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_LINKEDIN",
"nourl": 0,
"fa": "fa-brands fa-linkedin"
},
"digg": {
"value": "",
"url": "https://www.digg.com/users/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_DIGG",
"nourl": 0,
"fa": "fa-brands fa-digg"
},
"skype": {
"value": "",
"url": "skype:##VALUE##",
"title": "COM_KUNENA_MYPROFILE_SKYPE",
"nourl": 0,
"fa": "fa-brands fa-skype"
},
"yim": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_YIM",
"nourl": 1,
"fa": "fa-brands fa-yahoo"
},
"google": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_GOOGLE",
"nourl": 1,
"fa": "fa-brands fa-google"
},
"github": {
"value": "",
"url": "https://www.github.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_GITHUB",
"nourl": 0,
"fa": "fa-brands fa-github"
},
"microsoft": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_MICROSOFT",
"nourl": 1,
"fa": "fa-brands fa-microsoft"
},
"blogspot": {
"value": "",
"url": "https://##VALUE##.blogspot.com/",
"title": "COM_KUNENA_MYPROFILE_BLOGSPOT",
"nourl": 0,
"fa": "fa-solid fa-square-share-nodes"
},
"flickr": {
"value": "",
"url": "https://www.flickr.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_FLICKR",
"nourl": 0,
"fa": "fa-brands fa-flickr"
},
"instagram": {
"value": "",
"url": "https://www.instagram.com/##VALUE##/",
"title": "COM_KUNENA_MYPROFILE_INSTAGRAM",
"nourl": 0,
"fa": "fa-brands fa-instagram"
},
"qqsocial": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_QQSOCIAL",
"nourl": 1,
"fa": "fa-solid fa-square-share-nodes"
},
"qzone": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_QZONE",
"nourl": 1,
"fa": "fa-solid fa-square-share-nodes"
},
"weibo": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_WEIBO",
"nourl": 1,
"fa": "fa-brands fa-weibo"
},
"wechat": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_WECHAT",
"nourl": 1,
"fa": "fa-solid fa-square-share-nodes"
},
"vk": {
"value": "",
"url": "https://vk.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_VK",
"nourl": 0,
"fa": "fa-brands fa-vk"
},
"telegram": {
"value": "",
"url": "https://t.me/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_TELEGRAM",
"nourl": 0,
"fa": "fa-brands fa-telegram"
},
"apple": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_APPLE",
"nourl": 1,
"fa": "fa-brands fa-apple"
},
"vimeo": {
"value": "",
"url": "https://vimeo.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_VIMEO",
"nourl": 0,
"fa": "fa-brands fa-vimeo"
},
"whatsapp": {
"value": "",
"url": "https://wa.me/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_WHATSAPP",
"nourl": 0,
"fa": "fa-brands fa-whatsapp"
},
"youtube": {
"value": "",
"url": "https://www.youtube.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_YOUTUBE",
"nourl": 0,
"fa": "fa-brands fa-youtube"
},
"ok": {
"value": "",
"url": "https://ok.ru/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_OK",
"nourl": 0,
"fa": "fa-solid fa-square-share-nodes"
},
"pinterest": {
"value": "",
"url": "https://pinterest.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_PINTEREST",
"nourl": 0,
"fa": "fa-brands fa-pinterest"
},
"reddit": {
"value": "",
"url": "https://www.reddit.com/user/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_REDDIT",
"nourl": 0,
"fa": "fa-brands fa-reddit"
},
"bluesky_app": {
"value": "",
"url": "https://bsky.app/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_BLUESKY_APP",
"nourl": 0,
"fa": "fa-brands fa-bluesky"
},
"threads": {
"value": "",
"url": "https://www.threads.net/@##VALUE##",
"title": "COM_KUNENA_MYPROFILE_THREADS_APP",
"nourl": 0,
"fa": "fa-brands fa-threads"
}
}' WHERE socials IS NULL;
I don't provide support by PM, because this can be useful for someone else.
Please Log in or Create an account to join the conversation.
1 month 2 weeks ago #234489
by lr8607
Replied by lr8607 on topic Error 1054 Unknown column 'socials' in 'field list'
La 1ère requête fonctionne en créant la colonne socials.
La 2ème requête ne se lance pas avec ce code erreur sous phpmyadmin :
Je vous joint la requête dans le fichier car j'ai l'impression que le forum traduit en français certains éléments de la requête, comme "creuser" pour "digg".
La 2ème requête ne se lance pas avec ce code erreur sous phpmyadmin :
- Caractère inattendu. (near "{" at position 60)
Je vous joint la requête dans le fichier car j'ai l'impression que le forum traduit en français certains éléments de la requête, comme "creuser" pour "digg".
Please Log in or Create an account to join the conversation.
1 month 2 weeks ago - 1 month 2 weeks ago #234490
by xillibit
I don't provide support by PM, because this can be useful for someone else.
Replied by xillibit on topic Error 1054 Unknown column 'socials' in 'field list'
Je viens de rééssayer sur phpmyadmin avec MariaDB 11.6.2 c'est bien passé sans erreur :
Code:
UPDATE `afwe2_kunena_users` SET `socials` = '{
"x_social": {
"value": "",
"url": "https://x.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_X_SOCIAL",
"nourl": 0,
"fa": "fa-brands fa-x-twitter"
},
"facebook": {
"value": "",
"url": "https://www.facebook.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_FACEBOOK",
"nourl": 0,
"fa": "fa-brands fa-facebook"
},
"myspace": {
"value": "",
"url": "https://www.myspace.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_MYSPACE",
"nourl": 0,
"fa": "fa-solid fa-square-share-nodes"
},
"linkedin": {
"value": "",
"url": "https://www.linkedin.com/in/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_LINKEDIN",
"nourl": 0,
"fa": "fa-brands fa-linkedin"
},
"linkedin_company": {
"value": "",
"url": "https://www.linkedin.com/company/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_LINKEDIN",
"nourl": 0,
"fa": "fa-brands fa-linkedin"
},
"digg": {
"value": "",
"url": "https://www.digg.com/users/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_DIGG",
"nourl": 0,
"fa": "fa-brands fa-digg"
},
"skype": {
"value": "",
"url": "skype:##VALUE##",
"title": "COM_KUNENA_MYPROFILE_SKYPE",
"nourl": 0,
"fa": "fa-brands fa-skype"
},
"yim": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_YIM",
"nourl": 1,
"fa": "fa-brands fa-yahoo"
},
"google": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_GOOGLE",
"nourl": 1,
"fa": "fa-brands fa-google"
},
"github": {
"value": "",
"url": "https://www.github.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_GITHUB",
"nourl": 0,
"fa": "fa-brands fa-github"
},
"microsoft": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_MICROSOFT",
"nourl": 1,
"fa": "fa-brands fa-microsoft"
},
"blogspot": {
"value": "",
"url": "https://##VALUE##.blogspot.com/",
"title": "COM_KUNENA_MYPROFILE_BLOGSPOT",
"nourl": 0,
"fa": "fa-solid fa-square-share-nodes"
},
"flickr": {
"value": "",
"url": "https://www.flickr.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_FLICKR",
"nourl": 0,
"fa": "fa-brands fa-flickr"
},
"instagram": {
"value": "",
"url": "https://www.instagram.com/##VALUE##/",
"title": "COM_KUNENA_MYPROFILE_INSTAGRAM",
"nourl": 0,
"fa": "fa-brands fa-instagram"
},
"qqsocial": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_QQSOCIAL",
"nourl": 1,
"fa": "fa-solid fa-square-share-nodes"
},
"qzone": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_QZONE",
"nourl": 1,
"fa": "fa-solid fa-square-share-nodes"
},
"weibo": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_WEIBO",
"nourl": 1,
"fa": "fa-brands fa-weibo"
},
"wechat": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_WECHAT",
"nourl": 1,
"fa": "fa-solid fa-square-share-nodes"
},
"vk": {
"value": "",
"url": "https://vk.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_VK",
"nourl": 0,
"fa": "fa-brands fa-vk"
},
"telegram": {
"value": "",
"url": "https://t.me/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_TELEGRAM",
"nourl": 0,
"fa": "fa-brands fa-telegram"
},
"apple": {
"value": "",
"url": "##VALUE##",
"title": "COM_KUNENA_MYPROFILE_APPLE",
"nourl": 1,
"fa": "fa-brands fa-apple"
},
"vimeo": {
"value": "",
"url": "https://vimeo.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_VIMEO",
"nourl": 0,
"fa": "fa-brands fa-vimeo"
},
"whatsapp": {
"value": "",
"url": "https://wa.me/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_WHATSAPP",
"nourl": 0,
"fa": "fa-brands fa-whatsapp"
},
"youtube": {
"value": "",
"url": "https://www.youtube.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_YOUTUBE",
"nourl": 0,
"fa": "fa-brands fa-youtube"
},
"ok": {
"value": "",
"url": "https://ok.ru/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_OK",
"nourl": 0,
"fa": "fa-solid fa-square-share-nodes"
},
"pinterest": {
"value": "",
"url": "https://pinterest.com/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_PINTEREST",
"nourl": 0,
"fa": "fa-brands fa-pinterest"
},
"reddit": {
"value": "",
"url": "https://www.reddit.com/user/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_REDDIT",
"nourl": 0,
"fa": "fa-brands fa-reddit"
},
"bluesky_app": {
"value": "",
"url": "https://bsky.app/##VALUE##",
"title": "COM_KUNENA_MYPROFILE_BLUESKY_APP",
"nourl": 0,
"fa": "fa-brands fa-bluesky"
},
"threads": {
"value": "",
"url": "https://www.threads.net/@##VALUE##",
"title": "COM_KUNENA_MYPROFILE_THREADS_APP",
"nourl": 0,
"fa": "fa-brands fa-threads"
}
}' WHERE socials IS NULL;
I don't provide support by PM, because this can be useful for someone else.
Last edit: 1 month 2 weeks ago by xillibit.
Please Log in or Create an account to join the conversation.
1 month 2 weeks ago #234494
by lr8607
Replied by lr8607 on topic Error 1054 Unknown column 'socials' in 'field list'
Je suis en MySQL 8 et l'hébergeur ne propose que cela...
Je vais essayer de revoir la requête demain.
Je vais essayer de revoir la requête demain.
Please Log in or Create an account to join the conversation.
Time to create page: 0.629 seconds