Faites une sauvegarde de vos tables de la base de données, puis il faut appliquer cette requête avec phpmyadmin :
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;
