blank named variables in database.

Forum rules
NO LONGER BEING MAINTAINED!
Post Reply
User avatar
TeoTwawki
Developer
Posts: 527
Joined: Mon Jul 15, 2013 9:50 pm

blank named variables in database.

Post by TeoTwawki » Thu Apr 02, 2015 11:32 pm

blankVars.png
blankVars.png (9.2 KiB) Viewed 4054 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?
Hi, I run The Demiurge server.


Image
Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. - Martin Golding
PLS USE [ code ] CODE TAGS [ /code ] WHEN POSTING CODE
DO NOT PRIVATE MESSAGE ME ABOUT BUGS

Delaide
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Re: blank named variables in database.

Post by Delaide » Fri Apr 03, 2015 2:41 am

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);

User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: blank named variables in database.

Post by kjLotus » Sun Apr 05, 2015 10:27 pm

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?

User avatar
TeoTwawki
Developer
Posts: 527
Joined: Mon Jul 15, 2013 9:50 pm

Re: blank named variables in database.

Post by TeoTwawki » Sun Apr 05, 2015 10:46 pm

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?
Hi, I run The Demiurge server.


Image
Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. - Martin Golding
PLS USE [ code ] CODE TAGS [ /code ] WHEN POSTING CODE
DO NOT PRIVATE MESSAGE ME ABOUT BUGS

User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: blank named variables in database.

Post by kjLotus » Sun Apr 05, 2015 10:59 pm

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)

User avatar
TeoTwawki
Developer
Posts: 527
Joined: Mon Jul 15, 2013 9:50 pm

Re: blank named variables in database.

Post by TeoTwawki » Sun Apr 05, 2015 11:16 pm

Dump output shows that field empty.
(I dumped from command line)
Hi, I run The Demiurge server.


Image
Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. - Martin Golding
PLS USE [ code ] CODE TAGS [ /code ] WHEN POSTING CODE
DO NOT PRIVATE MESSAGE ME ABOUT BUGS

Post Reply