Error: migrate playerdata to Mysql

[SoulHnt]

Hi, i'm new here.

i have a few questions regarding migrating if anyone can help.

I'm currently using
- Intersect Engine 0.7.1.92-beta Full
- Xampp 8.2

      - PHP 8.2.0

      - Apache 2.4.54

      - MariaDB 5.4.27

      - phpMyAdmin 5.2.0

All the information was entered correctly into the migrating feature, and it creates all the tables, but their all empty.
After viewing the sqlite db with SqliteBrowser, i noticed that certain field show's as BLOB.
Was wondering if maybe this may be the cause, or the table's field not being set correctly.

The picture shown, is from SqliteBrowser reading the default sqlite db.

I was thinking, maybe i can save from sqlitebrowser as SQL and update it manually onto SQL, it fails and this is the data pulled.

INSERT INTO "main"."Players" ("Id", "UserId", "Name", "LastOnline", "MapId", "X", "Y", "Z", "Dir", "Gender", "Sprite", "Face", "Level", "Exp", "ClassId", "Vitals", "StatPoints", "BaseStats", "StatPointAllocations", "Equipment", "NameColor", "ItemCooldowns", "SpellCooldowns", "FooterLabel", "HeaderLabel", "Color", "CreationDate", "DbGuildId", "GuildJoinDate", "GuildRank", "PlayTimeSeconds", "InstanceType", "LastOverworldMapId", "LastOverworldX", "LastOverworldY", "PersonalMapInstanceId", "SharedInstanceRespawnDir", "SharedInstanceRespawnId", "SharedInstanceRespawnX", "SharedInstanceRespawnY", "SharedMapInstanceId") VALUES (X'79ede5ae7205db4a9f521c49e9c70002', X'0f189ce4587897439af5b640d15dda7c', 'Taktik', '2022-12-30 21:34:16.8386036', X'1d5090ff90b82a40a069c335320fd1de', '19', '7', '0', '0', '0', 'npc_wizard.png', '', '5', '446', X'f61de12490fb0c479970e049760dbbef', '[10,30]', '0', '[20,15,20,27,20]', '[2,0,0,0,0]', '[-1,-1,-1,-1,-1]', '{"A":0,"R":0,"G":0,"B":0}', '{}', '{}', '{"Label":null,"Color":null}', '{"Label":null,"Color":null}', '{"A":255,"R":255,"G":255,"B":255}', '2022-12-30 17:35:41.6671448', '', '0001-01-01 00:00:00', '0', '22448', '0', X'00000000000000000000000000000000', '0', '0', X'00000000000000000000000000000000', '0', X'00000000000000000000000000000000', '0', '0', X'00000000000000000000000000000000');
INSERT INTO "main"."Players" ("Id", "UserId", "Name", "LastOnline", "MapId", "X", "Y", "Z", "Dir", "Gender", "Sprite", "Face", "Level", "Exp", "ClassId", "Vitals", "StatPoints", "BaseStats", "StatPointAllocations", "Equipment", "NameColor", "ItemCooldowns", "SpellCooldowns", "FooterLabel", "HeaderLabel", "Color", "CreationDate", "DbGuildId", "GuildJoinDate", "GuildRank", "PlayTimeSeconds", "InstanceType", "LastOverworldMapId", "LastOverworldX", "LastOverworldY", "PersonalMapInstanceId", "SharedInstanceRespawnDir", "SharedInstanceRespawnId", "SharedInstanceRespawnX", "SharedInstanceRespawnY", "SharedMapInstanceId") VALUES (X'9ad03c3ced77d24d8f6845b4fb5596ad', X'287025c872624d46bd6b05484ba20d71', 'Alex', '2022-12-31 03:12:24.4903256', X'1d5090ff90b82a40a069c335320fd1de', '11', '12', '0', '2', '0', 'base_male_002.png', '', '1', '0', X'92bb2dd77807014887dda0a062004d6a', '[30,10]', '0', '[25,20,30,10,20]', '[0,0,0,0,0]', '[-1,-1,-1,-1,-1]', '{"A":0,"R":0,"G":0,"B":0}', '{}', '{}', '{"Label":null,"Color":null}', '{"Label":null,"Color":null}', '{"A":255,"R":255,"G":255,"B":255}', '2022-12-31 08:11:24.559712', '', '0001-01-01 00:00:00', '0', '118', '0', X'00000000000000000000000000000000', '0', '0', X'00000000000000000000000000000000', '0', X'00000000000000000000000000000000', '0', '0', X'00000000000000000000000000000000');
INSERT INTO "main"."Players" ("Id", "UserId", "Name", "LastOnline", "MapId", "X", "Y", "Z", "Dir", "Gender", "Sprite", "Face", "Level", "Exp", "ClassId", "Vitals", "StatPoints", "BaseStats", "StatPointAllocations", "Equipment", "NameColor", "ItemCooldowns", "SpellCooldowns", "FooterLabel", "HeaderLabel", "Color", "CreationDate", "DbGuildId", "GuildJoinDate", "GuildRank", "PlayTimeSeconds", "InstanceType", "LastOverworldMapId", "LastOverworldX", "LastOverworldY", "PersonalMapInstanceId", "SharedInstanceRespawnDir", "SharedInstanceRespawnId", "SharedInstanceRespawnX", "SharedInstanceRespawnY", "SharedMapInstanceId") VALUES (X'1d871cb2b2f7ac48a657662f09e95301', X'53262d2eb60638479725cf9644e60ed8', 'RangerTest', '2022-12-31 21:30:34.1575152', X'1d5090ff90b82a40a069c335320fd1de', '21', '12', '0', '3', '0', 'base_male_005.png', '', '1', '0', X'645a802caafbcf42bee2b5d30c0b4b49', '[25,20]', '0', '[25,20,25,10,25]', '[0,0,0,0,0]', '[-1,-1,0,-1,-1]', '{"A":0,"R":0,"G":0,"B":0}', '{}', '{}', '{"Label":null,"Color":null}', '{"Label":null,"Color":null}', '{"A":255,"R":255,"G":255,"B":255}', '2023-01-01 01:58:06.3876186', '', '0001-01-01 00:00:00', '0', '3866', '0', X'00000000000000000000000000000000', '0', '0', X'00000000000000000000000000000000', '0', X'00000000000000000000000000000000', '0', '0', X'00000000000000000000000000000000');

 

[panda]

BLOB Fields are not empty, it just shows BLOB instead of their binary data (which is unreadable anyway).

[SoulHnt]

3 hours ago, panda said:

BLOB Fields are not empty, it just shows BLOB instead of their binary data (which is unreadable anyway).

So if i pull this out, and import it into mysql, the information should be correct?

[panda]

16 hours ago, SoulHnt said:

So if i pull this out, and import it into mysql, the information should be correct?

No, because the storage formats of the columns are different between MySQL and Sqlite (they have different features).

The only correct way to migrate between the two is via the server migration command. If the migration command is not working you need to file a bug with detailed information on reproducing this including logs and either screenshots/text dump of the server console.