Error 500 Unknown column 'a.note' in 'field list' Topic is solved

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: 365
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!

alper2tr
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Fri Aug 12, 2011 7:02 pm

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

Post by alper2tr » Thu Mar 28, 2019 11:42 pm

hi
İ HAVE THE SAME PROBLEM AND STRUGGLİNG Last one week.i tried to fix from fix btton plus phpmy admin
but no success!it gives me error below when i press fix button in extension manager ;

is there a way i can fix manually or any suggestion ?
thanks

Database schema version (3.8.9-2018-06-19) does not match CMS version (3.9.3-2019-02-07).
Database update version (3.8.11) does not match CMS version (3.9.4).
Table 'po_redirect_links' does not have column 'hits'. (From file 2.5.5.sql.)
Table 'po_redirect_links' does not have column 'header'. (From file 3.4.0-2014-09-16.sql.)
Table 'po_redirect_links' should not have index 'idx_link_old'. (From file 3.5.0-2016-03-01.sql.)
Table 'po_redirect_links' has the wrong type or attributes for column 'old_url' with type VARCHAR(2048). (From file 3.5.0-2016-03-01.sql.)
Table 'po_redirect_links' has the wrong type or attributes for column 'new_url' with type VARCHAR(2048). (From file 3.5.0-2016-03-01.sql.)
Table 'po_redirect_links' has the wrong type or attributes for column 'referer' with type VARCHAR(2048). (From file 3.5.0-2016-03-01.sql.)
Table 'po_redirect_links' does not have index 'idx_old_url'. (From file 3.5.0-2016-03-01.sql.)
Table 'po_redirect_links' has the wrong type or attributes for column 'new_url' with type VARCHAR(2048). (From file 3.6.0-2016-04-06.sql.)
Table 'po_redirect_links' has the wrong type or attributes for column 'comment' with type varchar(255). (From file 3.7.0-2017-02-15.sql.)
Table 'po_privacy_requests' does not exist. (From file 3.9.0-2018-05-02.sql.)
Table 'po_action_logs' does not exist. (From file 3.9.0-2018-05-05.sql.)
Table 'po_action_logs_extensions' does not exist. (From file 3.9.0-2018-05-05.sql.)
Table 'po_action_log_config' does not exist. (From file 3.9.0-2018-05-05.sql.)
Table 'po_privacy_consents' does not exist. (From file 3.9.0-2018-05-24.sql.)
Table 'po_content' does not have column 'note'. (From file 3.9.0-2018-06-02.sql.)
Table 'po_privacy_consents' does not have column 'state'. (From file 3.9.0-2018-08-12.sql.)
Table 'po_session' has the wrong type or attributes for column 'session_id' with type varbinary(192). (From file 3.9.0-2018-08-28.sql.)
Table 'po_session' has the wrong type or attributes for column 'guest' with type tinyint(3) unsigned. (From file 3.9.0-2018-08-28.sql.)
Table 'po_session' has the wrong type or attributes for column 'time' with type int(11). (From file 3.9.0-2018-08-28.sql.)
Table 'po_action_logs_users' does not exist. (From file 3.9.0-2018-09-04.sql.)
Table 'po_action_logs' does not have index 'idx_user_id'. (From file 3.9.0-2018-10-15.sql.)
Table 'po_action_logs' does not have index 'idx_user_id_logdate'. (From file 3.9.0-2018-10-15.sql.)
Table 'po_action_logs' does not have index 'idx_user_id_extension'. (From file 3.9.0-2018-10-15.sql.)
Table 'po_action_logs' does not have index 'idx_extension_item_id'. (From file 3.9.0-2018-10-15.sql.)
Table 'po_privacy_requests' should not have index 'idx_checkout'. (From file 3.9.0-2018-10-20.sql.)
Table 'po_privacy_requests' should not have column 'checked_out'. (From file 3.9.0-2018-10-20.sql.)
Table 'po_privacy_requests' should not have column 'checked_out_time'. (From file 3.9.0-2018-10-20.sql.)

alper2tr
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Fri Aug 12, 2011 7:02 pm

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

Post by alper2tr » Fri Mar 29, 2019 12:33 am

hi Again

i have fixed the problem: first i created a new joomla install on another domain.so in phpmyadmin, i copied the
_redirect_links(which was my main issue) and i imported it into my other domain via php my admin.NOte:
of course i had to change relevant information(db name and suffix etc...) inside the php before update.
ALSO; a script helped me for update of the missing joomla core i give you the link below;

https://gist.github.com/mbabker/d7bfb4e ... 3607f89281

thank you


Post Reply

Return to “Administration Joomla! 3.x”