Canary [SOLVED] Getting error with depot_items when I run canary

[dumia]

Hello all, I've set up a simple server for me and some friends using canary and been having this issue when I launch the server:

[2024-19-09 11:32:20.602] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 1 ORDER BY sid DESC
[2024-19-09 11:32:20.602] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.604] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 2 ORDER BY sid DESC
[2024-19-09 11:32:20.605] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.606] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 3 ORDER BY sid DESC
[2024-19-09 11:32:20.607] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.609] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 4 ORDER BY sid DESC
[2024-19-09 11:32:20.609] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.611] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 5 ORDER BY sid DESC
[2024-19-09 11:32:20.611] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.613] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 6 ORDER BY sid DESC
[2024-19-09 11:32:20.613] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.616] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 8 ORDER BY sid DESC
[2024-19-09 11:32:20.616] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.618] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 9 ORDER BY sid DESC
[2024-19-09 11:32:20.618] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.620] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 10 ORDER BY sid DESC
[2024-19-09 11:32:20.620] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.623] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 11 ORDER BY sid DESC
[2024-19-09 11:32:20.623] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.625] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 12 ORDER BY sid DESC
[2024-19-09 11:32:20.625] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.628] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 18 ORDER BY sid DESC
[2024-19-09 11:32:20.628] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.630] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 19 ORDER BY sid DESC
[2024-19-09 11:32:20.630] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.633] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 13 ORDER BY sid DESC
[2024-19-09 11:32:20.633] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.635] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 14 ORDER BY sid DESC
[2024-19-09 11:32:20.635] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.638] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 16 ORDER BY sid DESC
[2024-19-09 11:32:20.638] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.640] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 17 ORDER BY sid DESC
[2024-19-09 11:32:20.640] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.643] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 15 ORDER BY sid DESC
[2024-19-09 11:32:20.643] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.646] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 20 ORDER BY sid DESC
[2024-19-09 11:32:20.646] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.648] [info] [migration] Executing game migration 20241708485868_move_some_storages_to_kv
[2024-19-09 11:32:20.648] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 1 ORDER BY sid DESC
[2024-19-09 11:32:20.649] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.650] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 2 ORDER BY sid DESC
[2024-19-09 11:32:20.651] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.652] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 3 ORDER BY sid DESC
[2024-19-09 11:32:20.652] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.655] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 4 ORDER BY sid DESC
[2024-19-09 11:32:20.655] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.657] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 5 ORDER BY sid DESC
[2024-19-09 11:32:20.657] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.659] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 6 ORDER BY sid DESC
[2024-19-09 11:32:20.659] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.662] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 8 ORDER BY sid DESC
[2024-19-09 11:32:20.662] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.664] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 9 ORDER BY sid DESC
[2024-19-09 11:32:20.664] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.666] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 10 ORDER BY sid DESC
[2024-19-09 11:32:20.666] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.669] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 11 ORDER BY sid DESC
[2024-19-09 11:32:20.669] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.671] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 12 ORDER BY sid DESC
[2024-19-09 11:32:20.671] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.674] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 18 ORDER BY sid DESC
[2024-19-09 11:32:20.674] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.676] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 19 ORDER BY sid DESC
[2024-19-09 11:32:20.676] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.679] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 13 ORDER BY sid DESC
[2024-19-09 11:32:20.679] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.681] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 14 ORDER BY sid DESC
[2024-19-09 11:32:20.681] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.683] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 16 ORDER BY sid DESC
[2024-19-09 11:32:20.683] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.686] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 17 ORDER BY sid DESC
[2024-19-09 11:32:20.686] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.689] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 15 ORDER BY sid DESC
[2024-19-09 11:32:20.689] [error] Message: Table 'otserv.player_depotitems' doesn't exist
[2024-19-09 11:32:20.691] [error] Query: SELECT pid, sid, itemtype, count, attributes FROM player_depotitems WHERE player_id = 20 ORDER BY sid DESC


After checkingg PhPadmin i tried creating a new table with the query :
CREATE TABLE player_depotitems
(
player_id INT NOT NULL,
sid INT NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',
pid INT NOT NULL DEFAULT 0,
itemtype INT NOT NULL,
count INT NOT NULL DEFAULT 0,
attributes BLOB NOT NULL,
KEY (player_id), UNIQUE (player_id, sid),
FOREIGN KEY (player_id) REFERENCES players(id) ON DELETE CASCADE
) ENGINE = InnoDB;



But on the xampp interface I get the following error:




Any idea how I can fix this issue?

Thanks in advance!

 

[tobi132]

You need to first select the database on which you want to execute the query.

You can do that on the left side of the phpmyadmin menu, right here:

 

[dumia]

Awesome it worked! no more erros, referenced my main database and it's working now

although i'm still getting this warning here:
[warning] MySQL host, user, password, database or port not provided

Know anything about it?