String Select Menu data collection

I have built out a String Select Menu that offers two menus, one to pick and item from the database and one to pick a player from the database.

I am having issues collecting this information to pass along so that I can create logic in my index.js file to send that item to the players inventory based on the database info selected.

Here is my command file for the /senditem command - https://sourceb.in/oHwyy5bicC
and this is my index.js -
https://sourceb.in/9CYq6ssnQ0

When I run the command I can select the options but I get interaction failed. Nothing shows in the console log when selecting them, only shows that it succesfully got the info from the database -

[nodemon] starting `node bot/index.js`
Ready! Logged in as TTRPGBOT#9189
Executing (default): SELECT 1+1 AS result
Logged into Database!
Executing (default): SELECT `item_id`, `item_name`, `item_description`, `inventory_id` FROM `item` AS `item`;
Executing (default): SELECT `player_id`, `name`, `user`, `password` FROM `player` AS `player`;
Was this page helpful?