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
Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php
Re: Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php
local:
appgini 5.95
win10
php 7.3
mariadb 10
server
ubuntu 20
mysql 8
php 8.1
appgini 5.95
win10
php 7.3
mariadb 10
server
ubuntu 20
mysql 8
php 8.1
- D Oliveira
- AppGini Super Hero
- Posts: 348
- Joined: 2018-03-04 09:30
- Location: David
Re: Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php
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
7.4 is currently the best (at least for me) even with 22.14, no errors what so ever.
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper
Re: Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php
Thank you Oliveira and Ahmed, I will share the result
Re: Uncaught mysqli_sql_exception: Duplicate key name 'name' in db.php
Case Solve
down grade to php 7.3 on server ubuntu
updtae to appgini 22.14
Thank you all once again
down grade to php 7.3 on server ubuntu
updtae to appgini 22.14
Thank you all once again