Solved TFS V.04_DEV

[Fileey]

Hello, got my server up hosted but I got a console problem whenever someone logs in or creates an account it goes

And when I restart the server everyone is level 8 spawning in temple, even when I relog I spawn in temple with my GM character, with the outfit changer up.
Nothing is saving please help me

 

[vTune]

Something wrong with either ur DB connection or the DB itself, is my guess.

 

[Fileey]

That's what I've imported, Mysql.sql right?

 

[Fileey]

Something wrong with either ur DB connection or the DB itself, is my guess.

Should I get a new database to import into phpmyadmin then?

 

[dominique120]

Are you sure that you imported the right schema into your database?

Should I get a new database to import into phpmyadmin then?

I think this would be best

 

[vTune]

Give it a try, if you can't get it to work. PM me and I can try to help you in teamviewer or something.

That's what I've imported, Mysql.sql right?

or forgottenserver.sql

 

[Fileey]

Are you sure that you imported the right schema into your database?

I think this would be best

Does it matter which one? I'm hosting a server with RL map

 

[dominique120]

Does it matter which one? I'm hosting a server with RL map

Yes it does because the schema is prepared specifically for your server. If you are using TFS 1.0 you cant just use a schema from TFS 0.4 or the other way around.

 

[Fileey]

Give it a try, if you can't get it to work. PM me and I can try to help you in teamviewer or something.

or forgottenserver.sql

There no forgottenserver.sql only forgottenserver.

 

[dominique120]

You will probably find a file called mysql.sql in a folder called schemas or in the same folder as config.lua

 

[Fileey]

You will probably find a file called mysql.sql in a folder called schemas or in the same folder as config.lua

I find nothng with .sql outside the folder schemas. Do anyone of you have an existing working one ?

 

[vTune]

I find nothng with .sql outside the folder schemas. Do anyone of you have an existing working one ?

The one inside shemas should do the trick.

 

[dip'ah]

"cast" is missing from your tables.
add it to the player's table.

 

[vTune]

"cast" is missing from your tables.
add it to the player's table.

This could be it.

Try executing this

ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0',
ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0',
ADD  `castDescription` VARCHAR( 255 ) NOT NULL

 

[dip'ah]

This could be it.

Try executing this

ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0',
ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0',
ADD  `castDescription` VARCHAR( 255 ) NOT NULL

Yeah, I would give the sql query, but I had no idea if it was int or varchar or wtf.. I'm not working with TFS at all haha xD

 

[Fileey]

This could be it.

Try executing this

ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0',
ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0',
ADD  `castDescription` VARCHAR( 255 ) NOT NULL

Thank you alot ! REP