O.K., i'll try not to confuse you...
Two machines. One runs Xampp 165a. The other uns Xampp 168a.
On machine 1 is installed elxis 2008.1 r2204. IOS_downloads installed ok, cats have been done, files have been added, but when one hits the download link in menu, he gets this on top of the screen (above header):
mysql Σφάλμα  : EXECUTE
Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,1' at line 1
After the message, files are shown and can be downloded correctly. The whole page follows.
On machine 2 is installed elxis 2008.1 r2204 patched to 2218.
No installation can be done. No error messages appear.
On machine 2 is installed elxis 2008.1 r2218 also.
Here the situation is same as machine 12008.1 r2204
On machine 2 is installed elxis 2008.1 r2245 also.
No installation can be done.No error messages appear too.
On my live site [rev2204, Linux 2.6.18, PHP: 5.1.6 (apache2handler), mysql 5.0.45], after uploading folders /components/com_downloads, /administrator/components/com_downloads, importing elx_downloads_cats
and importing the changes to elx_components, as they appear on machine 1 elxis 2008.1 r2204 (as you can see, I cant install the component directly from elxis interface), the result was the same... :'(
It looks like a nice component anyway... and I am sure people will love it too.