jDownloads Support Forum

jDownloads for Joomla 3.x => jDownloads 3.9 (Support ended) => Bugs => Topic started by: Anthony van Houts on 09.11.2020 15:16:24

Title: Error after upgrade to 3.9
Post by: Anthony van Houts on 09.11.2020 15:16:24
After the upgrade to version 3.9 the frontend doesn't work anymore.
As soon as "downloads" need to be presented following error is shown:
"500 - 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 '' at line 17".

A list of categories still works fine.

During the upgrade the procedure complained about the categor "uncategorised" and the downloads in that category vanished after the upgrade, in the backend. But I can live with that; and I don't know whether it's related to the occurring error.

Any ideas to solve this?
Title: Re: Error after upgrade to 3.9
Post by: ColinM on 09.11.2020 16:39:26
Hi
A few things come to mind.Do you have a top level category called Uncategorised  If not please create on in the back end.
Also see what other top level categories yo may have and look for anything 'unusual'
In the Options - Frontend tab try setting 'Display Category list box in Header' to No.
I will also send you a PM
Colin
Title: Re: Error after upgrade to 3.9
Post by: Anthony van Houts on 11.11.2020 18:56:01
Hi,

Your tips worked.
All downloads are shown again in the list. Thanks.
But now I've got "next problem": in case I try a download, I get following error:

"Deze pagina werkt nietwww.insight2act.net kan dit verzoek momenteel niet verwerken.
HTTP ERROR 500"

Kind regards,
Anthony
Title: Re: Error after upgrade to 3.9
Post by: ColinM on 12.11.2020 16:07:22
Anthony
Is www.insight2act.net
Your network?Will send you a PMColin
Title: Re: Error after upgrade to 3.9
Post by: Tazzios on 14.11.2020 14:51:22
Quote from: ColinM on 09.11.2020 16:39:26
Hi
A few things come to mind.Do you have a top level category called Uncategorised  If not please create on in the back end.
Also see what other top level categories yo may have and look for anything 'unusual'
In the Options - Frontend tab try setting 'Display Category list box in Header' to No.
I will also send you a PM
Colin
I had the same error the category existed but was disabled after enabling (with phpmyadmin) it worked.
Title: Re: Error after upgrade to 3.9
Post by: ColinM on 14.11.2020 15:08:07
Tazzios
That is very interesting.  Are you saying it could not be enabled in jD?  But you had to enable in the database.Colin
Title: Re: Error after upgrade to 3.9
Post by: Tazzios on 14.11.2020 16:16:30
I did an restore of the site the reproduce the error.
When i try the enable it in the category list view i get the following
"Waarschuwing
Categorieën map niet gevonden zodat het niet mogelijk is deze categorie: 9 te publiceren."
And is stays disable.

But when i open the edit page and set in on enabled there it works fine.
I tested it with other folders and same thing happens.

So i think this is an other bug that you cannot enable folders from the list view, disabling works fine so i think the 'does the folder exist check'goes wrong.
Title: Re: Error after upgrade to 3.9
Post by: Arno on 14.11.2020 21:42:46
QuoteWhen i try the enable it in the category list view i get the following
"Waarschuwing
Categorieën map niet gevonden zodat het niet mogelijk is deze categorie: 9 te publiceren."
And is stays disable.
This is correct, because the system first checks whether the corresponding category folder exists. In your case it does not seem to exist.
You can easy check this with a monitoring scan.

QuoteSo i think this is an other bug that you cannot enable folders from the list view, disabling works fine so i think the 'does the folder exist check'goes wrong.
We don't have anyone else who has had problems with it in recent years. So it would really surprise me. But I will check it again.
Could you please post here a pic from your folder settings? See pic.

Edit:
Quote"500 - 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 '' at line 17".
Have you tried to activate the Joomla debug option to get maybe a more detailed error message? Important is here in which file is meaned here the line 17..
Title: Re: Error after upgrade to 3.9
Post by: Tazzios on 15.11.2020 19:32:47
My settings are:
yes no no yes no no no

If i create an new folder and delete it i do not get the error. Currently i have only a production so i cannot delete more folders. ;)

If there are others with this problem the workaround is easy go to the edit page. So it is not a big issue, if it exist at all at other people.
Title: Re: Error after upgrade to 3.9
Post by: Arno on 15.11.2020 23:24:27
Hi,
thanks for the reply. I will try to reproduce it here. Use you non-latin (ASCII-7) characters for your category titles?
Title: Re: Error after upgrade to 3.9
Post by: Arno on 17.11.2020 21:12:42
Hi,
please could you send me the result?

Quote
Quote"500 - 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 '' at line 17".
Have you tried to activate the Joomla debug option to get maybe a more detailed error message? Important is here in which file is meaned here the line 17..
Title: Re: Error after upgrade to 3.9
Post by: pat on 18.11.2020 23:51:43
Hi.  I've been encountering the same problems.


1) Uncategorised category doesn't get created properly during the upgrade.  If I go into the categories section of the control panel and edit the Uncategorised category, change the status to publish and save the entry, then it works properly.  By the way, I encounter a similar problem with any new category that I create from the control panel.  The same work around works for the new categories that I create.

2) Front end SQL error after the upgrade when going into jDownloads.  Being as I have a test instance on my server, I was able to set the debug on and get the debug information.  By the way, I did the set the 'Display Category list box in Header' to No workaround suggested earlier in the discussion and it got rid of the front end error. 
Title: Re: Error after upgrade to 3.9
Post by: jenpig on 02.12.2020 10:09:20
I'm having the same error 500 issue after upgrading and the upgrade couldn't create the uncategorised folder. I have tried publishing the un categorised folder in the list view but I'm still getting the same sql error.
Title: Re: Error after upgrade to 3.9
Post by: Arno on 02.12.2020 11:54:36
@ pat:
excuse me I had not seen your posting before.  :-[

@ jenpig:
I will check what happens here. Give me a few hours.

It seems that this problem occurs only with very few users.
Title: Re: Error after upgrade to 3.9
Post by: Arno on 22.03.2021 12:31:45
Should now be solved finally with jDownloads 3.9.7.3.