Joomla4 Upgrade issue

Need help upgrading your Joomla! website or converting to Joomla! 4.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
northbra
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Thu Apr 16, 2015 4:52 pm

Joomla4 Upgrade issue

Post by northbra » Sun Sep 12, 2021 4:52 pm

Error message :When I open an existing article and try to close it following error message appears: 1048 Column 'checked_out' cannot be null .
Forum Post Assistant (v1.6.2) : 12-Sep-2021 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 4.0.2-Stable (Furaha) 24-August-2021
Joomla! Configured :: Yes | Writable (666) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: N/A | FTP Layer: false | Proxy: N/A | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: N/A | SSL: 0 | Error Reporting: none | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 4.0.2: Yes | Database Supports J! 4.0.2: Yes | Database Credentials Present: Password missing |

Host Configuration :: OS: Windows NT | OS Version: 10.0 | Technology: AMD64 | Web Server: Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25 | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 159.33 GiB |

PHP Configuration :: Version: 7.3.25 | PHP API: apache2handler | Session Path Writable: No | Display Errors: 0 | Error Reporting: 32767 | Log Errors To: C:\xampp\php\logs\php_error_log | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 256M | Max. POST Size: 256M | Max. Input Time: 1000 | Max. Execution Time: 3000 | Memory Limit: 1024M

Database Configuration :: Version: 5.5.5-10.4.17-MariaDB (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $) | Database Size: 31.38 MiB | #of Tables with config prefix: 176 | #of other Tables: 353 | User Privileges : GRANT PROXY
Detailed Environment :: wrote:PHP Extensions :: Core (7.3.25) | bcmath (7.3.25) | calendar (7.3.25) | ctype (7.3.25) | date (7.3.25) | filter (7.3.25) | hash (7.3.25) | iconv (7.3.25) | json (1.7.0) | SPL (7.3.25) | pcre (7.3.25) | readline (7.3.25) | Reflection (7.3.25) | session (7.3.25) | standard (7.3.25) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $) | tokenizer (7.3.25) | zip (1.15.4) | zlib (7.3.25) | libxml (7.3.25) | dom (20031129) | PDO (7.3.25) | bz2 (7.3.25) | SimpleXML (7.3.25) | xml (7.3.25) | wddx (7.3.25) | xmlreader (7.3.25) | xmlwriter (7.3.25) | apache2handler () | openssl (7.3.25) | curl (7.3.25) | fileinfo (7.3.25) | gd (7.3.25) | gettext (7.3.25) | mbstring (7.3.25) | exif (7.3.25) | mysqli (7.3.25) | pdo_mysql (7.3.25) | pdo_sqlite (7.3.25) | Phar (7.3.25) | ftp (7.3.25) | Zend Engine (3.3.25) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: No

Apache Modules :: core | mod_win32 | mpm_winnt | http_core | mod_so | mod_access_compat | mod_actions | mod_alias | mod_allowmethods | mod_asis | mod_auth_basic | mod_authn_core | mod_authn_file | mod_authz_core | mod_authz_groupfile | mod_authz_host | mod_authz_user | mod_autoindex | mod_cgi | mod_dav_lock | mod_dir | mod_env | mod_headers | mod_include | mod_info | mod_isapi | mod_log_config | mod_cache_disk | mod_mime | mod_negotiation | mod_proxy | mod_proxy_ajp | mod_rewrite | mod_setenvif | mod_socache_shmcb | mod_ssl | mod_status | mod_php7 | Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25 |
Potential Missing Modules :: mod_expires | mod_deflate | mod_security | mod_evasive | mod_dosevasive | mod_qos | mod_userdir |
Folder Permissions :: wrote:Core Folders :: images/ (777) | components/ (777) | modules/ (777) | plugins/ (777) | language/ (777) | templates/ (777) | cache/ (777) | logs/ (777) | tmp/ (777) | administrator/components/ (777) | administrator/modules/ (777) | administrator/language/ (777) | administrator/templates/ (777) | administrator/logs/ (777) |

