2. PHPRunner General questions
  3. [SOLVED]  Duplicate list after adding event "After Record Added"
This topic is locked
[SOLVED]

 Duplicate list after adding event "After Record Added"

 		3/31/2016 6:28:40 AM
PHPRunner General questions
B
 bree author

Dear All,
Could you guys have any clue about my problems?

i currently using PHPRUNNER 6.2

before i adding event "send email with new data" on event "After Record Added", everything looks good on the List Page, but after i adding the "Send Email with new data" on event "After Record Added" something wrong with the list page, the same record become appear on the list twice with the same ID (Primary Key).
Can you guys help me with this?
Thanks.
Juki.
Sergey Kornilov admin 3/31/2016

It's hard to imagine why would record duplicate after email being sent. There must be something else involved. Not possible to tell without seeing the application. I would suggest contacting support directly with this.
B
 		bree author 3/31/2016



It's hard to imagine why would record duplicate after email being sent. There must be something else involved. Not possible to tell without seeing the application. I would suggest contacting support directly with this.


Im not sure what was going on,

So i check my DB from the shell to mysql console, and there was exactly only 1 record with specified ID (Primary Key), then i try to check again the "SQL Query Design" from PHPRunner, im joining a table with "Match Only" -> "Match Only", the result query is 2 with the same identical record (i guess this is the cause of the problem), try to change it to "Left Outter Join" the problem still remain, change it "Right Outer Join" the problem still remain.

So i delete the Joined Table, and recreate Table Join with "Match Only-Match Only", the problem gone...the result query is correct. Im not sure that i already fix the problem, but since i regenerate the apps, the problem is fixed.
Btw, thanks to Admin for immediate concern.
Regards.

Juki