Opened 5 years ago

Last modified 4 years ago

#887 accepted defect

Duplicate Entries in tblCallNewb - Bot Issue

Reported by: 24 Owned by: WingZero
Priority: normal Milestone: milestone:
Component: Bots - Other Version: Latest version from repository
Severity: minor Keywords:
Cc:

Description

For some reason there's duplicates in tblCallNewb and this JUST started happening after the creation of TW-WelcomeBot.

Here's the code to use in /pma to identify the duplicates.

SELECT CN.* FROM trench_TrenchWars.tblCallNewb AS CN
JOIN (SELECT fcUserName FROM trench_TrenchWars.tblCallNewb
GROUP BY fcUserName
HAVING COUNT(1) >= 2) AS CN1
WHERE CN.fcUserName = CN1.fcUserName
LIMIT 100

Please review and fix. I won't remove the duplicates until after the problem has been identified.

-24

Change History (2)

comment:1 Changed 5 years ago by WingZero

  • Owner set to WingZero
  • Status changed from new to accepted

comment:2 Changed 4 years ago by Trancid

Still valid?

Note: See TracTickets for help on using tickets.