มาดูตัวอย่างข้อความแจ้งปัญหาแบบเต็มๆ กันก่อน
จะเห็นว่าปัญหาคล้ายๆ กับปัญหานี้exception 'JDatabaseExceptionExecuting' with message 'Duplicate entry 'admin' for key 'idx_username'' in /home/demo/domains/demo.com/public_html/libraries/joomla/database/driver/mysqli.php:668 Stack trace: #0 /home/demo/domains/demo.com/public_html/plugins/authentication/phpbb3_auth/phpbb3_auth.php(407): JDatabaseDriverMysqli->execute() #1 /home/demo/domains/demo.com/public_html/plugins/authentication/phpbb3_auth/phpbb3_auth.php(77): plgAuthenticationPHPBB3_Auth->addUserJoomla(Array, Array) #2 /home/demo/domains/demo.com/public_html/libraries/src/Authentication/Authentication.php(294): plgAuthenticationPHPBB3_Auth->onUserAuthenticate(Array, Array, Object(Joomla\CMS\Authentication\AuthenticationResponse)) #3 /home/demo/domains/demo.com/public_html/libraries/src/Application/CMSApplication.php(860): Joomla\CMS\Authentication\Authentication->authenticate(Array, Array) #4 /home/demo/domains/demo.com/public_html/libraries/src/Application/SiteApplication.php(727): Joomla\CMS\Application\CMSApplication->login(Array, Array) #5 /home/demo/domains/demo.com/public_html/components/com_users/controllers/user.php(112): Joomla\CMS\Application\SiteApplication->login(Array, Array) #6 /home/demo/domains/demo.com/public_html/libraries/src/MVC/Controller/BaseController.php(702): UsersControllerUser->login() #7 /home/demo/domains/demo.com/public_html/components/com_users/users.php(15): Joomla\CMS\MVC\Controller\BaseController->execute('login') #8 /home/demo/domains/demo.com/public_html/libraries/src/Component/ComponentHelper.php(402): require_once('/home/demo/domai...') #9 /home/demo/domains/demo.com/public_html/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent('/home/demo/domai...') #10 /home/demo/domains/demo.com/public_html/libraries/src/Application/SiteApplication.php(194): Joomla\CMS\Component\ComponentHelper::renderComponent('com_users') #11 /home/demo/domains/demo.com/public_html/libraries/src/Application/SiteApplication.php(233): Joomla\CMS\Application\SiteApplication->dispatch() #12 /home/demo/domains/demo.com/public_html/libraries/src/Application/CMSApplication.php(225): Joomla\CMS\Application\SiteApplication->doExecute() #13 /home/demo/domains/demo.com/public_html/index.php(49): Joomla\CMS\Application\CMSApplication->execute() #14 {main}
viewtopic.php?f=86&t=65952
แต่คนละเคสกันนะครับ ไม่สามารถแก้ตามกระทู้นั้นได้
ดูวิธีแก้ไข Post ล่างนี้ สามารถใช้งานได้