#My SQL error

1 messages · Page 1 of 1 (latest)

balmy elbow
#

The dev for my server @weary dirge added in the Framework V2 and we are getting these errors in console. When connecting to the server it doesn't open the framework at all and when doing /framework in chat it gets stuck on a black screen. Can you help us?

stoic marten
#

Clear Cache and Restart the server. It imported the database automatically.

weary dirge
empty crystal
#

Your connection string is incorrect.

weary dirge
empty crystal
#

What host do you use.

weary dirge
#

Iceline

empty crystal
#

Okay, there should be a section called DATABASE and it'll give you a connection string.

#

or it should give you one.

weary dirge
#

database is only showing this

empty crystal
#

Click the eyeball.

weary dirge
#

is it the JDBC Connection String?

empty crystal
#

yes]

#

It should be.

#

Jeez your database name is\ long

weary dirge
#

so do i set that in the server.cfg?

empty crystal
#

set mysql_connection_string "server=ipgoeshere;user=root;database=databasename;password=putyourpassword"

#

Should be something like that

weary dirge
#

sorry, do i put the connection string where the ip goes?

empty crystal
#

Send an SS of your current connection string.

weary dirge
#

i copied the username and password from the database section

#

for the server IP is the the connection IP or something different?

empty crystal
#

set mysql_connection_string "server=game-db-sg-1.iceline.host;user=u28995_pfo1cp78CT;database=s28995_Breakthrough_Roleplay_Database;password=PASSWORD"

#

You have to put your password at the end.

weary dirge
#

copy thank, let me try that

#

no longer errors but now these warnings

#

im about to try and join the server

empty crystal
#

Those are fine.

weary dirge
#

ok thank you, since im talking to you can i ask you a non framework related question as well?

empty crystal
#

What's up.

weary dirge
#

i keep getting errors in the console saying the server is not reading Steam IDs and i cant figure out why

#

ill send a pic one sec

#

i tried doing what it recommends there but it didnt fix it

empty crystal
#

You don't have a valid steam api key

weary dirge
#

how do i get a valid one?

#

i literally made a brand new one and put it in the cfg and its still doing it

empty crystal
weary dirge
#

it has the API key there and thats whats in the CFG

empty crystal
#

Revoke it and create a new one.

weary dirge
#

okay, let me try that

empty crystal
weary dirge
#

oh wait, i think i know what happened

#

Iceline makes you do it through the host settings instead of editing it directly in the cfg so it kept changing it back.

#

i feel stupid now 😂

#

I appreciate the help though

empty crystal
#

All good, gotta learn somehow right lmao.

weary dirge
#

is it normal that i changed that and it deleted the character i just made in the framework?

empty crystal
#

The framework had no saved data.

#

So it reset itself before characters were made.

weary dirge
#

Gotcha

#

Ok, that should be everything. Thank you guys so much for the help. Really appreciate it

empty crystal
#

You're welcome.

#

If you need anymore help just open a forum / ticket.

weary dirge
#

Hey im trying to move the framework text so it goes over our HUD in game. Could someone help me do that?

#

i just dont know where the numbers are where it says where to put those on the screen

empty crystal
#

You want it over the map?

#

Or just up more over your PLD

#

Also you have 2 PLD scripts running.