Elxis CMS Forum

Extensions => Components => Topic started by: muharihar on December 25, 2008, 02:29:27

Title: IOS Download Error: Front End Download Component (SOLVED)
Post by: muharihar on December 25, 2008, 02:29:27

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 :D.
so anyone can help me....

thanks.....

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

Title: Re: IOS Download Error: Front End Download Component
Post by: Farhad Sakhaei on December 25, 2008, 09:31:42

Are you using XAMPP ?

Title: Re: IOS Download Error: Front End Download Component
Post by: muharihar on December 26, 2008, 12:06:30

Quote from: Farhad Sakhaei on December 25, 2008, 09:31:42

Are you using XAMPP ?

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

thanks.....

Title: Re: IOS Download Error: Front End Download Component
Post by: Farhad Sakhaei on December 26, 2008, 12:10:24

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

Title: Re: IOS Download Error: Front End Download Component
Post by: muharihar on December 26, 2008, 13:17:52

thanks farhad....

i will try it on my live sit...  :)

Title: Re: IOS Download Error: Front End Download Component (SOLVED)
Post by: muharihar on December 28, 2008, 10:30:42

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

Title: Re: IOS Download Error: Front End Download Component (SOLVED)
Post by: Farhad Sakhaei on December 28, 2008, 14:17:26

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

Title: Re: IOS Download Error: Front End Download Component (SOLVED)
Post by: datahell on December 28, 2008, 18:06:11

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.

Title: Re: IOS Download Error: Front End Download Component (SOLVED)
Post by: Farhad Sakhaei on January 01, 2009, 01:43:30

@ 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  ;)

Title: Re: IOS Download Error: Front End Download Component (SOLVED)
Post by: datahell on January 01, 2009, 13:22:48

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!