Elevated Permissions (First 10) :: .htpasswds/ (777) | administrator/ (777) | administrator/backups/ (777) | administrator/cache/ (777) | administrator/components/ (777) | administrator/components/com_actionlogs/ (777) | administrator/components/com_actionlogs/forms/ (777) | administrator/components/com_actionlogs/services/ (777) | administrator/components/com_actionlogs/src/ (777) | administrator/components/com_actionlogs/src/Controller/ (777) |
Database Information :: wrote:Database statistics :: Uptime: 130 | Threads: 7 | Questions: 77 | Slow queries: 0 | Opens: 733 | Flush tables: 1 | Open tables: 543 | Queries per second avg: 0.592 |
Extensions Discovered :: wrote:Components :: Site ::
Core ::
3rd Party:: WF_AGGREGATOR_AUDIO_TITLE (2.9.14) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.9.14) ? | WF_AGGREGATOR_VIDEO_TITLE (2.9.14) ? | WF_AGGREGATOR_VIMEO_TITLE (2.9.14) ? | WF_AGGREGATOR_[youtube]_TITLE (2.9.14) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.9.14) ? | WF_LINKS_JOOMLALINKS_TITLE (2.9.14) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.9.14) ? | WF_LINK_SEARCH_TITLE (2.9.14) ? | WF_ANCHOR_TITLE (2.9.14) ? | WF_ARTICLE_TITLE (2.9.14) ? | WF_ATTRIBUTES_TITLE (2.9.11) ? | WF_AUTOSAVE_TITLE (2.9.14) ? | WF_BROWSER_TITLE (2.9.14) ? | WF_CHARMAP_TITLE (2.9.14) ? | WF_CLEANUP_TITLE (2.9.14) ? | WF_CLIPBOARD_TITLE (2.9.14) ? | WF_CONTEXTMENU_TITLE (2.9.14) ? | WF_DIRECTIONALITY_TITLE (2.9.14) ? | WF_EMOTIONS_TITLE (2.9.14) ? | WF_FONTCOLOR_TITLE (2.9.14) ? | WF_FONTSELECT_TITLE (2.9.14) ? | WF_FONTSIZESELECT_TITLE (2.9.14) ? | WF_FORMATSELECT_TITLE (2.9.14) ? | WF_FULLSCREEN_TITLE (2.9.14) ? | WF_HELP_TITLE (2.9.14) ? | WF_HR_TITLE (2.9.14) ? | WF_IMGMANAGER_TITLE (2.9.14) ? | WF_KITCHENSINK_TITLE (2.9.14) ? | WF_LAYER_TITLE (2.8.3) ? | WF_LINK_TITLE (2.9.14) ? | WF_LISTS_TITLE (2.9.14) ? | WF_MEDIA_TITLE (2.9.14) ? | WF_NONBREAKING_TITLE (2.9.14) ? | JCE - Noneditable (1.0.0) ? | WF_PREVIEW_TITLE (2.9.14) ? | WF_PRINT_TITLE (2.9.14) ? | WF_REFERENCE_TITLE (2.9.11) ? | WF_SEARCHREPLACE_TITLE (2.9.14) ? | WF_SOURCE_TITLE (2.9.14) ? | WF_SPELLCHECKER_TITLE (2.9.14) ? | WF_STYLE_TITLE (2.9.14) ? | WF_STYLESELECT_TITLE (2.9.14) ? | WF_TABLE_TITLE (2.9.14) ? | WF_TEXTCASE_TITLE (2.9.14) ? | WF_VISUALBLOCKS_TITLE (2.9.14) ? | WF_VISUALCHARS_TITLE (2.9.14) ? | WF_WORDCOUNT_TITLE (2.9.14) ? | WF_XHTMLXTRAS_TITLE (2.9.14) ? |

