Players resource not working

[guguguguegegege]

So, I'm trying to make a roleplay server for me and my friends and I'm using the leaked Paradise Roleplay scripts (go ahead, make fun) and I've been trying to get it running, but somehow the "players" resource isn't starting. I have searched thru a bit of posts, but not were able to solve my problem.

==================================================================
= Multi Theft Auto: San Andreas v1.5.7
==================================================================
= Server name      : paradise ~ Roleplay
= Server IP address: auto
= Server port      : 22003
= 
= Log file         : ..ktop/server/mods/deathmatch/logs/server.log
= Maximum players  : 32
= HTTP port        : 22005
= Voice Chat       : Disabled
= Bandwidth saving : Medium
==================================================================
[2020-03-21 20:48:54] Resources: 30 loaded, 0 failed
[2020-03-21 20:48:54] MODULE: Loaded "MySQL 5.0 database module" (0.41) by "Alberto Alonso <[email protected]>"
[2020-03-21 20:48:54] MODULE: Loaded "SHA Module" (1.02) by "mabako"
[2020-03-21 20:48:54] Starting resources......
[2020-03-21 20:48:54] Start up of resource irc cancelled by script
[2020-03-21 20:48:54] ERROR: Unable to start resource irc; Start up of resource cancelled by script
[2020-03-21 20:48:55] ERROR: sql\layout.Lua:91: Unable to create table characters
[2020-03-21 20:48:55] Start up of resource players cancelled by script
[2020-03-21 20:48:55] Start up of resource players cancelled by script
[2020-03-21 20:48:56] ERROR: sql\layout.Lua:91: Unable to create table characters
[2020-03-21 20:48:56] INFO: Loaded 0 maps with 0 objects.
[2020-03-21 20:48:56] ERROR: sql\layout.Lua:91: Unable to create table characters
[2020-03-21 20:48:56] Start up of resource players cancelled by script
[2020-03-21 20:48:57] Start up of resource players cancelled by script
[2020-03-21 20:48:57] ERROR: sql\layout.Lua:91: Unable to create table characters
[2020-03-21 20:48:57] ERROR: factions\factions.Lua:102: bad argument #1 to 'ipairs' (table expected, got boolean)
[2020-03-21 20:48:57] ERROR: sql\layout.Lua:91: Unable to create table characters
[2020-03-21 20:48:57] Start up of resource players cancelled by script
[2020-03-21 20:48:57] ERROR: Unable to start resource players; Start up of resource cancelled by script

[Citizen]

 Please follow the rules of this section: 

Quote

- No support is offered for leaked code or scripts (even if they only partially originate from a leak) and such topics will be locked and trashed on sight.

 

[Dutchman101]

3 hours ago, Benzoㅤ said:

and I'm using the leaked Paradise Roleplay scripts (go ahead, make fun)

It's weird that you are claiming Paradise Roleplay is leaked, while it's an open-source gamemode:

https://github.com/mabako/mta-paradise

[Citizen]

Disregard what I have said then.
You didn't follow the setup instructions correctly: https://github.com/mabako/mta-paradise/blob/master/INSTALL.md

[guguguguegegege]

Quote

You didn't follow the setup instructions correctly: https://github.com/mabako/mta-paradise/blob/master/INSTALL.md

I followed every step, but it's still not working.

[The_GTA]

10 hours ago, Citizen said:

- No support is offered for leaked code or scripts (even if they only partially originate from a leak) and such topics will be locked and trashed on sight.

I think this ridiculous statement by OP also got me

3 hours ago, Benzoㅤ said:

I followed every step, but it's still not working.

I took at look at the source code in question and found the following relevant locations:

https://github.com/mabako/mta-paradise/blob/6d4a852e27a276920943827426b9cf88e20a6b7d/resources/players/main.Lua#L297
https://github.com/mabako/mta-paradise/blob/6d4a852e27a276920943827426b9cf88e20a6b7d/resources/sql/layout.Lua#L91

It looks like your MySQL configuration could be faulty. Here are some suggestions of what problem scenarios you could inspect:

• did you create a new MySQL user for mta-paradise and adjusted the settings.xml file in the resource so that the system can log-in?
• have you given the MySQL user complete access rights? creating tables? selecting? etc?

- Martin

Edited March 22, 2020 by The_GTA