lightphoenix2 / LPX

LPX for Rocket
5 stars 8 forks source link

I'm getting this error with current version of Unturned\Rocket\LPX ( #5

Closed odyss3y closed 8 years ago

odyss3y commented 8 years ago
[2/5/2016 9:43:51 PM] [Exception] LPX >> Exception in LPX: System.NullReferenceException: Object reference not set to an instance of an object
  at LIGHT.DatabaseManager.Cooldown (System.String group) [0x00000] in <filename unknown>:0 
[2/5/2016 9:43:51 PM] [Info] white
[2/5/2016 9:43:51 PM] [Exception] LPX >> Exception in LPX: System.NullReferenceException: Object reference not set to an instance of an object
  at LIGHT.DatabaseManager.Cooldown (System.String group) [0x00000] in <filename unknown>:0 

The 2nd line says "white" which is the assigned text color for that group.

lightphoenix2 commented 8 years ago

The 2nd line is just me testing colors =3

lightphoenix2 commented 8 years ago

But what leads to that error?

odyss3y commented 8 years ago

I used /god right after joining in an LPX group that had it enabled, but not with "admin".

odyss3y commented 8 years ago

Just tested some more. I readded myself to the group and it is working properly now. So it looks like the error might be related to error handling for commands I don't have permission to.

lightphoenix2 commented 8 years ago

Well, System.String group have a System.NullReferenceException. Means the values that was pass in to group was a null.

odyss3y commented 8 years ago

Hmm, well I was definitely in a group. I checked both tables in the database.

lightphoenix2 commented 8 years ago

Did you Refresh the Table or Reload your Connection to mySQL?

odyss3y commented 8 years ago

The table is unchanged other than the new column for steamname. I was getting this error after multiple resets of the server. No other errors about database connections from any of my DB driven plugins.

lightphoenix2 commented 8 years ago

How do you add yourself in to the Group?

odyss3y commented 8 years ago

I can't recreate the error anymore. I'm going to unpassword my server and see if additional players change anything.

odyss3y commented 8 years ago

lpx adduser odyss3y groupname ^ in console

lightphoenix2 commented 8 years ago

okay, Let me try =3

odyss3y commented 8 years ago

Looks like its something to do with escaped chars

2/5/2016 10:31:50 PM] [Exception] LPX >> Exception in LPX: MySql.Data.MySqlClient.MySqlException: 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 'm not Boat, I'm OJ' where `steamId` = '76561198081736584'' at line 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0 
  at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x00000] in <filename unknown>:0 
lightphoenix2 commented 8 years ago

MySQL is sensitive

lightphoenix2 commented 8 years ago

I have tested. I couldn't get that error.

lightphoenix2 commented 8 years ago

I will put it in the readme to not put spacing in their values.

odyss3y commented 8 years ago

There isnt a space in any of the group names. It has to do with the user's name having a single quote in it.

lightphoenix2 commented 8 years ago

So its the SteamName?

odyss3y commented 8 years ago

correct

lightphoenix2 commented 8 years ago

The Syntax use in the peoples steam names.

lightphoenix2 commented 8 years ago

Try the latest Version

odyss3y commented 8 years ago

This error is with the latest version:

[2/6/2016 10:13:56 AM] [Info] [Group] Obi Wan Kenobi [Constantine]: "/balance"
[2/6/2016 10:13:58 AM] [Error] color is not numeric.
[2/6/2016 10:13:58 AM] [Error] color.#ff66ff kit.rambo kit.sneakybastage kit.baller kit.runandgun kit.jason kit.prison balance buy cost deathmessage exchange exp.onkill.100 hitman.add hitman.check hitman.list 80 home jlm.extended jlm.group kit.survival kit.thehunter kits.* locate lpx lpx.autoremoveimmunity lpx.listpermission motd.default op p pay report reward rocket rules sell tpa.accept tpa.send warp warps is not numeric.
[2/6/2016 10:13:58 AM] [Info] superalex2013 [superalex2013] was shot in the torso by (Mace MF Windu) bobshabob132 [PepeTheMenace]!
odyss3y commented 8 years ago

I also think there is a problem with * in permissions. kits.* doesnt seem to work now.

lightphoenix2 commented 8 years ago

color.#ff66ff remove the #

