search

VORPCORE / vorp_character-lua

character creation for RedM Vorp core framework
GNU General Public License v2.0
9 stars 46 forks source link

Character Selection Menu Wont Load. #120

Closed vlPsychosis closed 5 months ago

vlPsychosis commented 5 months ago

Describe the issue I updated Vorp Core, Vorp Inventory, Vorp Character, Vorp Admin, and Vorp Menu. However, now when I load into my server, It just loads me in and does not send me to the character selection menu first. When I check, Vorp says everything is up to date. And I'm rather new to this so I've been struggling to find what the issue is.

Expected behavior I expected to load the server, and be brought to my character selection menu. However, it just loads me in on the character I was last on prior to updating the files.

Screenshots If applicable, add screenshots to help explain your problem. image

image

bganderson commented 5 months ago

This is caused by a schema problem in the characters table which prevents your character from getting saved. The error says the joblabel field is missing. You can confirm this by running this query against the database; DESCRIBE vorpv2.characters (replace vorpv2 with whatever your database name is).

You should be able to patch it by modifying your characters table to match the one in their pre-made MariaDB.sql. From what I saw when I looked, it will need more modifications than just that joblabel field.

NOTE: You won't be able to simply run the statement I've highlighted in that link since the table already exists. You'll need to check each column/field and use ALTER TABLE to make them match.

I believe this is actually an issue in vorp_core since I'm pretty sure that resource creates the characters table.

outsider31000 commented 5 months ago

yes job label is missing not a vorp character issue. ALTER TABLE characters ADD COLUMN joblabel VARCHAR(255) DEFAULT 'job label' AFTER job; you can run this code.

any other issues open them i ntheir respective repos. or ask in discord.