Error 1054 Unknown column 'b.sectionid' in 'field list'

General questions relating to Joomla! 3.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Locked
mkrokos
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Fri Nov 02, 2012 10:23 am

Error 1054 Unknown column 'b.sectionid' in 'field list'

Post by mkrokos » Sat Jan 09, 2016 11:32 am

When I try to edit any article from the backend or when I try to access it from the frontend menu, I get this error:

Code: Select all

1054 Unknown column 'b.sectionid' in 'field list' SQL=SELECT b.id,b.alias,b.catid,cc.alias as catalias,b.sectionid ,CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(':', b.id, b.alias) ELSE b.id END as slug ,CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE b.catid END as catslug FROM `r2a8l_content` as b LEFT JOIN r2a8l_categories AS cc ON cc.id = b.catid WHERE (b.id='36');
My Joomla is version 3.4.8

Here is the Forum Post Assistant result:
Problem Description :: Forum Post Assistant (v1.2.4) : 9th January 2016 wrote:1054 error
Forum Post Assistant (v1.2.4) : 9th January 2016 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.4.8-Stable (Ember) 24-December-2015
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Writable (644) | Owner: 519 (uid: /gid: ) | Group: 530 (gid: ) | Valid For: 3.4
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 0 | SEF ReWrite: 1 | .htaccess/web.config: Yes | GZip: 0 | Cache: 0 | FTP Layer: 0 | SSL: 0 | Error Reporting: maximum | Site Debug: 0 | Language Debug: 0 | Default Access: 1 | Unicode Slugs: 0 | Database Credentials Present: Yes

Host Configuration :: OS: Linux | OS Version: 2.6.32-573.12.1.el6.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate | Doc Root: /home/digimous/public_html | System TMP Writable: Yes

PHP Configuration :: Version: 5.6.16 | PHP API: apache2handler | Session Path Writable: Yes | Display Errors: | Error Reporting: 24567 | Log Errors To: error_log | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: /home/digimous:/usr/lib/php:/usr/local/lib/php:/tmp | Uploads: 1 | Max. Upload Size: 10M | Max. POST Size: 8M | Max. Input Time: 60 | Max. Execution Time: 120 | Memory Limit: 128M

MySQL Configuration :: Version: 5.5.46-cll (Client:5.5.46) | Host: --protected-- (--protected--) | Collation: latin1_swedish_ci (Character Set: latin1) | Database Size: 12.45 MiB | #of Tables:  193
Detailed Environment :: wrote:PHP Extensions :: Core (5.6.16) | date (5.6.16) | ereg () | libxml () | openssl () | pcre () | sqlite3 (0.7-dev) | zlib (2.0) | bcmath () | calendar () | ctype () | curl () | dom (20031129) | filter (0.11.0) | ftp () | gd () | hash (1.0) | iconv () | SPL (0.2) | json (1.2.1) | mbstring () | mcrypt () | session () | mysql (1.0) | mysqli (0.1) | standard (5.6.16) | Phar (2.0.2) | Reflection ($Id: e1a2c576686e394757985fc88c2e6243ab2bb511 $) | mysqlnd (mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $) | SimpleXML (0.1) | soap () | sockets () | imap () | tokenizer (0.1) | xml () | xmlreader (0.1) | xmlwriter (0.1) | xsl (0.1) | zip (1.12.5) | apache2handler () | XCache (3.2.0) | PDO (1.0.4dev) | pdo_sqlite (1.0.1) | pdo_mysql (1.0.2) | XCache Cacher (3.2.0) | ionCube Loader () | Zend Engine (2.6.0) |
Potential Missing Extensions :: suhosin |

Switch User Environment (Experimental) :: PHP CGI: No | Server SU: No | PHP SU: No | Custom SU (LiteSpeed/Cloud/Grid): No
Potential Ownership Issues: Maybe

Apache Modules :: core | mod_authn_file | mod_authn_core | mod_authz_host | mod_authz_groupfile | mod_authz_user | mod_authz_core | mod_access_compat | mod_auth_basic | mod_socache_shmcb | mod_socache_dbm | mod_so | mod_include | mod_filter | mod_deflate | http_core | mod_mime | mod_log_config | mod_logio | mod_env | mod_expires | mod_headers | mod_unique_id | mod_setenvif | mod_version | mod_proxy | mod_proxy_connect | mod_proxy_http | mod_slotmem_shm | mod_ssl | prefork | mod_unixd | mod_status | mod_autoindex | mod_asis | mod_suexec | mod_cgi | mod_negotiation | mod_dir | mod_actions | mod_userdir | mod_alias | mod_rewrite | mod_bwlimited | mod_cloudflare | mod_ruid2 | mod_php5 | mod_security2 | Apache |
Potential Missing Modules :: mod_security | mod_evasive | mod_dosevasive | mod_qos | mod_userdir |
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) |

