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

Need help with the Administration of your Joomla! 3.x site? This is the spot for you.

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.
Post Reply
RemiAdem45
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Sat Aug 18, 2018 10:11 am

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

Post by RemiAdem45 » Fri Nov 16, 2018 10:51 am

Hello

I was writing a new article for my website and after I save it and quit the editor
I had this error: 500 Unknown column 'a.note' in 'field list'
And now it is impossible to have an acces to the article's list

I use 3.9 joomla version.

Any idea?

User avatar
pmleconte
Joomla! Explorer
Joomla! Explorer
Posts: 339
Joined: Fri Mar 17, 2017 12:55 pm
Location: France

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

Post by pmleconte » Fri Nov 16, 2018 11:37 am

Hi,

This is a common problem with 3.9 (new field in database).

Please check viewtopic.php?f=710&t=966980

Pascal
If anything can go wrong, it will.
https://www.conseilgouz.com/en

ICTeducator
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sat Nov 24, 2018 3:45 am

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

Post by ICTeducator » Sat Nov 24, 2018 4:01 am

Hi, Here is the fix.
I had this problem. This is how I fixed it.

Go to Extensions -> Manage -> Database.
Now you can see the listed errors in your database. Go and click on the FIX button at the top.
That's it. Sit back and wait to see the problem get fixed.

user1976
Joomla! Apprentice
Joomla! Apprentice
Posts: 20
Joined: Wed May 14, 2014 8:57 pm
Contact:

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

Post by user1976 » Sat Dec 29, 2018 12:28 pm

Dear ICTeducator,

Many thanks for this fix. All done!!

kirkm
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Jun 19, 2008 7:53 pm
Location: Gresham, OR
Contact:

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

Post by kirkm » Sat Feb 23, 2019 1:58 am

Thanks ITCeducator! Worked for me too!


Post Reply

Return to “Administration Joomla! 3.x”