error with website

[wafuboe]

i have this error on the character view on znote acc

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

Unknown column 'town_id' in 'field list'

any idea how can i fix it?

 

[Limos]

Which server do you use, did you set the right server version in config.php?

 

[wafuboe]

[10/12/2014 17:35:20] The OTX Server Version: (2.90 - 4539) - Codename: (Galaxy) 8.60
i have no idea what tfs version it is sorry limos

config.php version part

// Available options: TFS_02, TFS_03
    // TFS 0.2 = TFS_02
    // TFS 0.3 = TFS_03 (If ur using 0.3.6, set $config['salt'] to false)!
    // TFS 0.4 = TFS_03
    $config['TFSVersion'] = 'TFS_02';

 

[Limos]

OTX is based on TFS 0.4, so that would be TFS_03.

 

[wafuboe]

ok i already changed to TFS_03. But still the same problem

 

[Limos]

Did you save it and restarted the website/apache?

 

[wafuboe]

Yup same issue.
Look ill quote the response from the author of the layout about exactly the same issue as mine
Peonso - "Open your characterprofile.php file search for "town_id" and replate each one for "town".

i already did that and same problem..
it is a missing table from the database perhaps?

http://otland.net/threads/znote-aac-guilcera-layout.219416/page-3

 

[Limos]

In TFS 0.3 and similar versions it's indeed called town instead of town_id.
Do you still get an error about town_id? Look if there is any you missed.

 

[wafuboe]

All "town_id" were replaced to "town'
now i get this error

string(115) "SELECT `name`, `level`, `vocation`, `lastlogin`, `online`, `sex`, `group_id`, `town` FROM `players` WHERE `id` = 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'town' in 'field list'

 

[Limos]

For the table players it should stay town_id, only for houses it should be town instead of town_id.

 

[wafuboe]

I made some movements is it okay?

anyway whatever the character i search for,it shows the data of the Acc Manager and not the character itself

 

[wafuboe]

BUMP