biow0lf / evedev-kb

Automatically exported from code.google.com/p/evedev-kb
1 stars 0 forks source link

rankmod error with last rev from 12/14 #191

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
HI !

I know that not a really issue, but rankmod works very fine with the 4.0.1.

I have updated to the last REV and now i have this error with the rankmod

WARNING [512] SQL error (Unknown column 'kll.kll_timestamp' in 'where clause'
Error on line 49 in file 
/www/htdocs/v033397/btg-corp/killboard/common/includes/class.dbnormalquery.php
PHP 5.3.8-nmm1 (Linux), EDK 4.0.1 (Crucible)
File: 
/www/htdocs/v033397/btg-corp/killboard/common/includes/class.dbnormalquery.php, 
line: 49, function: trigger_error
File: 
/www/htdocs/v033397/btg-corp/killboard/common/includes/toplist/class.base.php, 
line: 482, class: DBNormalQuery, function: execute
File: 
/www/htdocs/v033397/btg-corp/killboard/common/includes/toplist/class.base.php, 
line: 488, class: TopList_Base, function: execQuery
File: /www/htdocs/v033397/btg-corp/killboard/mods/rank_mod/init.php, line: 
1959, class: TopList_Base, function: getRow
File: /www/htdocs/v033397/btg-corp/killboard/mods/rank_mod/pilot_detail.php, 
line: 112, function: getPilotRank
File: 
/www/htdocs/v033397/btg-corp/killboard/common/includes/class.pageassembly.php, 
line: 70, function: call_user_func_array
File: 
/www/htdocs/v033397/btg-corp/killboard/common/includes/class.pageassembly.php, 
line: 37, class: pageAssembly, function: call
File: /www/htdocs/v033397/btg-corp/killboard/mods/rank_mod/pilot_detail.php, 
line: 418, class: pageAssembly, function: assemble
File: /www/htdocs/v033397/btg-corp/killboard/common/index.php, line: 289, 
function: include
File: /www/htdocs/v033397/btg-corp/killboard/index.php, line: 28, function: 
include

WARNING [512] SQL error (Unknown column 'kll.kll_timestamp' in 'where clause'
Error on line 49 in file 
/www/htdocs/v033397/btg-corp/killboard/common/includes/class.dbnormalquery.php
PHP 5.3.8-nmm1 (Linux), EDK 4.0.1 (Crucible)
File: 
/www/htdocs/v033397/btg-corp/killboard/common/includes/class.dbnormalquery.php, 
line: 49, function: trigger_error
File: 
/www/htdocs/v033397/btg-corp/killboard/common/includes/toplist/class.base.php, 
line: 482, class: DBNormalQuery, function: execute
File: 
/www/htdocs/v033397/btg-corp/killboard/common/includes/toplist/class.base.php, 
line: 488, class: TopList_Base, function: execQuery
File: /www/htdocs/v033397/btg-corp/killboard/mods/rank_mod/init.php, line: 
2005, class: TopList_Base, function: getRow
File: /www/htdocs/v033397/btg-corp/killboard/mods/rank_mod/pilot_detail.php, 
line: 112, function: getPilotRank
File: 
/www/htdocs/v033397/btg-corp/killboard/common/includes/class.pageassembly.php, 
line: 70, function: call_user_func_array
File: 
/www/htdocs/v033397/btg-corp/killboard/common/includes/class.pageassembly.php, 
line: 37, class: pageAssembly, function: call
File: /www/htdocs/v033397/btg-corp/killboard/mods/rank_mod/pilot_detail.php, 
line: 418, class: pageAssembly, function: assemble
File: /www/htdocs/v033397/btg-corp/killboard/common/index.php, line: 289, 
function: include
File: /www/htdocs/v033397/btg-corp/killboard/index.php, line: 28, function: 
include

Thats by the pilot detail : 
http://btg-corp.de/killboard/?a=pilot_detail&plt_id=13510

And by the stats -> pilot ranks : 
http://btg-corp.de/killboard/?a=corp_detail&crp_id=7522&view=rankmod_ranks

can you help me ? 

it is necessary to change code in the rankmod, when yes where^^

Original issue reported on code.google.com by MurdiMur...@gmail.com on 14 Dec 2011 at 8:24

GoogleCodeExporter commented 9 years ago
I think this is the fault here Unknown column 'kll.kll_timestamp' but i found 
nothing in the rankmod php-files about that. but my skill in coding php is 
level 1 :)

Original comment by MurdiMur...@gmail.com on 14 Dec 2011 at 8:31

GoogleCodeExporter commented 9 years ago
I can't duplicate this, but it looks like you are using a slightly different 
version of rank mod. Could you try again with the last version that I posted 
for EDK4?
http://dev.kitexp.info/edk/downloads/rank_mod_EDK4.zip

Also, go to admin, cache and enable 'Halt on SQLError' to capture the actual 
sql query. (You may not want to leave it that way since it will also stop the 
page loading.)

Original comment by kovellia on 15 Dec 2011 at 4:30

GoogleCodeExporter commented 9 years ago
with the last rev problem solved :) I do not know why but it's back and that's 
the important thing.

Original comment by MurdiMur...@gmail.com on 15 Dec 2011 at 7:31

GoogleCodeExporter commented 9 years ago
Glad it's fixed! If the problem shows up again, feel free to reopen this issue.

Original comment by kovellia on 15 Dec 2011 at 11:29