IOS Download Error: Front End Download Component (SOLVED)

[muharihar]

hi all...
IOS Download Component is a great component, so i must use it. 
but i have a problem with IOS Download Component.
for more info, this is my error problem:
---------------------------------------------------------------------------------------------
mysql Error [1064] : EXECUTE
URI: index.php?option=com_downloads&task=category&cid=1&Itemid=44
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
LIMIT 0,1

debug info:
..\web\includes\Core\database.php:510
..\web\components\com_downloads\downloads.html.php:372
..\web\components\com_downloads\downloads.html.php:92
..\web\components\com_downloads\downloads.php:319
..\web\components\com_downloads\downloads.php:67
..\web\components\com_downloads\downloads.php:1347
..\web\index.php
----------------------------------------------------------------------------
i use elxis 2008.1 version 2245. and i always waiting for elxis 2008.2, i'm sure it would be great and more powerfull .
so anyone can help me....

thanks.....

-------------------------
muharihar
-- never give up and just "nrimo"
-- http://omahijo.net/oi

[Farhad Sakhaei]

Are you using XAMPP ?

[muharihar]

Are you using XAMPP ?

yes... your right, i use XAMPP. 
what wrong with it? 

thanks.....

[Farhad Sakhaei]

There is a problem with XAMPP , You won't have any problem on live site ... 

[muharihar]

thanks farhad....

i will try it on my live sit... 

[muharihar]

thanks farhad...
your are right.... it's no problem in live site...

[Farhad Sakhaei]

Thanks to Elxis men for this great tool 
I'm nobody

[datahell]

Yes, but it is weird, I have no XAMPP to test why XAMPP generates this error. I searched the component and it is absolutely fine, no problem, not a single error. This error only appears under XAMPP. If anyone has XAMPP and can debug the component to find out why it generates this error please report it here in order to fix it.

[Farhad Sakhaei]

@ muharihar:

It was not the XAMPP problem
File : /components/com_downloads/downloads.html.php
Line : 368 and 532 (Both lines are same)

Replace :
$quer2 = "SELECT id FROM #__menu WHERE link='index.php?option=com_user&task=list'"

With :
$query2 = "SELECT id FROM #__menu WHERE link='index.php?option=com_user&task=list'"

Good luck 

[datahell]

Thanks farhad, I updated IOS Downloads on elxis-downloads.com.
The problem only appeared when you had SEO PRO disabled. That's why I could nt find the error!