you do understand that is not a fix, this shouldn’t happen in the first place as users table is a primary key and kashacters shud be setting the id as charX:XXXX.
1 Like
Anyone has a solution to my problem in installing Kashacters ?
hi does anyone know how to fix when u load in the server u get a blurry screen nothing else just stuck in the clouds with blurry screen any help?
how do you bump up the indentifier fields to 100?
You should probably only need to get them to 60, and for that you just need to make a SQL change to the table/field. This should help: https://stackoverflow.com/questions/22668024/how-to-change-column-size-of-varchar-type-in-mysql
Everytime I restart FiveM, my character is not spawning where I was the last time but somewhere in Los Santos downtown. When I looked into the php database, it is not recording anymore their last saved position when you stop the game, and that since I have started Kashacters. The position I have is x = 0.0, y = 0.0, z = 0.0 somewhere below Spanish Ave. And yes, I have made the change of code in the other file to unactivate lines 6-16.
Someone in this thread had the same problem than me and said to NOT unactivate the full part from line 6 to 16, but only 2 lines out of those.
I tried and finally I was spawning where I saved the last time, so that’s good. HOWEVER, it screwed up the skin.lua or whatever (show an error message in the server console) and the character was not respawning on his character. Meaning I was having the inventory etc… but not the body, or clothes of my character, just a by-default character. And I cannot change the character as everytime, I receive that error message about skin.lua. When I unactivate Kashacters in my server.cfg, everything is back to normal: location of last game + skin/characters.
Any solution ?
Hi guys, i have this probleme into my console : SCRIPT ERROR: @esx_kashacters/server/main.lua:24: attempt to call a nil value (global ‘SetIdentifierToChar’)
I don’t know what i do … And stuck and the screen
thanks for the reply, i will look over this, does this do anything else funky i need to be aware of ? ill set it to 60 next chance I get!
Nah, you don’t really have to worry about going up in size (within reason). Shrinking can be a different story, but that doesn’t apply here. Good luck with your project.
thanks again, I have to read up on all of this again and see how to fix it again, updateing the datastore (main.lua) seemed to help a little, having trouble saving stuff in storage, Everyone has an idea how to get it working but does not seem to a a definitive way to do it. (double sigh)
Yeah totally understand, it can be a headache. I found that you have to do things to the book exactly to get this script working. It took a complete rebuild, and even then it might come down to having the exact version of ESX and Kashacters, as well as ensuring other scripts aren’t conflicting. If your DB fields were the original size from the ESX install then that is most certainly AN issue…it could just be along with other things as well.
I saw the sting to increase the number, ALTER TABLE <table_name> MODIFY <col_name> VARCHAR(60);
im wondering if there is a way to check to see what the default value is, and what tables need to be changed?
thanks again for the reply, This is the last thing keeping my server from being just about perfect, its hard for criminals and the like to store drugs and stuff if they cant trust the system, this is such a important part of the game. I would give up all my custom cars and interiors if thats what it took to get this working haha thanks again !!!
Table names depend on which scripts you have installed…but you simply need to check every table in your db for a “owner” or “indentifier” field…if it’s not 60 already, bump it up. That is how your db connects who owns what, so if they’re not all updated you undoubtedly have storage issues. I’m uncertain what the original size is…you can look that up in the original ESX SQL files if you’re curious.
alrighty ill run the
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = ‘owner’
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = ‘identifier’
stuff again and make sure all of them are 60
user_accounts is only varchar(22)
this template:
ALTER TABLE <table_name> MODIFY <col_name> VARCHAR(60);
ALTER TABLE <user_accounts> MODIFY < latin1_swedish_ci> VARCHAR(60);
not sure about the <col_name>
[COLLATION_NAME] is in the identifier for user_accounts
am i getting close, I dont want to try it yet, dont want to blow up the data base hahaha
double check my work, there was a lot of them set 60+ some of them were low though 20ish
kashacters isn’t saving last position properly? Anyone know of a fix?
I have the same problem. Are you going back to the same position on Spanish Ave ? Your php should show you a 0;0;0 coordinates for your character.
I tried to fix it and saw a method on this thread (see one of my previous comment these past few days) and when applying that method, it fixes the last position saving, but then, the skin.lua is broken and malfunctioning, meaning your character spawn where you were, but as a default character, not yours, and you cannot get yours back.
I asked help but nobody is helping so far.
try going to a tattoo shop and see if it loads in the saved ped
I cannot work on my server right now to test. Do you think it fixes the problem? For me, it was not autoloading my character as it should, and was not letting me doing it manually from the menu. My server console was repeating the skin.lua error everytime I was triggering it to load my character