Elevated Permissions (First 10) ::
Extensions Discovered :: wrote:Components :: SITE :: Bluedream (4.0) | Origami (4.0) | Vintage (4.0) | Default Theme (3.5) | Wireframe (4.0) | Bubbles (4.0) | Plain (4.0) | Nomad (4.0) | Carbon (4.0) | WF_CLEANUP_TITLE (2.5.12) | WF_STYLE_TITLE (2.5.12) | WF_DIRECTIONALITY_TITLE (2.5.12) | WF_FONTSELECT_TITLE (2.5.12) | WF_MEDIAMANAGER_TITLE (2.0.11) | WF_ARTICLE_TITLE (2.5.12) | WF_AUTOSAVE_TITLE (2.5.12) | WF_FULLSCREEN_TITLE (2.5.12) | WF_FILEMANAGER_TITLE (2.1.6) | WF_XHTMLXTRAS_TITLE (2.5.12) | WF_FORMATSELECT_TITLE (2.5.12) | WF_SPELLCHECKER_TITLE (2.5.12) | WF_SEARCHREPLACE_TITLE (2.5.12) | WF_FONTSIZESELECT_TITLE (2.5.12) | WF_IMGMANAGER_EXT_TITLE (2.0.19) | WF_LINK_TITLE (2.5.12) | WF_SOURCE_TITLE (2.5.12) | WF_CONTEXTMENU_TITLE (2.5.12) | WF_FONTCOLOR_TITLE (2.5.12) | WF_VISUALBLOCKS_TITLE (2.5.12) | WF_HR_TITLE (2.5.12) | WF_TEMPLATEMANAGER_TITLE (2.0.5) | WF_KITCHENSINK_TITLE (2.5.12) | WF_CAPTION_TITLE (2.1.0) | WF_BROWSER_TITLE (2.5.12) | WF_ANCHOR_TITLE (2.5.12) | WF_INLINEPOPUPS_TITLE (2.5.12) | WF_NONBREAKING_TITLE (2.5.12) | WF_IFRAME_TITLE (2.1.0) | WF_STYLESELECT_TITLE (2.5.12) | WF_TEXTCASE_TITLE (2.5.12) | WF_IMGMANAGER_TITLE (2.5.12) | WF_CLIPBOARD_TITLE (2.5.12) | WF_PRINT_TITLE (2.5.12) | WF_PREVIEW_TITLE (2.5.12) | WF_LISTS_TITLE (2.5.12) | WF_VISUALCHARS_TITLE (2.5.12) | WF_CHARMAP_TITLE (2.5.12) | WF_MEDIA_TITLE (2.5.12) | WF_TABLE_TITLE (2.5.12) | WF_LAYER_TITLE (2.5.12) | WF_FILESYSTEM_JOOMLA_TITLE (2.5.12) | WF_LINK_SEARCH_TITLE (2.5.12) | WF_POPUPS_WIDGETKIT_TITLE (2.0.4) | WF_POPUPS_WINDOW_TITLE (2.5.12) | WF_POPUPS_JCEMEDIABOX_TITLE (2.5.12) | WF_LINKS_JOOMLALINKS_TITLE (2.5.12) | K2 Links for JCE Link (2.2) | WF_AGGREGATOR_DAILYMOTION_TITL (2.5.12) | WF_AGGREGATOR_VINE_TITLE (2.5.12) | WF_AGGREGATOR_VIMEO_TITLE (2.5.12) | WF_AGGREGATOR_[youtube]_TITLE (2.5.12) | WF_MEDIAPLAYER_JCEPLAYER_TITLE (2.5.12) | com_mailto (3.0.0) | com_wrapper (3.0.0) |
Components :: ADMIN :: com_installer (3.0.0) | com_media (3.0.0) | com_plugins (3.0.0) | com_redirect (3.0.0) | com_languages (3.0.0) | com_contenthistory (3.2.0) | com_easyblog (5.0.23) | com_weblinks (3.4.1) | com_joomlaupdate (3.0.0) | com_finder (3.0.0) | com_banners (3.0.0) | com_config (3.0.0) | Unknown (-) | JCE (2.5.12) | com_menus (3.0.0) | com_zoo (3.1.4) | com_templates (3.0.0) | com_xmap (2.3.4) | com_checkin (3.0.0) | com_cache (3.0.0) | Canonical (2.4) | AcyMailing : share on social n (1.0.0) | AcyMailing Editor (beta) (4.7.2) | AcyMailing Tag : Joomla User I (4.7.2) | AcyMailing Module (3.7.0) | AcyMailing Template Class Repl (4.7.2) | AcyMailing Tag : content inser (3.7.0) | AcyMailing : Statistics Plugin (3.7.0) | AcyMailing Tag : CB User infor (3.7.0) | AcyMailing : (auto)Subscribe d (4.7.2) | AcyMailing Tag : Website links (3.7.0) | AcyMailing table of contents g (1.0.0) | AcyMailing : Handle Click trac (4.7.2) | AcyMailing: override Joomla ma (4.7.2) | AcyMailing Tag : Manage the Su (4.7.2) | AcyMailing Manage text (1.0.0) | AcyMailing Tag : Subscriber in (4.7.2) | AcyMailing Tag : Date / Time (4.7.2) | AcyMailing : trigger Joomla Co (3.7.0) | AcyMailing : Handle Click trac (4.7.2) | AcyMailing (4.7.2) | com_cpanel (3.0.0) | com_admin (3.0.0) | com_ajax (3.2.0) | Widgetkit (1.5.6) | com_content (3.0.0) | dunamis (1.4.3) | com_search (3.0.0) | com_modules (3.0.0) | com_chronoforms5 (5.0.10) | com_users (3.0.0) | com_postinstall (3.2.0) | com_tags (3.1.0) | Admintools (3.6.8) | com_login (3.0.0) | com_messages (3.0.0) | com_newsfeeds (3.0.0) | com_jwhmcs (2.6.04) | com_categories (3.0.0) | Akeeba (4.5.1) |

