Help
REPORT

MySQL error when banning a user from more than one chat room.

STATUS

Fix completed

PRIORITY

Normal

User avatar
jaero
Customer
5 Posts

Tickets by User

Ticket By jaero 15 Nov 2011, 14:14

Description:
I can ban a user from one chat room. However, unless I ban them from the entirety of Arrowchat (I don't want to remove their ability to send whispers), I can not ban them from ALL chat rooms. I ban them from the first chat room and that works fine. If I do so in any other chat rooms, nothing happens, and the ban does not take effect. If I insert an entry into the MySQL database under the arrowchat_chatroom_banlist table, I get the following error: #1062 - Duplicate entry '165' for key 'PRIMARY'. 165 being their username, it's clear individual users can only be banned from one chat room. This is a HUGE flaw.

Component:
Chat Rooms

ArrowChat Version:
1.0.x
User avatar
Jason
Customer
2330 Posts

Ticket By Jason 19 Nov 2011, 18:34

Fixed in v1.5. You can change the structure of your database and remove the PRIMARY KEY for user ID to fix this issue now.

Status Change

Changed ticket status from "Fix in progress" to "Fix completed"
Action performed by Jason » 19 Nov 2011, 18:34

Status Change

Assigned ticket to group "ArrowChat Team"
Action performed by Jason » 19 Nov 2011, 18:34

Status Change

Changed ticket status from "New" to "Fix in progress"
Action performed by Jason » 15 Nov 2011, 23:51