Components :: Admin ::
Core :: com_actionlogs (3.9.0) 1 | com_admin (4.0.0) 1 | com_ajax (4.0.0) 1 | com_associations (4.0.0) 1 | com_banners (4.0.0) 1 | com_cache (4.0.0) 1 | com_categories (4.0.0) 1 | com_checkin (4.0.0) 1 | com_config (4.0.0) 1 | com_content (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_fields (4.0.0) 1 | com_finder (4.0.0) 1 | com_installer (4.0.0) 1 | com_joomlaupdate (4.0.2) 1 | com_languages (4.0.0) 1 | com_login (4.0.0) 1 | com_mails (4.0.0) 1 | com_media (3.0.0) 1 | com_menus (4.0.0) 1 | com_messages (4.0.0) 1 | com_modules (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_plugins (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_privacy (3.9.0) 1 | com_redirect (4.0.0) 1 | com_search (3.0.0) 1 | com_tags (4.0.0) 1 | com_templates (4.0.0) 1 | com_users (4.0.0) 1 | com_workflow (4.0.0) 1 | com_wrapper (4.0.0) 1 |
3rd Party:: Akeeba (8.0.10) 1 | com_jaextmanager (2.5.3) 1 | com_jaextmanager (2.7.1) 1 | COM_JCE (2.9.14) 1 |

Modules :: Site ::
Core :: mod_articles_archive (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_login (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_search (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_tags_similar (3.1.0) 1 | mod_users_latest (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_wrapper (3.0.0) 1 |
3rd Party:: Smart Latest News (1.0.0) 0 |

Modules :: Admin ::
Core :: mod_custom (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_frontend (4.0.0) 1 | mod_latest (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_logged (3.0.0) 1 | mod_login (3.0.0) 1 | mod_loginsupport (4.0.0) 1 | mod_menu (3.0.0) 1 | mod_messages (4.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_post_installation_messages (4.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_privacy_status (4.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_stats_admin (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_title (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_user (4.0.0) 1 | mod_version (3.0.0) 1 |
3rd Party::

Libraries ::
Core ::
3rd Party:: file_fof30 (3.6.2) ? | file_fof40 (4.0.1) ? | Regular Labs Library (21.8.25972) 0 |

Plugins ::
Core :: plg_actionlog_joomla (3.9.0) ? | plg_api-authentication_basic (4.0.0) 1 | plg_api-authentication_token (4.0.0) 0 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_behaviour_taggable (4.0.0) 1 | plg_behaviour_versionable (4.0.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_content_confirmconsent (3.9.0) 0 | plg_content_emailcloak (3.0.0) 0 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_weblink (3.7.0) 0 | plg_extension_finder (4.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_extension_namespacemap (4.0.0) 0 | plg_fields_calendar (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_subform (4.0.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_filesystem_local (4.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_installer_folderinstaller (3.6.0) ? | plg_installer_override (4.0.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_urlinstaller (3.6.0) ? | plg_installer_webinstaller (4.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_media-action_rotate (4.0.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_quickicon_downloadkey (4.0.0) 0 | plg_quickicon_eos310 (3.10.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_tags (3.0.0) 0 | plg_system_accessibility (4.0.0) 0 | plg_system_actionlogs (3.9.0) ? | plg_system_cache (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_httpheaders (4.0.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_languagefilter (3.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_redirect (3.0.0) 1 | plg_system_remember (3.0.0) 0 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_skipto (4.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_updatenotification (3.5.0) 0 | plg_system_webauthn (4.0.0) 1 | plg_system_weblinks (3.7.0) 0 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_user_token (3.9.0) 0 | plg_webservices_banners (4.0.0) 0 | plg_webservices_config (4.0.0) 0 | plg_webservices_content (4.0.0) 1 | plg_webservices_installer (4.0.0) 0 | plg_webservices_languages (4.0.0) 0 | plg_webservices_menus (4.0.0) 0 | plg_webservices_messages (4.0.0) 0 | plg_webservices_modules (4.0.0) 0 | plg_webservices_newsfeeds (4.0.0) 0 | plg_webservices_plugins (4.0.0) 0 | plg_webservices_privacy (4.0.0) 0 | plg_webservices_redirect (4.0.0) 0 | plg_webservices_tags (4.0.0) 0 | plg_webservices_templates (4.0.0) 0 | plg_webservices_users (4.0.0) 0 | plg_workflow_featuring (4.0.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_workflow_publishing (4.0.0) 1 |
3rd Party:: plg_content_jce (2.9.14) 1 | plg_editors_codemirror (5.62.2) 1 | plg_editors_jce (2.9.14) 1 | plg_editors_tinymce (5.8.2) 1 | plg_extension_jce (2.9.14) 1 | plg_fields_mediajce (2.9.14) 1 | plg_installer_jce (2.9.14) 1 | plg_quickicon_jce (2.9.14) 1 | PLG_JEV_SEARCH_TITLE (3.6.16) 0 | plg_system_jce (2.9.14) 1 | PLG_SYSTEM_REGULARLABS (21.8.25972) 0 |
Templates Discovered :: wrote:Templates :: Site :: cassiopeia (1.0) 1 |
Templates :: Admin :: atum (1.0) 1 |

User avatar
cmbay
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 147
Joined: Thu Dec 31, 2009 11:53 pm
Location: Oregon, USA

Re: Joomla4 Upgrade issue

Post by cmbay » Sun Sep 12, 2021 8:59 pm

Thank you for supplying the Forum Post Assistant report but Yikes! look at all those elevated permissions. You'll want to fix those.

No database password assigned? In your hosting control panel, have you created a database user with full permissions?

You'll also want to move up to PHP version 7.4+.
Charles

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 10906
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Joomla4 Upgrade issue

Post by sozzled » Sun Sep 12, 2021 9:14 pm

@cmbay: the "elevated permissions" are normal when using the FPA on a Windows PC-hosted platform (e.g. Wampserver, XAMPP, etc.) but it looks to me like the database does not support NULL values in the checked_out column for [the unspecified] table in the database. It's possible that the migration from J! 3.10 to J! 4.0 was not done properly using the Joomla! Update component (when the website was running J! 3.10).
“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
AMurray
Joomla! Champion
Joomla! Champion
Posts: 7124
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Joomla4 Upgrade issue

Post by AMurray » Sun Sep 12, 2021 9:21 pm

@cmbay "no database password" would also be normal on a localhost install (WAMPServer, XAMPP etc) on the OP's PC
Regards - A Murray

User avatar
cmbay
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 147
Joined: Thu Dec 31, 2009 11:53 pm
Location: Oregon, USA

Re: Joomla4 Upgrade issue

Post by cmbay » Sun Sep 12, 2021 9:24 pm

sozzled wrote:
Sun Sep 12, 2021 9:14 pm
the "elevated permissions" are normal when using the FPA on a Windows PC-hosted platform...
Aaaah. Thank you.
It's possible that the migration from J! 3.10 to J! 4.0 was not done properly using the Joomla! Update component...
There's more from @northbra in another thread.
Charles

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 10906
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Joomla4 Upgrade issue

Post by sozzled » Sun Sep 12, 2021 9:30 pm

Thanks, Andy. I figured that was the case about "missing passwords" on PC-hosted environments. As a quick test, I ran the FPA report on a PC-hosted J! 4 test site and it reports the same thing in the case where the SQL username (root) has no password:

fpaMissingPassword.png
(Although it flags it in orange font, not red). CORRECTION: It displays on the FPA panel in orange font (i.e. before you generate the forum post); the BBcode (used on this forum) generated by the FPA, however, displays the information in red-coloured font.

As a further comment (not wanting to contradict @cmbay's observation about PHP 7.3), PHP 7.3 should work fine with J! 4; theoretically, PHP 7.2.5 should work with J! 4 (but I wouldn't personally recommend using that version).
You do not have the required permissions to view the files attached to this post.
Last edited by sozzled on Sun Sep 12, 2021 9:40 pm, edited 4 times in total.
“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
sozzled
Joomla! Master
Joomla! Master
Posts: 10906
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Joomla4 Upgrade issue

Post by sozzled » Sun Sep 12, 2021 9:32 pm

Thanks, @cmbay: Yes, I thought I read something about NULL values being allowed but I couldn't remember where I read it. viewtopic.php?f=812&t=988520#p3639390 8)
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

northbra
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Thu Apr 16, 2015 4:52 pm

Re: Joomla4 Upgrade issue

Post by northbra » Sun Sep 19, 2021 8:08 am

Still getting message 1048 Column 'checked_out' cannot be null . I imported a copy of my database into a clean install of 3.10.2 and used Joomla update to 4.0.3. What can I do to fix?

User avatar
AMurray
Joomla! Champion
Joomla! Champion
Posts: 7124
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Joomla4 Upgrade issue

Post by AMurray » Sun Sep 19, 2021 8:11 am

Are all your 3.x extensions compatible - did it pass the pre-upgrade advisor test?

Did your previous 3.9.x site have additional extensions that you would have to run "discover install" on in 3.10.2 to get them reinstalled (since the core files of 3.10.2 would not have your third party extensions included).?
Regards - A Murray

northbra
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Thu Apr 16, 2015 4:52 pm

Re: Joomla4 Upgrade issue

Post by northbra » Sun Sep 19, 2021 8:18 am

Yes probably, but I was trying to avoid any extensions that are not J4 compatabile.

northbra
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Thu Apr 16, 2015 4:52 pm

Re: Joomla4 Upgrade issue

Post by northbra » Sun Sep 19, 2021 8:20 am

Here is log file:
Forum Post Assistant (v1.6.2) : 19-Sep-2021 wrote:
Problem Description :: wrote:Joomla 4 upgrade error
Log/Error Message :: wrote:1048 Column 'checked_out' cannot be null
Basic Environment :: wrote:Joomla! Instance :: Joomla! 4.0.3-Stable (Furaha) 12-September-2021
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | 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! 4.0.3: Yes | Database Supports J! 4.0.3: Yes | Database Credentials Present: Password missing |

Host Configuration :: OS: Windows NT | OS Version: 10.0 | Technology: AMD64 | Web Server: Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25 | Encoding: gzip, deflate | System TMP Writable: Yes | Free Disk Space : 152.39 GiB |

PHP Configuration :: Version: 7.3.25 | PHP API: apache2handler | Session Path Writable: Yes | Display Errors: 1 | Error Reporting: 32767 | Log Errors To: C:\xampp\php\logs\php_error_log | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 40M | Max. POST Size: 40M | Max. Input Time: 60 | Max. Execution Time: 300 | Memory Limit: 512M

Database Configuration :: Version: 5.5.5-10.4.17-MariaDB (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $) | Database Size: 41.47 MiB | #of Tables with config prefix: 230 | #of other Tables: 353 | User Privileges : GRANT PROXY
Detailed Environment :: wrote:PHP Extensions :: Core (7.3.25) | bcmath (7.3.25) | calendar (7.3.25) | ctype (7.3.25) | date (7.3.25) | filter (7.3.25) | hash (7.3.25) | iconv (7.3.25) | json (1.7.0) | SPL (7.3.25) | pcre (7.3.25) | readline (7.3.25) | Reflection (7.3.25) | session (7.3.25) | standard (7.3.25) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $) | tokenizer (7.3.25) | zip (1.15.4) | zlib (7.3.25) | libxml (7.3.25) | dom (20031129) | PDO (7.3.25) | bz2 (7.3.25) | SimpleXML (7.3.25) | xml (7.3.25) | wddx (7.3.25) | xmlreader (7.3.25) | xmlwriter (7.3.25) | apache2handler () | openssl (7.3.25) | curl (7.3.25) | fileinfo (7.3.25) | gd (7.3.25) | gettext (7.3.25) | mbstring (7.3.25) | exif (7.3.25) | mysqli (7.3.25) | pdo_mysql (7.3.25) | pdo_sqlite (7.3.25) | Phar (7.3.25) | ftp (7.3.25) | Zend Engine (3.3.25) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: No

Apache Modules :: core | mod_win32 | mpm_winnt | http_core | mod_so | mod_access_compat | mod_actions | mod_alias | mod_allowmethods | mod_asis | mod_auth_basic | mod_authn_core | mod_authn_file | mod_authz_core | mod_authz_groupfile | mod_authz_host | mod_authz_user | mod_autoindex | mod_cgi | mod_dav_lock | mod_dir | mod_env | mod_headers | mod_include | mod_info | mod_isapi | mod_log_config | mod_cache_disk | mod_mime | mod_negotiation | mod_proxy | mod_proxy_ajp | mod_rewrite | mod_setenvif | mod_socache_shmcb | mod_ssl | mod_status | mod_php7 | Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25 |
Potential Missing Modules :: mod_expires | mod_deflate | mod_security | mod_evasive | mod_dosevasive | mod_qos | mod_userdir |
Folder Permissions :: wrote:Core Folders :: images/ (777) | components/ (777) | modules/ (777) | plugins/ (777) | language/ (777) | templates/ (777) | cache/ (777) | logs/ (---) | tmp/ (777) | administrator/components/ (777) | administrator/modules/ (777) | administrator/language/ (777) | administrator/templates/ (777) | administrator/logs/ (777) |

Elevated Permissions (First 10) :: administrator/ (777) | administrator/cache/ (777) | administrator/components/ (777) | administrator/components/com_actionlogs/ (777) | administrator/components/com_actionlogs/forms/ (777) | administrator/components/com_actionlogs/services/ (777) | administrator/components/com_actionlogs/src/ (777) | administrator/components/com_actionlogs/src/Controller/ (777) | administrator/components/com_actionlogs/src/Field/ (777) | administrator/components/com_actionlogs/src/Helper/ (777) |
Database Information :: wrote:Database statistics :: Uptime: 95264 | Threads: 7 | Questions: 133633 | Slow queries: 0 | Opens: 2307 | Flush tables: 1 | Open tables: 1921 | Queries per second avg: 1.402 |
Extensions Discovered :: wrote:Components :: Site ::
Core ::
3rd Party::

Components :: Admin ::
Core :: com_actionlogs (3.9.0) 1 | com_admin (4.0.0) 1 | com_ajax (4.0.0) 1 | com_associations (4.0.0) 1 | com_banners (4.0.0) 1 | com_cache (4.0.0) 1 | com_categories (4.0.0) 1 | com_checkin (4.0.0) 1 | com_config (4.0.0) 1 | com_content (4.0.0) 1 | com_contenthistory (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_fields (4.0.0) 1 | com_finder (4.0.0) 1 | com_installer (4.0.0) 1 | com_joomlaupdate (4.0.2) 1 | com_languages (4.0.0) 1 | com_login (4.0.0) 1 | com_mails (4.0.0) 1 | com_media (3.0.0) 1 | com_menus (4.0.0) 1 | com_messages (4.0.0) 1 | com_modules (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_plugins (4.0.0) 1 | com_postinstall (4.0.0) 1 | com_privacy (3.9.0) 1 | com_redirect (4.0.0) 1 | com_search (3.0.0) 1 | com_tags (4.0.0) 1 | com_templates (4.0.0) 1 | com_users (4.0.0) 1 | com_workflow (4.0.0) 1 | com_wrapper (4.0.0) 1 |
3rd Party::

Modules :: Site ::
Core :: mod_articles_archive (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_login (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_search (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_tags_similar (3.1.0) 1 | mod_users_latest (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_wrapper (3.0.0) 1 |
3rd Party::

Modules :: Admin ::
Core :: mod_custom (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_frontend (4.0.0) 1 | mod_latest (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_logged (3.0.0) 1 | mod_login (3.0.0) 1 | mod_loginsupport (4.0.0) 1 | mod_menu (3.0.0) 1 | mod_messages (4.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_post_installation_messages (4.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_privacy_status (4.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_stats_admin (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_title (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_user (4.0.0) 1 | mod_version (3.0.0) 1 |
3rd Party::

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: plg_actionlog_joomla (3.9.0) ? | plg_api-authentication_basic (4.0.0) 1 | plg_api-authentication_token (4.0.0) 0 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_behaviour_taggable (4.0.0) 1 | plg_behaviour_versionable (4.0.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_content_confirmconsent (3.9.0) 0 | plg_content_emailcloak (3.0.0) 0 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_extension_finder (4.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_extension_namespacemap (4.0.0) 0 | plg_fields_calendar (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_subform (4.0.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_filesystem_local (4.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_installer_folderinstaller (3.6.0) ? | plg_installer_override (4.0.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_urlinstaller (3.6.0) ? | plg_installer_webinstaller (4.0.0) 1 | plg_media-action_crop (4.0.0) 1 | plg_media-action_resize (4.0.0) 1 | plg_media-action_rotate (4.0.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_quickicon_downloadkey (4.0.0) 0 | plg_quickicon_eos310 (3.10.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_overridecheck (4.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_sampledata_multilang (4.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_tags (3.0.0) 0 | plg_system_accessibility (4.0.0) 0 | plg_system_actionlogs (3.9.0) ? | plg_system_cache (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_httpheaders (4.0.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_languagefilter (3.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_redirect (3.0.0) 1 | plg_system_remember (3.0.0) 0 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_skipto (4.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_updatenotification (3.5.0) 0 | plg_system_webauthn (4.0.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_user_token (3.9.0) 0 | plg_webservices_banners (4.0.0) 0 | plg_webservices_config (4.0.0) 0 | plg_webservices_content (4.0.0) 1 | plg_webservices_installer (4.0.0) 0 | plg_webservices_languages (4.0.0) 0 | plg_webservices_menus (4.0.0) 0 | plg_webservices_messages (4.0.0) 0 | plg_webservices_modules (4.0.0) 0 | plg_webservices_newsfeeds (4.0.0) 0 | plg_webservices_plugins (4.0.0) 0 | plg_webservices_privacy (4.0.0) 0 | plg_webservices_redirect (4.0.0) 0 | plg_webservices_tags (4.0.0) 0 | plg_webservices_templates (4.0.0) 0 | plg_webservices_users (4.0.0) 0 | plg_workflow_featuring (4.0.0) 1 | plg_workflow_notification (4.0.0) 1 | plg_workflow_publishing (4.0.0) 1 |
3rd Party:: plg_editors_codemirror (5.62.2) 1 | plg_editors_tinymce (5.8.2) 1 |
Templates Discovered :: wrote:Templates :: Site :: cassiopeia (1.0) 1 |
Templates :: Admin :: atum (1.0) 1 |

northbra
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Thu Apr 16, 2015 4:52 pm

Re: Joomla4 Upgrade issue

Post by northbra » Sun Sep 19, 2021 5:00 pm

Do I need to remove extensions that are identified in the Pre Update check as Update information unavailable, or can I just disable them for the update?

User avatar
cmbay
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 147
Joined: Thu Dec 31, 2009 11:53 pm
Location: Oregon, USA

Re: Joomla4 Upgrade issue

Post by cmbay » Sun Sep 19, 2021 5:57 pm

northbra wrote:
Sun Sep 19, 2021 5:00 pm
Do I need to remove extensions that are identified in the Pre Update check as Update information unavailable, or can I just disable them for the update?
In my limited experience in Joomla 4 migrations, I suggest uninstalling those extensions. In some cases (for example, JQueryEasy 4.2.2), I found that I was not able to uninstall the extensions in Joomla 4.
Charles


Post Reply

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