Crazy Mike

Player nulled in mysql db

5 posts in this topic

had someone who managed to null themselves in the db and they dont really know how, and I've looked around on google and forums here for a way to delete the nulled row but so far nothings worked and the player always spawns in debug zone and doesnt save on logout

they are the bottom row

eeba8d0cd81ed73dc68baf3dcc81b9bd.png

tried whats below as most questions were answered with it but has no effect on table

DELETE FROM account WHERE name IS null;

Share this post


Link to post
Share on other sites

Does it look exactly like this? 

d180001e82.png

if so, it's because SQL Workbench is just telling you that you can click that to add a new line. It's not a null player. 

Share this post


Link to post
Share on other sites
Advertisement
19 minutes ago, WolfkillArcadia said:

Does it look exactly like this? 

d180001e82.png

if so, it's because SQL Workbench is just telling you that you can click that to add a new line. It's not a null player. 

then thats weird some guy who is joining always spawns in the debug zone, his player id isnt being added the the db aswell

Share this post


Link to post
Share on other sites

Check your server RPT see if anything stands out, Exile has a lot of error checks in place to check for null players. 

Also, I'd ask him for his client RPT after he joins your server. I bet something is wrong there. 

Share this post


Link to post
Share on other sites

I do have this error which is new to me spamming through the log

Spoiler

21:10:21 Server: Object 2:45446 not found (message Type_93)
21:10:21 Server: Object 2:45445 not found (message Type_93)
21:10:21 Server: Object 2:21533 not found (message Type_121)
21:10:21 Server: Object 2:6231 not found (message Type_121)
21:10:21 Server: Object info 2:24253 not found.
21:10:21 Can't change owner from 0 to 2

hit over 100k lines im thinking this may be unrelated but definitely a problem

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.