So On my server when i load go to run it i keep getting these errors. The server runs and you can get on but these errors keep happening. Any help would help.
What’s up Ruperto? Both errors in garages and banking are in server.lua at line 2:1. The script is expecting ’ ) ’ and instead it’s getting a ‘string’ called.
Hey! Sorry if i dont remember but what was your SoE ign?.. Also what am i supposed to change? Im a bit confused…
I haven’t played on SoE in months. Jackson Caine. Stock scripts shouldn’t be throwing any errors. I use banking I don’t use the garages. I get no errors from banking. I’m not at home right now so I can’t take a look at the banking script to see what’s going on. But if you haven’t changed anything it’s confusing on why you are getting errors. That’s not a DB error, but both errors are in server and line 2. Which is usually some sort of ‘check’.
So Line two in server.lue is the “MySQL:open(“ip”, “databasename”, “username”, “password”)” line which is what is in both of them…
Found the file on my phone. require “resources/essentialmode/lib/MySQL”
MySQL:open(“ip”, “databasename”, “username”, “password”) did you add an extra " after the )? Because without your DB info filled in you should of gotton a different error.
So im new to this all in those lines that say “MySQL:open(“ip”, “databasename”, “username”, “password”)” i need to fill in those all with the db info? I wasnt sure if it all went off of the info already entered onto the “resources/■■■■■■■■■■■■■/lib/MySQL”. Sorry if thats a stupid question
No question is stupid, thats how we learn. Yeah you have to fill in your DB information there. The IP address of your server, username and password. IP 127.0.0.1 for local host. Root is username unless you changed this in your MySQL server. And password is what you want it to be. If you haven’t set up a MySQL server, start there. If your using the new essentials 3.0 it uses couch DB not MySQL and cannot be used with [es] script that use a .SQL. (EDIT: yeah you don’t fill in DB info there, it should get it from the required resources lib SQL.)
so i have a MySQL database made and i put all the info in there and it didnt do anything on the database…
I made a mistake there. Don’t enter your DB info there. It should get the DB info from [es] main login file. After making the MySQL DB and putting the DB info into [es] main login, import the [es] .SQL into your DB. Any [es] script that uses the DB will require you to import the resources . SQL into the DB. After running the .SQL you will see tables added.
Ahhh ok… Should there only be one .SQL with the essentialmod e files? Cause i dont see one for the ES admin…? Thank you for the help!
So i did all of that and im still getting this for banking and garages… 
There’s only one .SQL, the admin tables are in the . SQL. You have something in the script you shouldn’t. I’ll be home in 15 mins I’ll check my banking script and copy/paste my server.lua line2. Did you run the SQL for banking and garages and see the tables in you DB?
Yes i did and This is what appears in the DB for me…
Everything in your DB looks good. It’s something in your script. If you have an extra " at the end remove it. It should end with a ) not a )"
Something in the script as in the login.lua script?.. Or?
No, not in login. The error indicates it’s server4, server.lua line2 in the resource garages. What you copy and pasted awhile ago had an extra " at the end.
There is no extra " at the end of any of them and its still giving the error…
here is my server.lua lines 1-2 from banking.
require “resources/essentialmode/lib/MySQL”
MySQL:open(“127.0.0.1”, “gta5_gamemode_essential”, “myuser”, “mypassword”)
banking starts with no errors for me. i dont use garages, but its the same error.
So idk why i copied that and put it in the banking one and put my user and pass in there and its not doing it anymore but i did the same to the other ones and they are still giving the errors… Lol Im so confused with it.