Ulysses Stuff > Releases
UBan -- Global ban system. Ban users from all servers connected to a single DB!
p1cwh0r3:
Long story short: UBan failure. Error is: autorun/server/uban.lua:140: Column 'serverip' cannot be null
Config has all the information in it and yet it is still giving this error. I myself am starting off with MySQL I'm not asking for help with that.. just an idea as to why it is producing this error? Configs are set as required.
Taken everything step by step... ???
More than likely though I've tripped while taking a step I suppose...
Megiddo:
You're probably using UBan and the DB on the same server (local), which errors out. I fixed this a while ago and pushed it to a beta tester for "quick verification" that it was bug free... but he's been beta testing it for about a year now so I guess it's about time I just go ahead and release it... I'll try to release the new one the end of this week.
trab:
Actually the SQL database is on another machine with a different IP to all the game servers.
I am a SQL newbie, but a few things that I have noticed in the database setup that (while making a mockup on my own machine) you noted in the first post:
1. If you have not specified NOT NULL I assume NULL?
2. When using phpMyAdmin and specifying an INT the length defaults to 10 this should be longer right? as an IP could potentially have 15 digits inclusive (decimal).
3. the 'id' has been specified with PRIMARY KEY and UNIQUE which are basically the same thing right?
phpMYAdmin message: The following indexes appear to be equal and one of them should be removed: PRIMARY, id
or am I just doing something wrong there?
Thanks for your time,
trab - ICannt.org Senior Admin
JamminR:
--- Quote from: trab on January 29, 2008, 09:53:32 AM ---2. When using phpMyAdmin and specifying an INT the length defaults to 10 this should be longer right? as an IP could potentially have 15 digits inclusive (decimal).
--- End quote ---
It's not an IP, its a 10 digit number representing the IP or steamid.
http://garrysmod.com/wiki/?title=Player.UniqueID (I think)
As for other questions, well, I don't know (though I should learn) SQL.
Megiddo:
--- Quote from: trab on January 29, 2008, 09:53:32 AM ---Actually the SQL database is on another machine with a different IP to all the game servers.
I am a SQL newbie, but a few things that I have noticed in the database setup that (while making a mockup on my own machine) you noted in the first post:
1. If you have not specified NOT NULL I assume NULL?
--- End quote ---
If NOT NULL isn't there it means the value *could* be null.
--- Quote from: trab on January 29, 2008, 09:53:32 AM ---2. When using phpMyAdmin and specifying an INT the length defaults to 10 this should be longer right? as an IP could potentially have 15 digits inclusive (decimal).
--- End quote ---
NO! No one seems to understand that xxx.xxx.xxx.xxx is NOT how a computer sees an IP. An integer is the correct representation and takes up 4 bytes instead of 15.
--- Quote from: trab on January 29, 2008, 09:53:32 AM ---3. the 'id' has been specified with PRIMARY KEY and UNIQUE which are basically the same thing right?
phpMYAdmin message: The following indexes appear to be equal and one of them should be removed: PRIMARY, id
or am I just doing something wrong there?
--- End quote ---
Primary key implies unique but there's no harm in specifying it anyways.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version