search

Taebu / prq

prq.co.kr
MIT License
1 stars 0 forks source link

Call 로그 작성시 500 Error page 수정요청 #54

Closed Taebu closed 8 years ago

Taebu commented 8 years ago

http://prq.co.kr/prq/ajax/set_cdr/

<!doctype html>
<html lang="en">
 <head>
  <meta charset="UTF-8">
  <meta name="Generator" content="EditPlus®">
  <meta name="Author" content="">
  <meta name="Keywords" content="">
  <meta name="Description" content="">
  <title>Document</title>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
 </head>
 <body>
 http://prq.co.kr/prq/ajax/set_cdr/?port=1&callerid=01050421183&userid=0319044084@naver.com&calledid=01020135535
  <form action=" http://prq.co.kr/prq/ajax/set_cdr/" method="POST">
  <input type="text" name="port" id="" value="1"/>
  <input type="text" name="callerid" id=""  value="01050421183"/>
  <input type="text" name="userid" id=""  value="0319044084@naver.com"/>
  <input type="text" name="calledid" id=""  value="01020135535"/>
  <input type="text" name="dumy" id=""  value="123434534asdfas"/>

<input type="submit" value="sdfsdf" />
  </form>
 </body>
</html>
Taebu commented 8 years ago 
use information_schema;

select * from KEY_COLUMN_USAGE order by CONSTRAINT_NAME;

alter table prq.prq_first_log drop index pf_hp_chk;
Query OK, 16757 rows affected (0.05 sec)
Records: 16757  Duplicates: 0  Warnings: 0

500에러 해결 unique key가 전역 디비에 영향을 미치는지 발견