Page 1 of 1

Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php

Posted: 2022-08-19 16:38
by dilitimor
I was deploying app on server. It was running well on the local
But I got error on page
This page isn’t working
103.97.101.142 is currently unable to handle this request.
HTTP ERROR 500

tail on error log
[Fri Aug 19 12:32:48.811469 2022] [php:error] [pid 23119] [client 10.1.1.1:43428] PHP Fatal error: Uncaught mysqli_sql_exception: Duplicate key name 'name' in /var/www/html/kibas/db.php:109\nStack trace:\n#0 /var/www/html/kibas/db.php(109): mysqli_query()\n#1 /var/www/html/kibas/admin/incFunctions.php(416): db_query()\n#2 /var/www/html/kibas/admin/incFunctions.php(1077): sql()\n#3 /var/www/html/kibas/admin/incFunctions.php(833): update_membership_groups()\n#4 /var/www/html/kibas/lib.php(66): setupMembership()\n#5 /var/www/html/kibas/index.php(4): include_once('...')\n#6 {main}\n thrown in /var/www/html/kibas/db.php on line 109, referer: http://103.97.101.142/kibas/

I need help to solve this problem
Thank you in advance

Re: Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php

Posted: 2022-08-19 16:39
by dilitimor
local:
appgini 5.95
win10
php 7.3
mariadb 10

server
ubuntu 20
mysql 8
php 8.1

Re: Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php

Posted: 2022-08-19 17:37
by D Oliveira
PHP 8.1 will throw so many errors for older appgini versions, change php version to 7.x on cpanel or update your app to 22.14

Re: Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php

Posted: 2022-08-19 19:31
by AhmedBR
7.4 is currently the best (at least for me) even with 22.14, no errors what so ever.

Re: Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php

Posted: 2022-08-19 23:07
by dilitimor
Thank you Oliveira and Ahmed, I will share the result

Re: Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php

Posted: 2022-08-20 02:04
by dilitimor
Case Solve
down grade to php 7.3 on server ubuntu
updtae to appgini 22.14

Thank you all once again