jDownloadsownloads.com


Author Topic: Error after upgrade to 3.9  (Read 911 times)

0 Members and 1 Guest are viewing this topic.

Offline Anthony van Houts

  • Newbie
  • *
  • Posts: 2
Error after upgrade to 3.9
« 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?

Offline ColinM

  • Moderator
  • *
  • Posts: 3.922
Re: Error after upgrade to 3.9
« Reply #1 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

Offline Anthony van Houts

  • Newbie
  • *
  • Posts: 2
Re: Error after upgrade to 3.9
« Reply #2 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

Offline ColinM

  • Moderator
  • *
  • Posts: 3.922
Re: Error after upgrade to 3.9
« Reply #3 on: 12.11.2020 16:07:22 »
Anthony
 Is www.insight2act.net
Your network?Will send you a PMColin

Offline Tazzios

  • Newbie
  • *
  • Posts: 47
Re: Error after upgrade to 3.9
« Reply #4 on: 14.11.2020 14:51:22 »
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.

Offline ColinM

  • Moderator
  • *
  • Posts: 3.922
Re: Error after upgrade to 3.9
« Reply #5 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

Offline Tazzios

  • Newbie
  • *
  • Posts: 47
Re: Error after upgrade to 3.9
« Reply #6 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.

Offline Arno

  • Administrator
  • ***
  • Posts: 12.306
    • jDownloads.com
Re: Error after upgrade to 3.9
« Reply #7 on: 14.11.2020 21:42:46 »
Quote
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.

Quote
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:
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..
« Last Edit: 15.11.2020 17:57:39 by Arno »
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline Tazzios

  • Newbie
  • *
  • Posts: 47
Re: Error after upgrade to 3.9
« Reply #8 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.

Offline Arno

  • Administrator
  • ***
  • Posts: 12.306
    • jDownloads.com
Re: Error after upgrade to 3.9
« Reply #9 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?
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline Arno

  • Administrator
  • ***
  • Posts: 12.306
    • jDownloads.com
Re: Error after upgrade to 3.9
« Reply #10 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..
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline pat

  • Newbie
  • *
  • Posts: 1
Re: Error after upgrade to 3.9
« Reply #11 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. 

Offline jenpig

  • Newbie
  • *
  • Posts: 1
Re: Error after upgrade to 3.9
« Reply #12 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.

Offline Arno

  • Administrator
  • ***
  • Posts: 12.306
    • jDownloads.com
Re: Error after upgrade to 3.9
« Reply #13 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.
« Last Edit: 02.12.2020 11:57:44 by Arno »
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!