How do i set an SQL temple pos?

[Xzyan]

I've been playing around with making ots for a while, but never with MySql.
I made a small map to test some of my code, but when i try to log in it gives the
"Temple position is wrong, please contact administrator" error.
I know lots of people have posted about this but so far none of the answers have worked for me.
Im using an 8.54 server with mySql.
My database is set up, but i can't seem to locate anything about a temple position.
I set the new player position in the Config .lua
And i've set the account manager postion to my towns temple pos in the sql database itself though im still receiving the error.

If anyone could help, it would be much appreciated thank you.

 

[Cykotitan]

UPDATE players SET posx=100, posy=100, posz=7, town_id=1

 

[Xzyan]

Could you be a little more specific? ^^
Im a little stupid when it comes to Sql, like i said, i just started.

My actual temple pos is 1022, 1026, 6

I went into the player set and edited the positions for the acc manager there but it didn't work that way either =S

 

[Cykotitan]

Execute it as a SQL query in phpMyAdmin (click on the SQL button).

 

[Xzyan]

MM, didn't work >.>
I'll give a bit more info.
I'm using the forgotten server for 8.54 clients

In the config.lua i have it set as:
accountManager = true
namelockManager = true
newPlayerChooseVoc = false
newPlayerSpawnPosX = 1022
newPlayerSpawnPosY = 1026
newPlayerSpawnPosZ = 6
newPlayerTownId = 1

and i have the same positions set to the acc manager in my sql database.
The server loads fine and starts up, i log into my acc manager and still get the error, any idea why?

 

[Cykotitan]

If the Account Manager has correct posx, posy, posz and town_id in database, I don't see what's wrong. Make sure that sqlType is set to "mysql" in config.lua

 

[Xzyan]

Well... haha, that was probably the problem it was set to SQlite.
I changed the type to mysql, and the database to the correct name, however now im getting the error:
"Failed connecting to the database - MYSQL ERROR: access denied for user 'root'@'localhost' <using password: no> <1045>
>.>

:::EDIT:::
nvm im dumb =P
forgot to set the pass in the config file, thanks for you help, much appreciated.