odyss3y commented 8 years ago

newp

[2/7/2016 9:05:38 AM] [Info] [World] Ryle[ZIMBABWISM] [SorryNotSry <3]: "hey ody"
[2/7/2016 9:05:38 AM] [Error] color is not numeric.
[2/7/2016 9:05:38 AM] [Error] color.ff00ff exp.onkill.105 kit.heavygunner kit.police exp.onkill.104 kit.therioter kit.spraypray exp.onkill.103 kit.rambo kit.sneakybastage exp.onkill.102 kit.baller kit.runandgun exp.onkill.101 kit.jason kit.prison balance buy cost deathmessage exchange exp.onkill.100 hitman.add hitman.check hitman.list 80 home jlm.extended jlm.group kits kit.survival kit.thehunter locate lpx lpx.autoremoveimmunity lpx.listpermission motd.default op p pay report reward rocket rules sell tpa.accept tpa.send warp warps tpa is not numeric.
[2/7/2016 9:05:38 AM] [Info] Shadow (surferpug) [surferpug] was shot in the torso by SteelBeamsCantMeltJetFuel [Mr.PoopyButtHole]!
[2/7/2016 9:05:38 AM] [Info] [World] Shadow (surferpug) [surferpug]: "/wa"
odyss3y commented 8 years ago

i think it wants the cooldown parameter returned first

odyss3y commented 8 years ago

tried to be creative, didnt help

[2/7/2016 9:09:13 AM] [Info] [World] ShaolinChessMaster [ShaolinChessMaster]: "what are the kits"
[2/7/2016 9:09:15 AM] [Error] 0 color is not numeric.
[2/7/2016 9:09:15 AM] [Error] 0 color.ffccff exp.onkill.101 kit.jason kit.prison 0 balance buy cost deathmessage exchange exp.onkill.100 hitman.add hitman.check hitman.list 80 home jlm.extended jlm.group kits kit.survival kit.thehunter locate lpx lpx.autoremoveimmunity lpx.listpermission motd.default op p pay report reward rocket rules sell tpa.accept tpa.send warp warps tpa is not numeric.
[2/7/2016 9:09:15 AM] [Info] talon3903 [talon3903] was shot in the head by Shadow (surferpug) [surferpug]!
[2/7/2016 9:09:15 AM] [Info] [Area] sly1286 [sly1286]: "sup"
[2/7/2016 9:09:15 AM] [Info] [World] SteelBeamsCantMeltJetFuel [Mr.PoopyButtHole]: "/cost "blue bedroll""
[2/7/2016 9:09:18 AM] [Info] [World] Grassy [ANTI Doodel Bob]: "the id of the item"
odyss3y commented 8 years ago
[2/7/2016 9:20:24 AM] [Info] [World]  amiral jacky [tristansolermy]: "/tpa lordluke"
[2/7/2016 9:20:24 AM] [Exception] LPX >> Exception in LPX: System.NullReferenceException: Object reference not set to an instance of an object
  at LIGHT.DatabaseManager.Cooldown (System.String group) [0x00000] in <filename unknown>:0
[2/7/2016 9:20:24 AM] [Exception] LPX >> Exception in LPX: System.NullReferenceException: Object reference not set to an instance of an object
  at LIGHT.DatabaseManager.Cooldown (System.String group) [0x00000] in <filename unknown>:0
[2/7/2016 9:20:25 AM] [Info] [World] USRxMONSTERxDOG [USRxMONSTERxDOG]: "/buy alcepack"
[2/7/2016 9:20:34 AM] [Info] [World]  amiral jacky [tristansolermy]: "/tpa lordluke"
[2/7/2016 9:20:34 AM] [Exception] LPX >> Exception in LPX: System.NullReferenceException: Object reference not set to an instance of an object
  at LIGHT.DatabaseManager.Cooldown (System.String group) [0x00000] in <filename unknown>:0
[2/7/2016 9:20:34 AM] [Exception] LPX >> Exception in LPX: System.NullReferenceException: Object reference not set to an instance of an object
  at LIGHT.DatabaseManager.Cooldown (System.String group) [0x00000] in <filename unknown>:0
lightphoenix2 commented 8 years ago

Oh, people have been saying about the commands tpa. Let me try to see how to fix this