Recent update to Joomla 3.9 will not allow access to Articles. Topic is solved

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Post Reply
User avatar
Zemplate
Joomla! Ace
Joomla! Ace
Posts: 1389
Joined: Tue Aug 13, 2013 5:55 pm
Location: Colorado
Contact:

Recent update to Joomla 3.9 will not allow access to Articles.

Post by Zemplate » Tue Nov 06, 2018 8:34 pm

I updated to Joomla 3.9.0 just a couple days ago.

When I go to edit articles, I get a blank page with this message.

Error 500 Unknown column 'a.note' in 'field list'

I can access other parts of the Admin menu, such as the Control Panel and Categories.

Can anyone give me advice on how to proceed?

 
User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 9022
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Recent update to Joomla 3.9 will not allow access to Articles.

Post by sozzled » Tue Nov 06, 2018 8:39 pm

Zemplate wrote:
Tue Nov 06, 2018 8:34 pm
When I go to edit articles, I get a blank page with this message.

Error 500 Unknown column 'a.note' in 'field list'
This means that there's a problem within the database. I don't know which database table is affected. Did you try using Manage » Database in the backend? Did this show any problems? If you cannot access this part of the backend, have a look at the file error_log in the site root folder. Are there any errors there?
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
Zemplate
Joomla! Ace
Joomla! Ace
Posts: 1389
Joined: Tue Aug 13, 2013 5:55 pm
Location: Colorado
Contact:

Re: Recent update to Joomla 3.9 will not allow access to Articles.

Post by Zemplate » Tue Nov 06, 2018 8:42 pm

Thank you.

I ran the Fix on the Manage -> Database page.

I can now access my articles.

Glad it was that easy.

oxmerre
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Nov 30, 2018 9:35 am

Re: Recent update to Joomla 3.9 will not allow access to Articles.

Post by oxmerre » Fri Nov 30, 2018 9:37 am

Thank you very much. It helped me too.

User avatar
Beata
Joomla! Ace
Joomla! Ace
Posts: 1100
Joined: Fri Mar 02, 2007 2:06 pm
Location: Lithuania

Re: Recent update to Joomla 3.9 will not allow access to Articles.

Post by Beata » Wed Feb 26, 2020 12:55 pm

Does it helped me too

rast537
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Mon Feb 16, 2015 9:33 am

Re: Recent update to Joomla 3.9 will not allow access to Articles.

Post by rast537 » Sun Mar 15, 2020 4:59 pm

Thank you so much. This is what helped me: Extensions/Manage/Database and there click the Fix button and it worked!

 

Post Reply

Return to “Migrating and Upgrading to Joomla! 3.x”