#wont let me in server anyone know what this mean
1 messages · Page 1 of 1 (latest)
Are you local hosting?
Yeah mate I’ve tried everything can think off
Sql turned on in xampp?
Yeah pal that’s what confusing life out of me
In the live console, towards the end does it say - database connection established?
Just restarted my pc to reload everything up again so I’ll double check that too
Don't send friend requests/messages, all support is done here
clicked your name and didn’t mean click onto friend request mate
no it sitll not working none my mate or i as owner cant join
Did you check what I said
yh its connection established
script:connectqueue] QUEUE: [connectqueue] Disabling hardcap
what does this mean when i launch the server this is only wierd thing im finding
i need help pls i cant open the stash of the shop . if u have some solution
anyone able to helo still shwoing this tried for hoursssss
is this still the issue you're having?
the error indicates that your game server is unable to connect to your database.
Have you checked to ensure that your database credentials are formatted correctly inside your server.cfg file?
yeah which ones should i check im pretty sure dont all matey
@subtle sand been trying this since 1 aha i remeber you your the legend who helped me before
always happy to help 😄
so inside your server.cfg file you should see a line starting with set mysql_connection_string
you'll want to double check these settings an ensure that they match your database host, name, user and password.
so ive update my SQL ealier incase that was the problem will i have a new connection string to add on to it now ?
if you re-created your sql database then you may have changed the name or the user associated with the database
did you only update your mysql server or did you delete it and create another one?
and after you updated it did you start the server back up?
make sure it's running 🙂
the sql server, I mean
no havent done anything
it was fine then went out came back and said the following what i sent other
how is your server hosted? on your pc or on a vps server?
on my pc bro
using xampp?
yeah
open your xampp control panel and ensure that MySQL is running - it should look something like this if it's running correctly:
thats how it is mate
if you open a browser and go to http://localhost/phpmyadmin does it load your databases or give you an error?
you'll either see your databases or a red mysql error
yep, so your sql server is running, that's good.
go into your server.cfg file and paste that set mysql_connection_string line here so I can double check the formatting for you.
set mysql_connection_string "mysql://root@localhost/QBCoreFramework_B92F41?charset=utf8mb4"
hmm yeah that is correct
im lost i dont have a clue
restart your fivem server and see if you get any errors in your server console while it's starting up
does this help?
kind of, but scroll up to see if there's any errors closer to the top
your sql database is running, and the connection string is correct. as long as you didn't modify the database structure you should be able to connect, unless i'm missing something.. even if you modified the structure of the db it would still connect
hmm
then when i try to connect that what i sent before comes up but says this on logs like im in city which is strange
says i joined que and loaded in but didnt
yeah, that's because you're technically loading into the server but the framework is kicking you out for not being able to connect to the database
How do i get to db settings ill send them to you to see if any look out of place
you're connecting using localhost with a root user, no password, so as long as the connection string is correct you should be fine there.
in your xampp control panel, what does it say under Port on the MySQL line?
like here, mine is 3306 (the default mysql port)
3306 same
search on your fivem BOYS TILL DEATH RP and try to connect for me my mates are out
appartlney on live console i timed out ?
same error, which is what i expected
yeah its hard work aha
and when you go to phpmyadmin you don't have to enter a password to log into the root account right?
nah did'nt have to do anything just brought me up to what i sent other
got me stumped on this one mang
just to be sure... open your xampp control panel again and click the Logs button on the MySQL row. you should only have one option in the list. this is the actual error log file for the mysql server itself. open that file and see if there's any errors in there.
you can also click the Browse option under Logs and drop the entire mysql_error.log file in here and I'll review it
Yeah think we found the issue
ooh let me know
can you drag and drop the whole file in here?
if you click Browse it will take you to the file itself
thanks one second let me take a look
thanks matey
i'm honestly stumped on this one, but i'm going to see if someone else can have a look - maybe i'm missing somethingj
no as long as you've tried restarting it
i'm honestly stumped here man! let's go back to what you were doing before this started
what exactly did you do before you stopped being able to connect?
i added a drug script and it crashed but i fully deleted
so maybe i added something somewhere and i need to delete it
do u know where i could of added something i was having to change true false things but think i change them all back
i suggest going back to the instructions for the drug script and following them in reverse to change everything back