Upgrade from 3.8.12 to 3.9.0 creates an error when trying to create an article

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.
Locked
bbirkeland
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Nov 14, 2018 10:16 am

Upgrade from 3.8.12 to 3.9.0 creates an error when trying to create an article

Post by bbirkeland » Wed Nov 14, 2018 10:34 am

After the upgrade I am getting error 500 Unknown column 'a.note' in 'field list' when trying to create an article (Content --> Articles)
Problem Description :: Forum Post Assistant (v1.4.5 (Ganymede)) : 14th November 2018 wrote:After updrage frm joomla 3.8.12 to 3.9.0 I am uable to add articles
Log/Error Message :: Forum Post Assistant (v1.4.5 (Ganymede)) : 14th November 2018 wrote:500 unknown error 'a.note' in 'field list'
Actions Taken To Resolve by Forum Post Assistant (v1.4.5 (Ganymede)) 14th November 2018 wrote:downgrade to 3.8.12 (restore backup)
Forum Post Assistant (v1.4.5 (Ganymede)) : 14th November 2018 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.9.0-Stable (Amani) 30-October-2018
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) | Owner: --protected-- . (uid: /gid: ) | Group: --protected-- (gid: ) | Valid For: 3.9
Configuration Options :: Offline: true | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: No | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.9.0: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 4.4.134+20180824.0648.fc9acc4c.xenial | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 19874.89 GiB |

PHP Configuration :: Version: 7.2.12 | PHP API: cgi-fcgi | Session Path Writable: No | Display Errors: | Error Reporting: 24567 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 96M | Max. POST Size: 96M | Max. Input Time: 60 | Max. Execution Time: 50 | Memory Limit: 536870912

Database Configuration :: Version: 5.5.5-10.1.30-MariaDB-1~xenial (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $) | Host: --protected-- (--protected--) | Localhost: No | Collation: utf8_general_ci (Character Set: utf8) | Database Size: 42.86 MiB | #of Tables: 406
Detailed Environment :: wrote:PHP Extensions :: Core (7.2.12) | date (7.2.12) | libxml (7.2.12) | openssl (7.2.12) | pcre (7.2.12) | sqlite3 (7.2.12) | zlib (7.2.12) | bcmath (7.2.12) | calendar (7.2.12) | ctype (7.2.12) | curl (7.2.12) | dba (7.2.12) | dom (20031129) | hash (1.0) | fileinfo (1.0.5) | filter (7.2.12) | gd (7.2.12) | gettext (7.2.12) | SPL (7.2.12) | iconv (7.2.12) | session (7.2.12) | intl (1.1.0) | json (1.6.0) | mbstring (7.2.12) | standard (7.2.12) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $) | mysqli (7.2.12) | PDO (7.2.12) | pdo_mysql (7.2.12) | pdo_sqlite (7.2.12) | Reflection (7.2.12) | imap (7.2.12) | SimpleXML (7.2.12) | soap (7.2.12) | sodium (7.2.12) | exif (7.2.12) | sysvshm (7.2.12) | tokenizer (7.2.12) | wddx (7.2.12) | xml (7.2.12) | xmlreader (7.2.12) | xmlrpc (7.2.12) | xmlwriter (7.2.12) | xsl (7.2.12) | zip (1.15.4) | cgi-fcgi () | Zend Engine (3.2.0) |
Potential Missing Extensions ::
Disabled Functions :: disk_total_space | diskfreespace | exec | system | popen | proc_open | proc_nice | shell_exec | passthru | dl |

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: No | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): No
Potential Ownership Issues: Maybe
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) | administrator/logs/ (755) |

Elevated Permissions (First 10) ::
Database Information :: wrote:Database statistics :: Uptime: 9092 | Threads: 10 | Questions: 5650293 | Slow queries: 0 | Opens: 16100 | Flush tables: 1 | Open tables: 8191 | Queries per second avg: 621.457 |
Extensions Discovered :: wrote:Components :: SITE ::
Core :: com_wrapper (3.0.0) 1 | com_mailto (3.0.0) 1 |
3rd Party:: BlueDream (3.5) 1 | Default Theme (3.5) 1 | Nomad (3.5) 1 | Plain (3.5) 1 | Vintage (3.5) 1 | Bubbles (3.5) 1 | Carbon (3.5) 1 | Origami (3.5) 1 |

