Page 1 of 1

blank named variables in database.

Posted: Thu Apr 02, 2015 11:32 pm
by TeoTwawki
blankVars.png
blankVars.png (9.2 KiB) Viewed 5127 times
I've now seen this on 4 different servers I have helped, and it doesn't appear to be causing any problems by being present, but is likely a side effect of a problem that hasn't been recognized yet. I have no idea how those are being set - any lua script that tries to set a variable without a string for its name results in a debug break, and I have seen no crashes explaining these as having been that sort of mistake. Not a single one, and that is a lot of chars with this blank variable.

Any ideas?

Re: blank named variables in database.

Posted: Fri Apr 03, 2015 2:41 am
by Delaide
Hmm, I don't see those.
Here is my sql dump file, so you can see if there is anything else that seems like a carryover that should be reconfigured and wiped.
All mine have something:

Code: Select all

INSERT INTO `char_vars` VALUES (21828,'FFR',1),
(21828,'eventItemsStored2',2),
(21828,'fov_numneeded1',7),
(21828,'fov_LastReward',439862),
(21828,'supplyQuest_started',432737),
(21828,'returnedAilbecheRod',1),
(21828,'bcnm_instanceid',1),
(21828,'supplyQuest_fresh',1403535600),
(21828,'saveMySisterVar',1),
(21828,'CONQUEST_RING_RECHARGE',1416758400),
(21828,'EVERYONES_GRUDGE_KILLS',3),
(21828,'SaveMySon_Event',2),
(21828,'ChaosbringerKills',105),
(21828,'DistantLoyaltiesProgress',1),
(21828,'I_CAN_HEAR_A_RAINBOW',127),
(21828,'StoneYouNeed',2),
(21828,'LuckOfTheDraw',6),
(21828,'AnEmptyVesselProgress',4),
(21828,'notmeanttobeCS',1),
(21828,'SSG_SilverDoor',7),
(21828,'WotgStatus',12),
(21828,'COP1',1),
(21828,'option',1),
(21828,'PromyvionAccess',2),
(21828,'FOMOR_HATE',5),
(21828,'TOAUM3',2),
(21828,'REMAINING_IMPERIAL_ARMY_ID_TAG',2),
(21828,'TIME_IMPERIAL_ARMY_ID_TAG',211),
(21828,'mog-locker-expiry-timestamp',439763818),
(21828,'AssaultCap',99),
(21828,'mog-locker-access-type',1),
(21828,'TOAUM3_DAY',212),
(21828,'COP_Louverance_s_Path',10),
(21828,'COP_Tenzen_s_Path',11),
(21828,'PSOXJA_RESTRICTION_LVL',60),
(21828,'COP_Ulmia_s_Path',8),
(21828,'Dynamis_Status',222),
(21828,'DynamisID',12410),
(21828,'maatsCap',4096),
(21828,'ZilartStatus',1),
(21828,'PromathiaStatus',8),
(21828,'Cosmo_Cleanse_TIME',1412391606),
(21828,'Ancien_Beastcoin_store',237),
(21828,'Ru_aern_3-2KILL',1),
(21828,'Ru_aern_1-1KILL',1),
(21828,'Ru_aern_1-2KILL',1),
(21828,'Ru_aern_1-3KILL',1),
(21828,'Ru_aern_2-2KILL',1),
(21828,'Ru_aern_2-1KILL',1),
(21828,'Ru_aern_2-3KILL',1),
(21828,'Ru_aern_3-1KILL',1),
(21828,'Ru_aern_3-3KILL',1),
(21828,'DynaBeaucedine_Win',1),
(21828,'fov_repeat',1),
(21828,'LimbusID',1303),
(21828,'characterLimbusKey',504108),
(21828,'MetGreenMagianMog',1),
(21828,'hpmask1',1812988935),
(21828,'hpmask2',4196434),
(21828,'fov_regimeid',7),
(21828,'dynaWaitxDay',1425803233),
(21828,'HpTeleportMask3b',32),
(21828,'fov_numneeded2',1),
(21828,'fov_numkilled2',1),
(21828,'fov_numkilled1',2),
(21828,'Used_BRL',1),
(21828,'THE_FIGHTING_FOURTH',3);

Re: blank named variables in database.

Posted: Sun Apr 05, 2015 10:27 pm
by kjLotus
teotwawki wrote:
blankVars.png
I've now seen this on 4 different servers I have helped, and it doesn't appear to be causing any problems by being present, but is likely a side effect of a problem that hasn't been recognized yet. I have no idea how those are being set - any lua script that tries to set a variable without a string for its name results in a debug break, and I have seen no crashes explaining these as having been that sort of mistake. Not a single one, and that is a lot of chars with this blank variable.

Any ideas?
are you sure it's not a string your viewer can't display?

Re: blank named variables in database.

Posted: Sun Apr 05, 2015 10:46 pm
by TeoTwawki
kjLotus wrote:
teotwawki wrote:
blankVars.png
I've now seen this on 4 different servers I have helped, and it doesn't appear to be causing any problems by being present, but is likely a side effect of a problem that hasn't been recognized yet. I have no idea how those are being set - any lua script that tries to set a variable without a string for its name results in a debug break, and I have seen no crashes explaining these as having been that sort of mistake. Not a single one, and that is a lot of chars with this blank variable.

Any ideas?
are you sure it's not a string your viewer can't display?
that begs 2 questions, 1, what strings are all of workbench (orfficial mysql tool) navicat and heidi unable to display, and 2, what the heck could we possibly have named a var that would be undisplayed like that?

Re: blank named variables in database.

Posted: Sun Apr 05, 2015 10:59 pm
by kjLotus
teotwawki wrote:
kjLotus wrote:
teotwawki wrote:
blankVars.png
I've now seen this on 4 different servers I have helped, and it doesn't appear to be causing any problems by being present, but is likely a side effect of a problem that hasn't been recognized yet. I have no idea how those are being set - any lua script that tries to set a variable without a string for its name results in a debug break, and I have seen no crashes explaining these as having been that sort of mistake. Not a single one, and that is a lot of chars with this blank variable.

Any ideas?
are you sure it's not a string your viewer can't display?
that begs 2 questions, 1, what strings are all of workbench (orfficial mysql tool) navicat and heidi unable to display, and 2, what the heck could we possibly have named a var that would be undisplayed like that?
you can dump it to find out I think (navicat can't even display hex blobs half the time)

Re: blank named variables in database.

Posted: Sun Apr 05, 2015 11:16 pm
by TeoTwawki
Dump output shows that field empty.
(I dumped from command line)