search

Trench-Wars / twcore

Trench Wars bot project
5 stars 1 forks source link

Duplicate Entries in tblCallNewb - Bot Issue #37

Open connermcd opened 8 years ago

connermcd commented 8 years ago

Trac Ticket #887 accepted defect

Reported by: 24 Owned by: WingZero Component: Bots - Other Priority: normal Severity: minor

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

connermcd commented 8 years ago

WingZero changed owner to WingZero

connermcd commented 8 years ago

WingZero changed status from new to accepted

connermcd commented 8 years ago

Trancid> Still valid?