Well, here's an update. It definitely does have to do with that error. I was able to log in to my server by turning auto create accounts back to TRUE and then made a brand new one (before I had been using already created accounts - which was the issue)... even if I had autocreate on FALSE
These accounts were also in my regular accounts table that I used for eqemulator host server... perhaps that was the issue???
Anyway, everything seems to work great now, except I still can't use my old accounts... No more red error messages when logging in ... I even changed the IP addresses to my actual computer's instead of 127.0.0.1 and was able to log in from another computer in the house (using the newly created account).
So, to Sum up... still a lingering issue of old accounts and that error... but there's a workaround now...
I did get some red error code the first time I created a character on the new account and logged in, but it hasn't returned upon logging in again multiple times and it doesn't seem to have affected anything, but if someone would let me know if it is a hidden issue / what the solution is, i'd appreciate it.
Code:
[World Server] Checking inbound connection x.x.x.x against BannedIPs table
[World Server] Connection x.x.x.x PASSED banned IPs check. Processing connection.
[World Server] Account Attempting to be created: 'xxxxxxx' status: 0
[Status] SoF Start zone query: SELECT x, y, z, heading, start_zone, bind_id FROM start_zones WHERE zone_id = 49 AND player_class = 15 AND player_deity = 211 AND player_race = 10
[Status] Found starting location in start_zones
[MySQL Error] 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
REPLACE INTO `character_bind` (id, zone_id, instance_id, x, y, z, heading, slot) VALUES (19661936, 19661900, 19660476, 0.000000, 0.000000, 0.000000, -2.000000, 1079274700), (0, 1079197696, 0, 0.000000, 0.000000, 0.000000, -2.000000, 1079274700),
Threaded Mode