Components :: ADMIN ::
Core :: com_redirect (3.0.0) 1 | com_cache (3.0.0) 1 | com_content (3.0.0) 1 | com_menus (3.0.0) 1 | com_media (3.0.0) 1 | com_login (3.0.0) 1 | com_languages (3.0.0) 1 | com_categories (3.0.0) 1 | com_banners (3.0.0) 1 | com_privacy (3.9.0) 1 | com_tags (3.1.0) 1 | com_messages (3.0.0) 1 | com_checkin (3.0.0) 1 | com_newsfeeds (3.0.0) 1 | com_associations (3.7.0) 1 | com_config (3.0.0) 1 | com_templates (3.0.0) 1 | com_users (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_contenthistory (3.2.0) 1 | com_plugins (3.0.0) 1 | com_modules (3.0.0) 1 | com_cpanel (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_ajax (3.2.0) 1 | com_admin (3.0.0) 1 | com_installer (3.0.0) 1 | com_search (3.0.0) 1 | com_weblinks (3.5.0) 1 | com_fields (3.7.0) 1 | com_finder (3.0.0) 1 | com_joomlaupdate (3.6.2) 1 |
3rd Party:: COM_JEVENTS (3.4.25) 1 | com_djcatalog2 (3.4.1.1) 1 | com_easyblog (3.9.22295) 0 | com_djmediatools (2.2.1.rc) 1 | Akeeba (6.2.1) 1 |

Modules :: SITE ::
Core :: mod_finder (3.0.0) 1 | mod_login (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_weblinks (3.5.0) 1 | mod_tags_similar (3.1.0) 1 | mod_custom (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_users_latest (3.0.0) 1 | mod_search (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_whosonline (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_bookmark (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_random_image (3.0.0) 1 |
3rd Party:: mod_djc2cart (1.0) 1 | DJ-MegaMenu (2.0.3) 1 | MOD_JEV_CUSTOM_MODULE_TITLE (3.4.25) 1 | mod_djc2relateditems (3.6) 1 | mod_djc2items (3.6) 1 | Perfect AJAX Popup Contact For (3.4.17) 1 | mod_djc2frontpage (3.3) 1 | MOD_JEV_SWITCH_VIEW_TITLE (3.4.25) 1 | mod_djc2categories (3.4) 1 | MOD_JEV_LATEST_EVENTS_TITLE (3.4.25) 1 | mod_djc2producers (3.4) 1 | MOD_JEV_LEGEND_TITLE (3.4.25) 1 | MOD_JEV_FILTER_MODULE_TITLE (3.4.25) 1 | mod_djc2search (1.4) 1 | MOD_JEV_CALENDAR_TITLE (3.4.25) 1 | mod_djc2filters (3.8) 1 | DJ-MediaTools Album (2.1.0) 1 |

Modules :: ADMIN ::
Core :: mod_login (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_stats_admin (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_status (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_title (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_sampledata (3.8.0) 1 | mod_version (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_submenu (3.0.0) 1 |
3rd Party::

Plugins :: SITE ::
Core :: plg_twofactorauth_yubikey (3.2.0) 0 | plg_twofactorauth_totp (3.2.0) 0 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_captcha_recaptcha_invisibl (3.8) 1 | plg_captcha_recaptcha (3.4.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_p3p (3.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_privacyconsent (3.9.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_cache (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_redirect (3.0.0) 1 | plg_system_languagefilter (3.0.0) 0 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_content_vote (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_geshi (3.0.0) 0 | plg_content_pagenavigation (3.0.0) 1 | plg_content_finder (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_terms (3.9.0) 1 | plg_user_joomla (3.0.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_color (3.7.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 0 | plg_installer_packageinstaller (3.6.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 0 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_weblinks (3.5.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_weblinks (3.5.0) 1 | plg_search_tags (3.0.0) 0 | plg_search_newsfeeds (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_extension_joomla (3.0.0) 1 |
3rd Party:: plg_djmediatools_virtuemart (1.1.0) 0 | plg_djmediatools_djclassifieds (2.1.0) 0 | plg_djmediatools_content (1.4.0) 1 | plg_djmediatools_easyblog (1.1.0) 0 | plg_djmediatools_hikashop (1.1.0) 0 | plg_djmediatools_djcatalog2 (1.3.2.rc) 1 | plg_djmediatools_folder (1.2.0) 1 | plg_djmediatools_k2 (1.1.0) 0 | plg_editors_codemirror (5.40.0) 1 | plg_editors_tinymce (4.5.8) 1 | plg_quickicon_djcatalog (1.0) 0 | plg_quickicon_akeebabackup (1.0) 1 | PLG_SYSTEM_BACKUPONUPDATE_TITL (3.7) 1 | plg_system_jmframework (3.11) 1 | PLG_SYSTEM_GWEJSON (3.4.25) 1 | PLG_SYSTEM_AKEEBAUPDATECHECK_T (1.1) 1 | plg_system_djmegamenu (1.2.0) 1 | plg_content_djmediatools (2.1.1) 1 | PLG_JEV_CORE_CONTENT_PLUGIN_TI (3.4.25) 1 | User - EasyBlog Users (3.0.0) 1 | User - EasyBlog Users (3.0.0) 1 | plg_user_djcatalog2 (1.0) 0 | plg_djcatalog2_customfield (1.0) 0 | plg_djcatalog2_pagebreak (3.2) 1 | plg_djcatalog2_jlexreview (1.0) 0 | plg_xmap_com_djcatalog2 (1.4) 0 | plg_editors-xtd_djmediatools (2.0.0) 1 | plg_installer_jeventsinstaller (3.4.25) 1 | PLG_FINDER_JEVENTS (3.4.25) 0 | plg_search_djcatalog2 (2.4) 1 | PLG_JEV_SEARCH_TITLE (3.4.25) 1 |
Templates Discovered :: wrote:Templates :: SITE :: jm-car-dealer (1.00) 1 | beez3 (3.1.0) 1 | protostar (1.0) 1 |
Templates :: ADMIN :: hathor (3.0.0) 1 | isis (1.0) 1 |

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

Re: Upgrade from 3.8.12 to 3.9.0 creates an error when trying to create an article

Post by pmleconte » Wed Nov 14, 2018 1:07 pm

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

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 44088
Joined: Sat Apr 05, 2008 9:58 pm

Re: Upgrade from 3.8.12 to 3.9.0 creates an error when trying to create an article

Post by Webdongle » Wed Nov 14, 2018 1:45 pm

Session Path Writable: No ... should be yes

com_djcatalog2 is out of date
DJ-MegaMenu ... is out of date
jm-car-dealer Template ... is out of date

I don't have time to check all of the extensions but chances are there are many more out of date.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30926
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Upgrade from 3.8.12 to 3.9.0 creates an error when trying to create an article

Post by Per Yngve Berg » Wed Nov 14, 2018 3:48 pm

JEvents is 3.4.48


Locked

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