Hi all
I just want to inform you about a known bug in jOpenSim 0.2.7 which will be fixed in the next version:
When selecting the "Money" tab in the inworld account page and show all transactions within 1 year, the list is empty.
For those who urgently need to fix this before my next version is released (that will take a few weeks still I think), there is following solution:
Open /administrator/components/com_opensim/models/opensim.php in a text editor and go to line 984 which should be
if($days == 365) $query->where('AND #__opensim_moneytransactions.`time` >= UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 YEAR');To correct this bug, change it to
if($days == 365) $query->where('#__opensim_moneytransactions.`time` >= UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 YEAR))');
Greetz
FoTo50
