jDownloads Support Forum

Older Versions => jDownloads 3.2 (Support ended) => Topic started by: h007 on 25.10.2019 20:21:01

Title: Unknown column 'id' in 'where clause' 1054
Post by: h007 on 25.10.2019 20:21:01
hi 

i am using 3.2.65 

after update to 3.2.65 

i have Unknown column 'id' in 'where clause' 1054 error at download page

please help

how  can i solve this.

tnx

Title: Re: Unknown column 'id' in 'where clause' 1054
Post by: h007 on 26.10.2019 00:23:47
when i use jd 3.9 it works !!!

when i click on download bottom i get empty file or damaged file on download page (jd 3.9 beta)
Title: Re: Unknown column 'id' in 'where clause' 1054
Post by: h007 on 27.10.2019 19:41:38
it seems that my issue is related to allow_url_include function !


allow_url_include is On. This could allow an attacker to execute remote code, if you have PHP scripts that perform include() and require() without sanitization. We recommend this setting be Off.



what do you think ?
Title: Re: Unknown column 'id' in 'where clause' 1054
Post by: Arno on 30.10.2019 11:52:06
Quote from: h007 on 25.10.2019 20:21:01
after update to 3.2.65 
i have Unknown column 'id' in 'where clause' 1054 error at download page
With 'download page do you mean the 'summary' page?

Have you this error message by every Download or only by special ones which use a file from another Download?

is your jDownloads installation untouched? I mean not modified?

Fact is that I cannot reproduce it here at the moment. So maybe a result from a special status?
So more informations could help.

Quoteit seems that my issue is related to allow_url_include function !
Why do you think this? Please share your results with us.
Title: Re: Unknown column 'id' in 'where clause' 1054
Post by: h007 on 30.10.2019 12:16:29
hi Arno

i have this error at the all page like this

http://www.jdownloads.com/index.php/downloads/summary/6-jdownloads/2-jdownloads-3-2.html

i have this problem with elder version of jd
but jd 3.9 beta solves this problem!

i am confused i dont know how can i solve that.

i have to use jd3.9 in my live site , although it has downloading issue from external host or storage

Title: Re: Unknown column 'id' in 'where clause' 1054
Post by: Arno on 30.10.2019 12:28:05
Hi,
all your Downloads use only external file URLs?
What is your PHP version?
With v3.2.64 all works correct as expected?
Title: Re: Unknown column 'id' in 'where clause' 1054
Post by: Arno on 30.10.2019 12:39:01
Useful could be the complete debug result. So please activate for a short test the Joomla debug option and send me the error output part via PM.
Thanks.
Title: Re: Unknown column 'id' in 'where clause' 1054
Post by: h007 on 30.10.2019 12:39:26
yes all use external link,

php version is 7.3


i installed v3.2.63 again for testing, but it didn't work.

just 3.9 solves the problem,
Title: Re: Unknown column 'id' in 'where clause' 1054
Post by: h007 on 30.10.2019 12:53:16
Quote from: h007 on 30.10.2019 12:39:26
yes all use external link,

php version is 7.3


i installed v3.2.63 again for testing, but it didn't work.

just 3.9 solves the problem,

thank you arno

it is late to solving v3.2.65 issue, i had to use jd 3.9 beta in my live site and i am trying to solve the downloading from external storage problem at here
http://www.jdownloads.com/index.php/support-forum.html?topic=11787.0