Cant change NULL in mysql help!

11/09/2013 13:51 zjamiee01#1
Hey guys,

so i ran in to a problem when i tried to edit a file (the wrong file)

[Only registered and activated users can see links. Click Here To Register...]

It need to be changed back to "NULL"

How do i fix this?
11/09/2013 13:53 Nezekan#2
just delete it?
11/09/2013 13:56 zjamiee01#3
Quote:
Originally Posted by Nezekan View Post
just delete it?
so i dont need it?
11/09/2013 14:59 Nezekan#4
Quote:
Originally Posted by zjamiee01 View Post
so i dont need it?
why would you need an empty account? also you're editing the wrong table, if you really don't know this stuff I suggest you don't open a server, even if it's just for friends, then you're better off with some emulator
11/09/2013 15:00 zikor1337#5
right click, execute and the row will disappear .

@And yea.. you are editing the wrong table . TB_User is the correct one . :facepalm:
11/09/2013 17:08 zjamiee01#6
Quote:
Originally Posted by Nezekan View Post
why would you need an empty account? also you're editing the wrong table, if you really don't know this stuff I suggest you don't open a server, even if it's just for friends, then you're better off with some emulator
Forgive me for learning!

got it figured out doh
11/11/2013 00:17 Nezekan#7
Quote:
Originally Posted by zjamiee01 View Post
Forgive me for learning!

got it figured out doh
I'm not blaming you for learning, I just saw the title of your vps management console "knightsroad online", the first thing that came to my mind was "nice, another crappy sro server" ;)

Learning = good
Milking random players = bad
11/11/2013 04:00 magicanoo#8
One more thing,the type of SQL db engine used in SRO is MSSQL not MySQL.

Just saying.
11/11/2013 10:55 zikor1337#9
In the picture you can clearly see MSSQL, he just misspelled .
11/11/2013 14:02 Nezekan#10
Quote:
Originally Posted by zikor1337 View Post
In the picture you can clearly see MSSQL, he just misspelled .
he's browsing the mysql manual though ;)
11/11/2013 19:17 zikor1337#11
Didn't see that . xD