Modules :: SITE :: EasyBlog - Tag Cloud Module (5.0.23) | mod_whosonline (3.0.0) | mod_syndicate (3.0.0) | EasyBlog - Search Blogs Module (5.0.23) | EasyBlog - Image Wall Module (5.0.23) | Custom HTML advanced (JTricks. (1.0) | EasyBlog - Top Blogs Module (5.0.23) | mod_tags_popular (3.1.0) | EasyBlog - Post Map Module (5.0.23) | EasyBlog - Related Posts Modul (5.0.23) | mod_banners (3.0.0) | mod_articles_archive (3.0.0) | mod_random_image (3.0.0) | mod_weblinks (3.4.1) | EasyBlog - Latest Bloggers Mod (5.0.23) | AcyMailing Module (3.7.0) | mod_articles_latest (3.0.0) | mod_stats (3.0.0) | EasyBlog - Ticker Module (5.0.23) | ZOO Item (3.0.1) | ZOO Category (3.0.0) | MetaMod (3.13b) | MetaMod (3.13b) | mod_related_items (3.0.0) | EasyBlog - Subscribers Listing (5.0.23) | Widgetkit (1.0.0) | EasyBlog - Latest Blogs Module (5.0.23) | Easyblog - Categories Module (5.0.23) | ZOO Item Paginate (3.0.0) | EasyBlog - Latest Comments Mod (5.0.23) | ChronoForms5 (V5 RC1.2) | EasyBlog - Random Post Module (5.0.23) | EasyBlog - Most Popular Post M (5.0.23) | mod_languages (3.0.0) | EasyBlog - Posts List (5.0.23) | EasyBlog - Quick Post Module (5.0.23) | mod_articles_categories (3.0.0) | EasyBlog - Welcome Module (5.0.23) | Widgetkit Twitter (1.0.0) | EasyBlog - Biography Module (5.0.23) | EasyBlog - Calendar Module (5.0.23) | mod_users_latest (3.0.0) | ZOO Comment (3.0.0) | mod_articles_news (3.0.0) | mod_breadcrumbs (3.0.0) | mod_login (3.0.0) | mod_tags_similar (3.1.0) | EasyBlog - Subscribe Module (5.0.23) | mod_articles_popular (3.0.0) | EasyBlog - Most Commented Post (5.0.23) | EasyBlog - Showcase Module (5.0.23) | EasyBlog - Post Meta Module (5.0.23) | EasyBlog - Archive Module (5.0.23) | ZOO Tag (3.0.0) | mod_wrapper (3.0.0) | mod_feed (3.0.0) | mod_custom (3.0.0) | mod_menu (3.0.0) | mod_finder (3.0.0) | EasyBlog - Team Blogs Module (5.0.23) | mod_search (3.0.0) | mod_footer (3.0.0) | mod_articles_category (3.0.0) |
Modules :: ADMIN :: mod_popular (3.0.0) | mod_toolbar (3.0.0) | ZOO Quick Icons (3.0.0) | mod_latest (3.0.0) | mod_version (3.0.0) | mod_status (3.0.0) | mod_quickicon (3.0.0) | mod_logged (3.0.0) | mod_login (3.0.0) | mod_title (3.0.0) | mod_submenu (3.0.0) | mod_stats_admin (3.0.0) | mod_multilangstatus (3.0.0) | mod_feed (3.0.0) | mod_custom (3.0.0) | mod_menu (3.0.0) |

Plugins :: SITE :: plg_quickicon_joomlaupdate (3.0.0) | plg_quickicon_jcefilebrowser (2.5.12) | plg_quickicon_extensionupdate (3.0.0) | EasyBlog - Auto Article (5.0.1) | AcyMailing : Handle Click trac (4.7.2) | System - MetaMod Pro (3.13b) | System - Admin Tools (3.6.8) | PLG_CANONICAL (2.4) | plg_system_cache (3.0.0) | plg_system_p3p (3.0.0) | System - Widgetkit (1.0.0) | AcyMailing : (auto)Subscribe d (4.7.2) | plg_system_logout (3.0.0) | System - Widgetkit ZOO (3.1.0) | System - Expires Headers (1.3) | System - JWHMCS (2.6.04) | System - Widgetkit Joomla (1.0.0) | plg_system_languagefilter (3.0.0) | plg_system_redirect (3.0.0) | plg_system_debug (3.0.0) | plg_system_languagecode (3.0.0) | System - ZOO Event (3.0.0) | plg_system_highlight (3.0.0) | plg_system_remember (3.0.0) | PLG_TWO_FACTOR_AUTHENTICATION (2.1) | AcyMailing: override Joomla ma (4.7.2) | plg_system_jce (2.5.12) | plg_system_sef (3.0.0) | System - JWHMCS: Pricing Plugi (2.6.04) | plg_system_log (3.0.0) | plg_extension_joomla (3.0.0) | Search - Easy Blog (3.7.0) | plg_search_weblinks (3.4.1) | plg_search_contacts (3.0.0) | plg_search_categories (3.0.0) | Search - JWHMCS: Search WHMCS (2.6.04) | plg_search_content (3.0.0) | plg_search_tags (3.0.0) | plg_search_newsfeeds (3.0.0) | Search - ZOO (3.0.0) | PLG_JMONITORING_AKEEBABACKUP_T (1.0) | plg_authentication_ldap (3.0.0) | Authentication - JWHMCS (2.6.04) | plg_authentication_cookie (3.0.0) | plg_authentication_gmail (3.0.0) | plg_authentication_joomla (3.0.0) | plg_editors-xtd_pagebreak (3.0.0) | plg_editors-xtd_article (3.0.0) | plg_editors-xtd_image (3.0.0) | plg_editors-xtd_readmore (3.0.0) | plg_installer_webinstaller (1.0.5) | AcyMailing : Statistics Plugin (3.7.0) | EasyBlog integration for AcyMa (2.0.1) | AcyMailing : trigger Joomla Co (3.7.0) | AcyMailing Tag : Date / Time (4.7.2) | AcyMailing Template Class Repl (4.7.2) | AcyMailing Tag : Joomla User I (4.7.2) | AcyMailing Tag : Subscriber in (4.7.2) | AcyMailing Tag : content inser (3.7.0) | AcyMailing : share on social n (1.0.0) | AcyMailing Tag : Website links (3.7.0) | AcyMailing Tag : Manage the Su (4.7.2) | AcyMailing : Handle Click trac (4.7.2) | AcyMailing Manage text (1.0.0) | AcyMailing table of contents g (1.0.0) | AcyMailing Tag : CB User infor (3.7.0) | AcyMailing Editor (beta) (4.7.2) | plg_editors_tinymce (4.1.7) | plg_editors_jce (2.5.12) | plg_editors_codemirror (5.6) | Xmap - EasyBlog Plugin (3.9.1) | Xmap - WebLinks Plugin (2.0.1) | Xmap - Zoo Plugin (2.1.1TD) | Xmap - Content Plugin (2.0.4) | XMAP_PLUGIN_K2 (1.3) | Xmap - Kunena Plugin (3.0.0) | Xmap - Mosets Tree Plugin (2.0.2) | Xmap - Virtuemart Plugin (2.0.3) | Xmap - SobiPro Plugin (2.0.2) | plg_captcha_recaptcha (3.4.0) | PLG_CONTENT_JOSTAG (2.2) | AllVideos (by JoomlaWorks) (4.4) | Chronoforms5 (V5.0) | plg_content_pagebreak (3.0.0) | plg_content_vote (3.0.0) | plg_content_pagenavigation (3.0.0) | Content - Facebook-Twitter-Goo (3.2) | plg_content_joomla (3.0.0) | plg_content_geshi (2.5.0) | plg_content_loadmodule (3.0.0) | Content - Widgetkit (1.0.0) | plg_content_finder (3.0.0) | plg_content_emailcloak (3.0.0) | Content - ZOO Shortcode (3.0.0) | plg_twofactorauth_totp (3.2.0) | plg_twofactorauth_yubikey (3.2.0) | Smart Search - EasyBlog Posts (3.5.0) | plg_finder_weblinks (3.4.1) | Smart Search - ZOO (2.5.0) | plg_finder_contacts (3.0.0) | plg_finder_categories (3.0.0) | plg_finder_content (3.0.0) | plg_finder_tags (3.0.0) | plg_finder_newsfeeds (3.0.0) | plg_user_contactcreator (3.0.0) | plg_user_profile (3.0.0) | plg_user_joomla (3.0.0) | User - JWHMCS (2.6.04) | User - EasyBlog Users (5.0.1) | User - EasyBlog Users (3.0.0) |
Templates Discovered :: wrote:Templates :: SITE :: yoo_sync (1.0.3) | beez_20 (2.5.0) | beez5 (2.5.0) | beez3 (3.1.0) | atomic (2.5.0) | protostar (1.0) |
Templates :: ADMIN :: bluestork (2.5.0) | isis (1.0) | hathor (3.0.0) |
Last edited by toivo on Sat Jan 09, 2016 11:36 am, edited 1 time in total.
Reason: mod note: disabled smilies

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 12771
Joined: Thu Feb 15, 2007 5:48 am
Location: Zagreb, Croatia

Re: Error 1054 Unknown column 'b.sectionid' in 'field list'

Post by toivo » Sat Jan 09, 2016 11:47 am

1054 Unknown column 'b.sectionid' in 'field list'
Did you recently upgrade from Joomla 2.5?

Some files may not have been copied correctly because the column sectionid was in the content table in Joomla 2.5 but it was removed in Joomla 3.
Toivo Talikka, Global Moderator

mkrokos
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Fri Nov 02, 2012 10:23 am

Re: Error 1054 Unknown column 'b.sectionid' in 'field list'

Post by mkrokos » Sat Jan 09, 2016 11:49 am

Not recently but, yes, I did upgrade from Joomla 2.5. Any suggestions?

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 12771
Joined: Thu Feb 15, 2007 5:48 am
Location: Zagreb, Croatia

Re: Error 1054 Unknown column 'b.sectionid' in 'field list'

Post by toivo » Sat Jan 09, 2016 12:42 pm

Did any action other than the recent Joomla updates change the site just before the errors started?

First make sure that your active templates, both front end and back end, do not have overrides in the folder html/com_content that originated in Joomla 2.5.

You should compare the following folders in your site to the corresponding folders in an expanded installation archive of Joomla 3.4.8 and make sure they are identical:
administrator/components/com_content
components/com_content

It would not hurt to compare all folders to a clean installation archive to see if some files do not belong there. There are useful tools for that like diff, WinMerge and BeyondCompare.
Toivo Talikka, Global Moderator

mkrokos
Joomla! Apprentice
Joomla! Apprentice
Posts: 33
Joined: Fri Nov 02, 2012 10:23 am

Re: Error 1054 Unknown column 'b.sectionid' in 'field list'

Post by mkrokos » Sun Jan 10, 2016 11:50 am

Hello toivo and thanks for the assistance,

I have checked everything you mentioned and I didn't find anything out of the ordinary.
I then did a search in the database for the "section" string. And then it showed up! It was the Canonical URL plugin leftover from a previous version, I guess. As soon as I deinstalled the plugin, the articles and the links are working as expected.

Again, thanks for the assistance.

Manos K


Locked

Return to “General Questions/New to Joomla! 3.x”