[DiscordArchive] Hi guys, I'm getting this error in the authserver logs whenever someone tries to login with an incor
[DiscordArchive] Hi guys, I'm getting this error in the authserver logs whenever someone tries to login with an incor
Original source
Hi guys, I'm getting this error in the authserver logs whenever someone tries to login with an incorrect password and the system logs it to the logs_ip_actions table:
```SQL(p): INSERT INTO logs_ip_actions (account_id, character_guid, realm_id, type, ip, systemnote, unixtime, time) VALUES (2, 0, 'REMOVED IP ADDRESS', 1, 'Login to WoW Failed - Incorrect Password', 0, unix_timestamp(NOW()), NOW())
[ERROR]: [1265] Data truncated for column 'realm_id' at row 1
Unhandled MySQL errno 1265. Unexpected behaviour possible.```
When this happens the entry is not created in the database, any ideas?
rektbyfaith
04-22-2020, 08:08 AM #1Archived author: Deleted User • Posted: 2020-04-22T08:08:43.033000+00:00
Original source
Hi guys, I'm getting this error in the authserver logs whenever someone tries to login with an incorrect password and the system logs it to the logs_ip_actions table:
```SQL(p): INSERT INTO logs_ip_actions (account_id, character_guid, realm_id, type, ip, systemnote, unixtime, time) VALUES (2, 0, 'REMOVED IP ADDRESS', 1, 'Login to WoW Failed - Incorrect Password', 0, unix_timestamp(NOW()), NOW())
[ERROR]: [1265] Data truncated for column 'realm_id' at row 1
Unhandled MySQL errno 1265. Unexpected behaviour possible.```
When this happens the entry is not created in the database, any ideas?
Original source
seems like the query tries to insert the ip into the realm id collum
rektbyfaith
04-22-2020, 08:12 AM #2Archived author: Jinnai • Posted: 2020-04-22T08:12:35.313000+00:00
Original source
seems like the query tries to insert the ip into the realm id collum
Original source
create an issue on github for this please
rektbyfaith
04-22-2020, 08:12 AM #3Archived author: Jinnai • Posted: 2020-04-22T08:12:42.913000+00:00
Original source
create an issue on github for this please
Original source
Just to note, there is over 27,489 entries, could size of the DB be an issue? And will do
rektbyfaith
04-22-2020, 08:13 AM #4Archived author: Deleted User • Posted: 2020-04-22T08:13:08.005000+00:00
Original source
Just to note, there is over 27,489 entries, could size of the DB be an issue? And will do
Original source
> no
<@456226577798135808> Someone help me?
rektbyfaith
04-22-2020, 08:35 AM #5Archived author: Deleted User • Posted: 2020-04-22T08:35:28.118000+00:00
Original source
> no
<@456226577798135808> Someone help me?
Original source
ask in irc - this error shouldnt happen if you followed the wiki closely and your source is untouched
rektbyfaith
04-22-2020, 08:36 AM #6Archived author: Jinnai • Posted: 2020-04-22T08:36:25.162000+00:00
Original source
ask in irc - this error shouldnt happen if you followed the wiki closely and your source is untouched
1 Guest(s)
1 Guest(s)