[BUG] prism inspect does not produce results
Envel-Nikita-Gutsenkov opened this issue ยท 2 comments
Describe the bug
prism inspect does not produce results, while lookup and near work correctly. I haven't been able to figure out why this is happening. initially, everything works, but when some array of information accumulates in the database, it stops working
Server (please complete the following information):
- Prism Version: latest (source code) (it was always observed)
- Server Type: Paper
- Server Version: 1.16-1.17 (it was always observed)
debug info
[17:23:51 INFO]: [Prism] - Debug - Ignoring Action Type: player-command [17:23:51 INFO]: [Prism] - Debug - Wand activated for player - mode: stick Item:AIR [17:23:52 INFO]: [Prism] - Debug - Cancelling event for wand use. [17:23:52 INFO]: [Prism] - Debug - SELECT MIN(id) id, MIN(epoch) epoch, MIN(action_id) action_id, MIN(player) player, MIN(world_id) world_id, AVG(x), AVG(y), AVG(z), MIN(block_id) block_id, MIN(block_subid) block_subid, MIN(old_block_id) old_block_id, MIN(old_block_subid) old_block_subid, MIN(data) data, MIN(HEX(player_uuid)) AS uuid, COUNT(*) counted FROM prism_data INNER JOIN prism_players p ON p.player_id = prism_data.player_id LEFT JOIN prism_data_extra ex ON ex.data_id = prism_data.id WHERE world_id = ( SELECT w.world_id FROM prism_worlds w WHERE w.world = 'world') AND action_id NOT IN (57,53,59,54,null) AND ( (prism_data.x = -194 AND prism_data.y = 71 AND prism_data.z = -81)) GROUP BY prism_data.action_id, prism_data.player_id, prism_data.block_id, ex.data, DATE(FROM_UNIXTIME(prism_data.epoch)) ORDER BY MAX(prism_data.epoch) DESC, AVG(x) ASC, AVG(z) ASC, AVG(y) ASC, MIN(id) DESC LIMIT 1000;
or paste https://paste.gg/p/anonymous/75f82cdcd4b9461896fae0e8dbd52dcb
This repository is no longer active. You can try to resubmit this at the current Prism repo here https://github.com/prism/PrismRefracted