Vengadorweb

now i have the following error all i did was to reload the plugin MySql handle raised an exception (MySqlException: Duplicate column name 'clans') at MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery (System.IAsyncResult asyncResult) [0x00022] in :0 at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery(System.IAsyncResult) at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x000f2] in :0 MySql handle raised an exception (MySqlException: Duplicate column name 'clans') at MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery (System.IAsyncResult asyncResult) [0x00022] in :0 at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery(System.IAsyncResult) at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x000f2] in :0 Perhaps is trying to recreate the table instead of using the existing table?

Oh i found why is displaying the wrong data! Is reading the data from /data folder instead the data from the database! I certainly don't know why.

Another related issue, i'm playing around meanwhile you see my post, and i changed my statics like this: "Statistics Settings": { "Kills": true, "Gather": false, "Loot": false, "Entities": false, "Craft": false }, And when i reloaded the plugin, now it shows wrong data, like for example, a user that in my databse says that has 27 kills, now in the UI says that has only 6 kills. What i could be doing wrong?

Here are the stats of the user that i think "broke" the scale { "Display Name": "Tincho", "Steam ID": "xxxxxxx", "Last Login": "2022-11-01T01:37:30.729248-03:00", "Friendly Fire": false, "Ally Friendly Fire": false, "Use Clan Skins": true, "Stats": { "gears": 494.0, "electric.audioalarm": 2.0, "sheetmetal": 219.0, "scrap": 104511.0, "flashlight.held": 3.0, "metal.refined": 26264.0, "stonehatchet": 5.0, "burlap.gloves.new": 3.0, "sulfur.ore": 2225896.0, "metal.fragments": 5098673.0, "stone.pickaxe": 5.0, "hatchet": 10.0, "tool.binoculars": 2.0, "gunpowder": 284857.0, "box.wooden": 13.0, "lock.code": 76.0, "arrow.bone": 37.0, "arrow.fire": 86.0, "lowgradefuel": 209071.0, "hat.miner": 6.0, "spear.wooden": 7.0, "box.wooden.large": 51.0, "skull.human": 1.0, "halloween.lootbag.small": 2.0, "metal.ore": 8942067.0, "stones": 11408471.0, "hq.metal.ore": 1278.0, "crossbow": 4.0, "hat.candle": 5.0, "door.hinged.metal": 18.0, "workbench1": 2.0, "wall.frame.shopfront.metal": 5.0, "salvaged.sword": 8.0, "cloth": 588793.0, "cactusflesh": 111.0, "kills": 27.0, "pistol.revolver": 5.0, "ammo.pistol": 11750.0, "rope": 789.0, "pickaxe": 2.0, "wolfmeat.raw": 5.0, "waterjug": 1.0, "wall.graveyard.fence": 2.0, "arrow.wooden": 37.0, "bone.fragments": 3714.0, "fat.animal": 3274.0, "leather": 197346.0, "wood": 13327188.0, "hammer": 24.0, "building.planner": 17.0, "cupboard.tool": 10.0, "door.double.hinged.metal": 6.0, "furnace": 20.0, "bbq": 1.0, "bandage": 186.0, "pumpkin": 293.0, "seed.pumpkin": 5.0, "scientistnpc_oilrig": 73.0, "metalspring": 424.0, "ammo.rifle": 10438.0, "metalpipe": 2250.0, "roadsigns": 526.0, "hazmatsuit_scientist": 13.0, "grenade.molotov": 3.0, "smallwaterbottle": 6.0, "semibody": 284.0, "shotgun.double": 8.0, "fuse": 77.0, "barrel": 17.0, "can.tuna": 2.0, "smgbody": 314.0, "ammo.shotgun": 301.0, "hazmatsuit": 23.0, "wall.frame.fence.gate": 1.0, "diving.mask": 5.0, "electrical.memorycell": 2.0, "fluid.switch": 1.0, "guntrap": 3.0, "hammer.salvaged": 2.0, "riflebody": 678.0, "largemedkit": 18.0, "target.reactive": 1.0, "ceilinglight": 1.0, "npc_underwaterdweller": 3.0, "sewingkit": 836.0, "explosive.satchel": 151.0, "propanetank": 147.0, "heavy.plate.jacket": 12.0, "syringe.medical": 1246.0, "metalblade": 488.0, "techparts": 3564.0, "cctv.camera": 43.0, "wall.frame.cell": 1.0, "planter.large": 2.0, "targeting.computer": 80.0, "searchlight": 2.0, "crude.oil": 7343.0, "tarp": 293.0, "pistol.m92": 12.0, "ghostsheet": 2.0, "burlap.gloves": 3.0, "shoes.boots": 15.0, "bow.hunting": 1.0, "mask.bandana": 1.0, "burlap.trousers": 3.0, "hat.boonie": 1.0, "burlap.shirt": 3.0, "bow.compound": 3.0, "diving.tank": 3.0, "torch.torch.skull": 1.0, "workbench2": 4.0, "sleepingbag": 3.0, "lantern": 1.0, "floor.triangle.ladder.hatch": 15.0, "rifle.lr300": 15.0, "weapon.mod.small.scope": 11.0, "smg.thompson": 39.0, "scientistnpc_cargo_turret_any": 7.0, "icepick.salvaged": 9.0, "supply.signal": 38.0, "floor.ladder.hatch": 7.0, "weapon.mod.holosight": 13.0, "rocket.launcher": 34.0, "generator.wind.scrap": 13.0, "smg.mp5": 31.0, "ammo.pistol.hv": 50.0, "jackhammer": 19.0, "pistol.python": 32.0, "door.double.hinged.toptier": 23.0, "door.hinged.toptier": 25.0, "jacket": 4.0, "metal.plate.torso": 36.0, "pants": 27.0, "burlap.shoes": 2.0, "rifle.ak": 38.0, "rifle.bolt": 35.0, "ammo.rifle.hv": 458.0, "metal.facemask": 24.0, "aiming.module.mlrs": 5.0, "torch": 1.0, "knife.bone": 1.0, "smg.2": 23.0, "hmlmg": 6.0, "meat.pork.cooked": 96.0, "charcoal": 1545014.0, "ammo.handmade.shell": 48.0, "wall.frame.garagedoor": 21.0, "chainsaw": 11.0, "longsword": 1.0, "easter.goldegg": 1.0, "attire.egg.suit": 2.0, "explosive.timed": 633.0, "shotgun.spas12": 6.0, "hoodie": 29.0, "ammo.shotgun.fire": 55.0, "ammo.pistol.fire": 130.0, "coffeecan.helmet": 6.0, "ammo.shotgun.slug": 36.0, "rifle.semiauto": 11.0, "riot.helmet": 3.0, "roadsign.gloves": 12.0, "rifle.m39": 11.0, "grenade.f1": 104.0, "sign.wooden.small": 10.0, "box.repair.bench": 1.0, "ammo.rifle.explosive": 165.0, "bucket.helmet": 4.0, "shotgun.pump": 7.0, "lmg.m249": 21.0, "roadsign.jacket": 7.0, "keycard_green": 7.0, "keycard_red": 5.0, "keycard_blue": 5.0, "sulfur": 3550902.0, "locker": 5.0, "grenade.beancan": 2.0, "bed": 4.0, "rug.bear": 2.0, "mushroom": 788.0, "barricade.wood.cover": 8.0, "shelves": 1.0, "electric.battery.rechargable.large": 8.0, "workbench3": 2.0, "dropbox": 1.0, "electric.button": 1.0, "attire.hide.pants": 1.0, "wall.external.high": 1.0, "scientistnpc_cargo_turret_lr300": 10.0, "ammo.rocket.mlrs": 9.0, "weapon.mod.extendedmags": 4.0, "wall.window.bars.toptier": 4.0, "electric.rf.receiver": 3.0, "heavy.plate.helmet": 4.0, "grenade.smoke": 2.0, "scientistnpc_cargo": 8.0, "electric.solarpanel.large": 4.0, "heavy.plate.pants": 5.0, "trap.landmine": 2.0, "mixingtable": 11.0, "autoturret": 33.0, "weapon.mod.lasersight": 19.0, "explosives": 1624.0, "powered.water.purifier": 2.0, "weapon.mod.muzzlebrake": 1.0, "water.catcher.large": 2.0, "roadsign.kilt": 21.0, "trap.bear": 2.0, "speargun": 2.0, "scientistnpc_heavy": 38.0, "flamethrower": 4.0, "ammo.grenadelauncher.buckshot": 6.0, "multiplegrenadelauncher": 5.0, "ammo.grenadelauncher.he": 22.0, "diesel_barrel": 2.0, "ammo.grenadelauncher.smoke": 8.0, "shutter.metal.embrasure.b": 3.0, "weapon.mod.simplesight": 1.0, "weapon.mod.flashlight": 7.0, "oretea.pure": 17.0, "jacket.snow": 2.0, "green.berry": 140.0, "blue.berry": 150.0, "red.berry": 280.0, "yellow.berry": 220.0, "research.table": 1.0, "wall.external.high.stone": 141.0, "oretea": 1335.0, "woodtea": 1003.0, "spraycan": 1.0, "deaths": 6.0, "mace": 2.0, "electric.counter": 1.0, "ladder.wooden.wall": 72.0, "ammo.rocket.basic": 287.0, "skull": 1.0, "cupboard.tool.deployed": 13.0, "axe.salvaged": 3.0, "machete": 1.0, "woodtea.pure": 63.0, "ammo.rocket.hv": 56.0, "wiretool": 1.0, "bearmeat.cooked": 2071.0, "innertube": 1876.0, "lock.key": 1.0, "rifle.ak.ice": 5.0, "stash.small": 5.0, "scarecrow": 7.0, "halloween.lootbag.medium": 1.0, "ammo.rifle.incendiary": 264.0, "hazmatsuit.arcticsuit": 3.0, "hazmatsuit.nomadsuit": 1.0, "furnace.large": 4.0, "shutter.metal.embrasure.a": 2.0, "grenade.flashbang": 6.0, "gates.external.high.stone": 1.0, "pistol.semiauto": 2.0, "storage.monitor": 1.0, "smart.switch": 1.0, "tshirt": 5.0, "weapon.mod.silencer": 1.0, "helicopter": 2.0, "black.raspberries": 272.0, "computerstation": 3.0, "ammo.rocket.sam": 300.0, "tactical.gloves": 16.0, "scientistnpc_patrol": 3.0, "scientistnpc_roam": 1.0, "elevator": 2.0, "horse.shoes.advanced": 2.0, "small.oil.refinery": 1.0, "electric.random.switch": 2.0, "halloween.candy": 18.0, "shotgun.waterpipe": 1.0, "snowballgun": 2.0, "ammo.rocket.fire": 48.0, "deermeat.cooked": 240.0, "scraptea.advanced": 1.0, "rifle.l96": 6.0, "scientistnpc_junkpile_pistol": 2.0, "spiderweb": 1.0, "seed.corn": 11.0, "nightvisiongoggles": 1.0 }, "Invites": {}, "Last Wipe": "0001-01-01T00:00:00" }

