Hello Luzarius, I would highly recommend e-mailing Dylan@justin.tv or Russell@justin.tv for direct help. I spoke with Dylan just now and he says he'll help you out if your viewers submit the following information. The admin team is well aware of this issue, so don't worry.
Your viewers should send this info: Username, channel in which they were affected (yours), & their IPs (use www.whatismyip.com).
Can you just go into your database and purge all banned users with my channel ID?
In the database you shouldn't allow the same user to be in the ban table twice. You can solve this by staying true to primary & foreign keys. If your DB was designed properly this wouldn't of happened in the first place.
If you want me to just login to your server and fix it real quick let me know.
MYSQL or MSSQL?
PK - Increment order auto FK - User ID IP Address
Right?
Actually maybe we can fix this without touching the DB.
Just make it so when I do /unban username it goes through the DB and removes every user id FK in the ban table. This code must be broken somehow.
Comments
Does anyone have a better solution? There are at least 20-30 people who are perma banned from my channel even though I unbanned them.
Your viewers should send this info: Username, channel in which they were affected (yours), & their IPs (use www.whatismyip.com).
Good luck!
Can you just go into your database and purge all banned users with my channel ID?
In the database you shouldn't allow the same user to be in the ban table twice. You can solve this by staying true to primary & foreign keys. If your DB was designed properly this wouldn't of happened in the first place.
If you want me to just login to your server and fix it real quick let me know.
MYSQL or MSSQL?
PK - Increment order auto
FK - User ID
IP Address
Right?
Actually maybe we can fix this without touching the DB.
Just make it so when I do /unban username it goes through the DB and removes every user id FK in the ban table. This code must be broken somehow.
I emailed both russel & dylan, just waiting on a response. I understand they are busy.