TFS 0.X Znote ACC cant logg in to account on webbsite after creating

manic91

New Member
Joined
Dec 2, 2012
Messages
6
Best answers
0
Reaction score
0
Hi! im having problems with my webbsite with alot of error codes and after creating an account on the webbsite but i cant loggin to it on the webbsite but works totally fine on the ot server :/ passwords are set to sha1 and is working fine and webbsite is set to "salt" because im runing a tfs 0.36 server


Also im getting this error code :/


Code:
string(85) "SELECT `id`, `owner`, `name`, `town_id` AS `town_id` FROM `houses` WHERE `owner` = 5;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'town_id' in 'field list'
have no idea how to fix it and i have tried my best :/
 

Mister Budex

BudexOT.com
Joined
Jun 22, 2016
Messages
1,146
Best answers
18
Reaction score
200
Passwords needs to be encrypted with sha1 to work with Znote aac change it in your config.lua and create a new account in-game.
Code:
ALTER TABLE ADD `town_id` int(11) NOT NULL DEFAULT '0',
 
OP
M

manic91

New Member
Joined
Dec 2, 2012
Messages
6
Best answers
0
Reaction score
0
@Mister Budex hey mate! thanks for your awnser i already changed all passwords and the config.lua to sha1 but cant still logg in to the Znote webbsite only create :/ and where do i put that code you wrote ? in wich folder? :)

best regards
 

sasdasxc

Member
Joined
Oct 31, 2017
Messages
64
Best answers
3
Reaction score
25
@Mister Budex hey mate! thanks for your awnser i already changed all passwords and the config.lua to sha1 but cant still logg in to the Znote webbsite only create :/ and where do i put that code you wrote ? in wich folder? :)

best regards
in phpmyadmin here:
 
Top