CustomBytes logo

img(770) 446-1533

Jan 25, 2020

Error

UPDATE `Profiles` SET NickName = :nickname WHERE ID = :id
Error in /admin/profiles.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘WeinsteinD200’ for key ‘NickName’
at
@ profiles.inc.php:202 — Db->ExecuteStatement(…)
@ profiles.php:133 — Profiles->UpdateValues(…)

Server Vars:Array
(
[SCRIPT_URL] => /admin/profiles.php
[SCRIPT_URI] => https://arabmatchmaking.com/admin/profiles.php
[HTTPS] => on
[SSL_TLS_SNI] => arabmatchmaking.com
[HTTP_HOST] => arabmatchmaking.com
[HTTP_CONNECTION] => Keep-Alive
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_CF_IPCOUNTRY] => EG
[HTTP_X_FORWARDED_FOR] => 197.62.148.233
[HTTP_CF_RAY] => 55a810b78ad06161-BCN
[CONTENT_LENGTH] => 523
[HTTP_X_FORWARDED_PROTO] => https
[HTTP_CF_VISITOR] => {“scheme”:”https”}
[HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 6.1; rv:72.0) Gecko/20100101 Firefox/72.0
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
[HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
[CONTENT_TYPE] => application/x-www-form-urlencoded
[HTTP_ORIGIN] => https://arabmatchmaking.com
[HTTP_REFERER] => https://arabmatchmaking.com/admin/profiles.php?search=WeinsteinD85&bigSearch=&searchBoxSelection=1&s_nickname=By+Nickname&p_per_page=200
[HTTP_UPGRADE_INSECURE_REQUESTS] => 1
[HTTP_COOKIE] => __cfduid=d0f93452cbd696422afca2c691d7f16be1578599083; _ga=GA1.2.1305011708.1578563090; _fbp=fb.1.1578563091151.1837619046; _gid=GA1.2.414153909.1579812861; __gads=ID=f7f999498f1f8f45:T=1579812859:S=ALNI_MZUMmSEOgqf8B9awE6yTqskCAgtHg; adminID=Naglaa.1G4; adminPassword=8KKTCUSYDf6r%2F5h8mWEHSg%3D%3D; adminSession=LOGGED+IN; PHPSESSID=vjt8ail4hu1qovkrgvv8hipmt2
[HTTP_CF_CONNECTING_IP] => 197.62.148.233
[HTTP_CDN_LOOP] => cloudflare
[PATH] => /sbin:/usr/sbin:/bin:/usr/bin
[SERVER_SIGNATURE] =>

Apache/2.2.15 (Red Hat) Server at arabmatchmaking.com Port 443

[SERVER_SOFTWARE] => Apache/2.2.15 (Red Hat)
[SERVER_NAME] => arabmatchmaking.com
[SERVER_ADDR] => 192.168.100.237
[SERVER_PORT] => 443
[REMOTE_ADDR] => 172.68.94.105
[DOCUMENT_ROOT] => /var/www/arabmatchmaking.com/httpdocs
[SERVER_ADMIN] => root@localhost
[SCRIPT_FILENAME] => /var/www/arabmatchmaking.com/httpdocs/admin/profiles.php
[REMOTE_PORT] => 58526
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => POST
[QUERY_STRING] => search=WeinsteinD85&searchBoxSelection=1&s_nickname=1&&p_per_page=200
[REQUEST_URI] => /admin/profiles.php?search=WeinsteinD85&searchBoxSelection=1&s_nickname=1&&p_per_page=200
[SCRIPT_NAME] => /admin/profiles.php
[PHP_SELF] => /admin/profiles.php
[REQUEST_TIME_FLOAT] => 1579932430.493
[REQUEST_TIME] => 1579932430
)