Error after upgrade to 3.9

[Anthony van Houts]

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?

[ColinM]

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

[Anthony van Houts]

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

[ColinM]

Anthony
Is www.insight2act.net
Your network?Will send you a PMColin

[Tazzios]

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.

[ColinM]

Tazzios
That is very interesting.  Are you saying it could not be enabled in jD?  But you had to enable in the database.Colin

[Tazzios]

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.

[Arno]

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.

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.

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.

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:

"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..

[Tazzios]

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.

[Arno]

Hi,
thanks for the reply. I will try to reproduce it here. Use you non-latin (ASCII-7) characters for your category titles?

[Arno]

Hi,
please could you send me the result?

"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..

[pat]

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. 

[jenpig]

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.

[Arno]

@ 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.

[Arno]

Should now be solved finally with jDownloads 3.9.7.3.