Hey Mevent! Hello man, here i bring you a bought that is smelling to me that my user "broke" the scale from the clans rankings, you see, my server is a x1000, so, yesterday i got a complain from my top #1 user saying he's not on the top #1 anymore (i've a mechanic on my server that i give a reward to the top #1 on the monthly wipe) so i'm looking at the console and i see this error, also, on the DB i see the user but as he said, i see the ranking and he's not on the /clan ranking anymore, seems like got so higher values that couldn't be tracked, that's my hunch. This is the console error i'm receiving: MySql handle raised an exception (MySqlException: Incorrect string value: '\xF0\x9D\x94\xBC\xF0\x9D...' for column 'Clans' at row 313) at MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery (System.IAsyncResult asyncResult) [0x00022] in :0 at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery(System.IAsyncResult) at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x000f2] in :0 Can you help me to solve this please? On Thursday i've to give the reward to my top 1 user

Hello man! I just bought your simple stats plugin/website and i having the following error: DataTables warning: table id=DataTables_Table_0 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1 when accessing to the page where the table is displayed. What could i do?

Thanks man. The issue was related to using PHP 7 instead of 8. As you mentioned on your setup guide. I changed it to 8 and the page started working.

Hello! can you please send me the ports needed to be opened? I can't manually open them and i asked to the hosting admins to open all the ports but they're asking me which ones do i need. And i don't know.