Solved Znotes 1.5 and TFS 1.1 #Houses don't load to sql

[Alkenix]

Hey Guys.

After about an hour of research I finally gave up and write this thread.
I got my Znotes 1.5 to work under Windows, but when I go on "Houses" and click "Fetch houses" it says:
Failed to fetch data from sql->houses table

Can someone help me with it?

My config.php (Same Towns and IDs as in Remeres)

    // Town ids and names: (In RME map editor, open map, click CTRL + T to view towns, their names and their IDs.
    // townID => 'townName' etc: ['3'=>'Thais']
    $config['towns'] = array(
        1 => 'Rook',
        2 => 'Malor',
        3 => 'Ikos',
    );

My config.lua

-- MySQL
sqlType = "mysql"
mysqlHost = "localhost"
mysqlPort = 3306
mysqlUser = "******"
passwordType = "plain"
mysqlPass = "******"
mysqlDatabase = "otserver"
sqlFile = "schema.sql"
mysqlSock = ""

For sure, the server is started and i'll did already alpha-tested acc creation with friends (works fine).
But not the houses-sql with my world-house.xml.

If there is anybody outthere to help me fix this problem, please help me.

#Edit: Deleted the sql user-name and password.

 

[Alkenix]

Seems like nobody is able to fix this problem?
Common...This must be a nightmare! :O

 

[margoh]

Are houses in your db table? Or it's blank? If it's blank, you need to wait for server save. After Server Save, houses table will be filled.

 

[Tarek]

I recomend to change password. To your phpmyadmin and change passwordType to "sha1", And you need to have the server online to see changes.

 

[Alkenix]

I've got my houses in the .xml, but not in my db...The table is blank.
Oh yes. ... I will, ofc. #geniusME
Mh..Got no Server Save in my Config.lua..
I'll add it and w8 for it.

 

[Alkenix]

Thanks! It finally works after I uses /save.
A Server Save is activated as well.
Thx Thx Thx