Upgrade standalone version - help needed

[pingo]

Hi

I would like to upgrade my standalone version to the latest 3.1.0 from 2.9.01.

I read upgrade_info.txt but I was not sure what is the right sql upgrade file. Further I tried with sql_standalone.txt from doc/install/3.0.0 sql folder.

Did all the the other steps in this howto eg. unpack, rename, copy files from original folder etc.

When accessing leonardo url i get this error:
Error in count items query! SELECT count(*) as itemNum FROM leonardo_flights WHERE (1=1) AND DATE_FORMAT(DATE,'%Y') = 2009 AND ( excludeFrom & 1 ) = 0 AND userID>0 AND private=0

All the menus are like dead links except login. But when login credentials are entereded the web page goes into indefinete loop.

My initial install was done by this thread:
http://leonardo.thenet.gr/support/viewt ... ?p=352#352