|
#1
|
|||
|
|||
Problems With mysql on XBtit
I get an error from mysql!! And I don't know how to resolve it! someone help me pls!!
The error is: Code:
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' |
#2
|
||||
|
||||
Quote:
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..
__________________
Regards KiD ThemeFactory - Tracker Related Skins, Graphic & Support Visit us here: http://www.themefactory.net |
#3
|
|||
|
|||
re
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? |
Tags |
mysql , problems , xbtit |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MySQL Tuning | Fynnon | Downloads | 3 | 6th April 2010 13:23 |
Mysql error | majio | TBDev | 1 | 21st July 2009 16:38 |
MySql help! | LoaT | Yuna Scatari Edition (YSE) | 5 | 30th January 2009 21:10 |
PHP/MySql/HTML/CSS/PhotoShop ( your all in one man ) | iKiller | Sell & Buy | 4 | 8th October 2008 20:30 |
problem with mysql | nako75018 | Template Shares | 5 | 21st July 2008 19:47 |