Problems With mysql on XBtit

[kyuky]

I get an error from mysql!! And I don't know how to resolve it! someone help me pls!!

The error is:

MySQL query error!        

Error: Unknown column 'mtime' in 'field list'
Query: INSERT INTO xbt_files (info_hash, mtime, ctime) SELECT UNHEX(info_hash), unix_timestamp(), unix_timestamp() FROM xbt_files WHERE UNHEX(info_hash) NOT IN (SELECT info_hash FROM xbt_files) AND external='no'

[KiD]

Originally Posted by kyuky

I get an error from mysql!! And I don't know how to resolve it! someone help me pls!!

The error is:

MySQL query error!        
 
 Error: Unknown column 'mtime' in 'field list'
Query: INSERT INTO xbt_files (info_hash, mtime, ctime) SELECT UNHEX(info_hash), unix_timestamp(), unix_timestamp() FROM xbt_files WHERE UNHEX(info_hash) NOT IN (SELECT info_hash FROM xbt_files) AND external='no'

Think you miss the "mtime column" in your datebase.... try remoce that par from query and se what happens..! Or try to find it in your sql..

[kyuky]

But this settings are made by the site when I check "Use xbtt as backend?"
I let the default settings to tracker options.

And I don't understand another part, configuring XBT, more exactly at this part:
insert into xbt_files (info_hash, mtime, ctime) values ('<info_hash>', unix_timestamp(), unix_timestamp()); // insert
update xbt_files set flags = 1 where info_hash = '<info_hash>'; // delete

I've been trying to insert this line to mysql on xbt database, but mysql says some erros!

Have some ideas?