Error 500 after upgrade

[pranky]

hello

I've upgraded Jdownloads from 3.2 to 3.9.7.2.
I created the 2 directories /downloads and /downloads/tempzipfiles (chmod 777) but I on frontend I have this error:

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

If I check download area it tells that the main folder doesn't exist

Please what can I do to fix this?

thank you

[ColinM]

Hi


From what you describe it sounds as if folder jdownloads in the root failed to get created or perhaps has insufficient priveleges (chmod)
First please look at Joomla! System - Global Configuration - Server tab option 'Path to Temp Folder'  This will  point to your Joomla 'base' directory with /tmp added at the end

  Now in jD Options - Path Settings tab - Upload directory path.  This should be "Joomla 'base'  directory with /jdownloads added at the endCheck the chmod of that directory.
Also could you please advise which database  and its version your site is using.  You need either MySQL 5.7+ or Maria DB 10.2+ or PostGreSQL 9.5+Colin

[pranky]

well...

I solved simply restoring a backup made on a copy of the site in a subdirectory where the upgrade had been successfull.

(Anyway the settings where the same on both site...  I really do not understand)

[gpraceman]

I am in the same boat.  It seems that I missed the database version requirement (I have MySQL 5.5), yet the upgrade to jD 3.9 was able to go through.  I'm trying to see if I can get my host to upgrade MySQL.

[gpraceman]

Actually, my host says I am running MariaDB version 10.4.12.  I'll create a separate thread on my issue.