Error:1054 Unknown column 'a.file_id' when clicking the fron - [Solved in 3.9.5]

[GODpleasers]

Error: 1054

Unknown column 'a.file_id' in 'field list'



when clicking the files page from the main page.
(Please See attached images  jdownlaoddbugpart1 (Circled in red)  first and and then  jdownlaoddbugpart2.)

[Ingwio]

  bei mir kommt der Fehler bei allen nach dem Update erstellten Downloads !

1054 - Unknown column 'file_id' in 'field list'

[GODpleasers]

Hello any one there how can this be fixed?

[ColinM]

Hi
The a.file_id was the file id reference in the v3.2 series.  For jd v3.9 series it is just a.id to have better Joomla! compatibility

So it looks as if a old plugin or module is being used that has not been upgraded.

So please advise which version of jD you are using please.  Also which version of Joomla
I presume you did an upgrade from a jd3.2 to a jD3.9  - is that correct?

Did you see the article about upgrading from 3.2 to 3.9https://www.jdownloads.net/documentation-for-v3-9/getting-started-v3-9/upgrading-from-jdownloads-3-2-to-3-9
It mentions several extensions in the Third Party Extensions section Are you using any of the followingAlta User Points (if you are using Alpha User Points please switch to Alta User Points)JCommentsKommentoComunity BuilderAcymailing
There are upgrades available for all of the above
Colinm

[GODpleasers]

We are using jDownloads Version 3.9.1 and Joomla! 3.9.20 


The only 2 plugins on that list we are using is jcomments (witch we disabled and it still gave that error) and community builder (wich we deleted and it still gave tat error).   

And yes that is correct we  did an upgrade from a jd3.2 to a jD3.9.   

Any how if we give you a administrator account can you please log on ad take a look?

[ColinM]

Hi
I have just sent you a private message - so please reply using that with super user login details and I will look into it further.After uninstalling Community Builder did you log out and then log back inAlso sometimes one has to clear the cache
Colin

[GODpleasers]

We sent you a message with login details thanks for your help.

[GODpleasers]

Also beside  the Error: 1054

We see that the down load shows up when it is not set to public. Can that be fixed so it is hidden till we set it?
We might go back to the previous version... It worked better.

[ColinM]

Hi
I have sent you a PM.The troublsesome Download has a view Acces of Super Users so only Super users are able to see it.  When looking at your site it might have been set for a short period to Public or Registered as I tested various things
Your site does have Community Builder, JComments and AcyMail installed so they do need upgrading installed.  I can help you do that if you like. Please let me know.
Their old Plugins will still be active and being called by Joomla!.
Reverting back to the previous jD 3.2 series is not simple because of the database changes - it would require much more effort than just updating the other components. Of course  you could do it through an Akeeba backup but you would need to redo all your latest changes again.
Colin

[Arno]

Hi Ingwio,

bei mir kommt der Fehler bei allen nach dem Update erstellten Downloads !

1054 - Unknown column 'file_id' in 'field list'

könntest du mir einen admin Zugang via PM senden?
Oder einmal die Joomla Debug Option in den Globalen Einstellungen aktivieren und anschließend noch einmal eine solche Seite aufrufen?
Eventuell hätten wir dann eine etwas genauere Fehlermeldung.

[Arno]

A few general notes:
1) I think not that this can be a jDownloads bug. I'm pretty sure that the reason for this issue is a third-party add on.

2) Before a user can upgrade he will see a special upgrade warning. This described in detail what happens by the upgrade process and what he have to check first. Sad to say, but some users seems not to read this really!

3) So we would improve this and get more users attention we added a special users action that the user must confirm the upgrade explicitly.

More is not possible!

[ColinM]

@GODPLEASERS
Please see the PMs for details of a stable situationLike Arno think there is a need to update the externals, especially JComments.
Colin

[GODpleasers]

I have sent you a PM.The troublsesome Download has a view Acces of Super Users so only Super users are able to see it.  When looking at your site it might have been set for a short period to Public or Registered as I tested various things
Your site does have Community Builder, JComments and AcyMail installed so they do need upgrading installed.  I can help you do that if you like. Please let me know.

Yes please help us do this.

[Ingwio]

Moin Arno,








ich habe die jdownloads Version erstmal wieder auf Version 3.2 zurückgesetzt. Ich werde es die Tage nochmal versuchen und wenn es nicht klappt, schicke ich dir per PN einen Admin-Zugang. Dummerweise hatte ich das Plugin für jcomments nicht ersetzt und so könnte hier die Fehlerquelle liegen.

[larry007]

Hallo, ich glaube ich habe ein Fehler gemacht.

Leider habe ich auf meiner joomla 3.9.20 das Update für jDownloads 3.9.1 draufgemacht. Jetzt habe ich diese o.g. Fehlermeldungen.

Im übrigen habe ich keine Software die in dem Updateleitfaden zu lesen ist installiert.
In der SQL Datenbank sind entsprechende Backups (alte Version und neue Version von jDownloads) vorhanden.

Könnte mir bitte jemand helfen, danke.