i might just wait for some initial final release products rather than betas as i think thats the issue but at least i can start and join my server just map glitches and a few others so i guess i will have to be patient
since I was active in scripts for a while, I know what an effort that is ⌠it takes a while until a âframeworkâ such as ESX comes along ⌠although many of my esx scripts that have no dependencies work fine in redM
this is line 67 and what is coming back as a nil value:
if(_version[1].id == version)then
more often than not, the answer to your issue is in the error⌠sv_db.lua , line 67. attempted to index a nil value. in other words, the script was written in such a way as to fully expect that a value would ALWAYS be returned when that check is performed. So it is reasonable to assume one of two things.
A. the script cannot reference the database to retrieve the information
or
B. the information is not in the database to be retrieved.
Is there any indication that the server is connected to and communicating with the database outside of this error? Are you able to create, save, and view a character within the database? If so, the issue is missing data, such as a table/column. If youâve had no ability to save data thus far, be sure to double and triple check that
set es_enableCustomData 1
set mysql_connection_string âserver=127.0.0.1;uid=root;password=password;database=redemrpâ
are set above mysql-async and esplugin_mysql in server.cfg⌠Infact, be absolutely sure that database resources are above redem resources in the server.cfg
[RedEM:RP] Database: Successfully created database
e[31m[ERROR] [MySQL] [redem_roleplay] An error happens on MySQL for query "USE `red`;
ALTER TABLE `characters`
ADD COLUMN `id` INT NOT NULL AUTO_INCREMENT FIRST,
ADD PRIMARY KEY (`id`);": ER_DUP_FIELDNAME: Duplicate column name 'id'e[0m
[RedEM:RP] Database: Successfully updated database for version: 2
e[31m[ERROR] [MySQL] [redem_roleplay] An error happens on MySQL for query "USE `red`;
ALTER TABLE `version`
ADD COLUMN `resource` varchar(50),
DROP PRIMARY KEY;": ER_CANT_DROP_FIELD_OR_KEY: Can't DROP 'PRIMARY'; check that column/key existse[0m
[RedEM:RP] Database: Successfully updated database for version: 3
[RedEM:RP] Database: Your database is fully up to date!
Letâs start with that I admire and value your direct approach so we can all make a greater future for RedM!
Now you didnât go into much details so Iâd like to ask if you could you please eleborate on what specific parts make this look like ESX, a lot of effort has been put into making sure thatâs not the case.
Hope to hear from you soon, Iâll already thank you for not being shy and coming out quickly.
I wasnât aware of these similarities, Iâll put it on the todo list for rewrites. What I did notice is that these arenât the main resources so theyâre not constantly checked by the authoritative staff that exists to avoid these things.
If youâve got any more then donât be afraid to provide us with more information!