Unknown column 'm.publish_up' in 'where clause'

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
Dogs2Enjoy
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue May 14, 2024 2:17 pm

Unknown column 'm.publish_up' in 'where clause'

Post by Dogs2Enjoy » Tue May 14, 2024 2:20 pm

I hope someone can help?
Tried to update to Joomla 4.4 and created a mess...
Forum Post Assistant (v1.6.7) : 14-May-2024 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 4.4.4-Stable (Pamoja) 16-April-2024
Joomla! Configured :: Yes | Writable (644) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | 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: 1 | Error Reporting: maximum | Site Debug: true | Language Debug: false | Default Access: Public | Unicode Slugs: true | dbConnection Type: mysqli | PHP Supports J! 4.4.4: Yes | Database Supports J! 4.4.4: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 2.6.32-954.3.5.lve1.4.78.el6.x86_64 | Technology: x86_64 | Web Server: Apache/2 | Encoding: gzip, deflate, br, zstd | System TMP Writable: Yes | Free Disk Space : 31.52 GiB |

PHP Configuration :: Version: 8.0.30 | PHP API: litespeed | Session Path Writable: No | Display Errors: 0 | Error Reporting: 22527 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: /home/id2787297/:/tmp:/var/tmp:/opt/alt/php55/usr/share/pear/:/dev/urandom:/usr/local/lib/php/:/usr/local/php55/lib/php/ | Uploads: 1 | Max. Upload Size: 64M | Max. POST Size: 64M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 2048M

Database Configuration :: Version: 10.4.32-MariaDB-cll-lve (Client:3.1.22) | Database Size: 10.32 MiB | #of Tables with config prefix:  150 | #of other Tables:  0 | User Privileges : GRANT SELECTUser Privileges : INSERTUser Privileges : UPDATEUser Privileges : DELETEUser Privileges : CREATEUser Privileges : DROPUser Privileges : REFERENCESUser Privileges : INDEXUser Privileges : ALTERUser Privileges : CREATE TEMPORARY TABLESUser Privileges : LOCK TABLESUser Privileges : EXECUTEUser Privileges : CREATE VIEWUser Privileges : SHOW VIEWUser Privileges : CREATE ROUTINEUser Privileges : ALTER ROUTINEUser Privileges : EVENTUser Privileges : TRIGGER
Detailed Environment :: wrote:PHP Extensions :: Core (8.0.30) | date (8.0.30) | libxml (8.0.30) | openssl (8.0.30) | pcre (8.0.30) | sqlite3 (8.0.30) | zlib (8.0.30) | bz2 (8.0.30) | calendar (8.0.30) | ctype (8.0.30) | curl (8.0.30) | hash (8.0.30) | filter (8.0.30) | ftp (8.0.30) | gettext (8.0.30) | gmp (8.0.30) | SPL (8.0.30) | iconv (8.0.30) | json (8.0.30) | pcntl (8.0.30) | readline (8.0.30) | Reflection (8.0.30) | session (8.0.30) | standard (8.0.30) | shmop (8.0.30) | SimpleXML (8.0.30) | mbstring (8.0.30) | tokenizer (8.0.30) | xml (8.0.30) | litespeed () | bcmath (8.0.30) | dom (20031129) | fileinfo (8.0.30) | gd (8.0.30) | intl (8.0.30) | exif (8.0.30) | mysqli (8.0.30) | mysqlnd (mysqlnd 8.0.30) | PDO (8.0.30) | pdo_mysql (8.0.30) | pdo_sqlite (8.0.30) | Phar (8.0.30) | posix (8.0.30) | soap (8.0.30) | sockets (8.0.30) | xmlreader (8.0.30) | xmlwriter (8.0.30) | xsl (8.0.30) | zip (1.19.5) | Zend Engine (4.0.30) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Potential Ownership Issues: No
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (---) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) | api/ (755) |

Elevated Permissions (First 10) ::
Database Information :: wrote:Database statistics :: Uptime: 11316528 | Threads: 159 | Questions: 15813562364 | Slow queries: 7867 | Opens: 162519363 | Flush tables: 1 | Open tables: 10000 | Queries per second avg: 1397.386 |
Extensions Discovered :: wrote:Components :: Site ::
Core ::
3rd Party:: WF_LINKS_JOOMLALINKS_TITLE (2.9.18) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.9.18) ? | WF_AGGREGATOR_AUDIO_TITLE (2.9.18) ? | WF_AGGREGATOR_VIMEO_TITLE (2.9.18) ? | WF_AGGREGATOR_VIDEO_TITLE (2.9.18) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.9.18) ? | WF_AGGREGATOR_[youtube]_TITLE (2.9.18) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.9.18) ? | WF_LINK_SEARCH_TITLE (2.9.18) ? | WF_KITCHENSINK_TITLE (2.9.18) ? | WF_SPELLCHECKER_TITLE (2.9.18) ? | WF_ARTICLE_TITLE (2.9.18) ? | WF_EMOTIONS_TITLE (2.9.18) ? | WF_REFERENCE_TITLE (2.9.2) ? | WF_TABLE_TITLE (2.9.18) ? | WF_FONTSELECT_TITLE (2.9.18) ? | WF_CLIPBOARD_TITLE (2.9.18) ? | WF_HR_TITLE (2.9.18) ? | WF_FONTCOLOR_TITLE (2.9.18) ? | WF_FULLSCREEN_TITLE (2.9.18) ? | WF_VISUALCHARS_TITLE (2.9.18) ? | WF_IMGMANAGER_TITLE (2.9.18) ? | WF_CLEANUP_TITLE (2.9.18) ? | WF_LINK_TITLE (2.9.18) ? | WF_CHARMAP_TITLE (2.9.18) ? | WF_SEARCHREPLACE_TITLE (2.9.18) ? | WF_ANCHOR_TITLE (2.9.18) ? | WF_FONTSIZESELECT_TITLE (2.9.18) ? | WF_TEXTCASE_TITLE (2.9.18) ? | WF_SOURCE_TITLE (2.9.18) ? | WF_WORDCOUNT_TITLE (2.9.18) ? | WF_HELP_TITLE (2.9.18) ? | WF_AUTOSAVE_TITLE (2.9.18) ? | WF_STYLESELECT_TITLE (2.9.18) ? | JCE - Noneditable (1.0.0) ? | WF_MEDIA_TITLE (2.9.18) ? | WF_BROWSER_TITLE (2.9.18) ? | WF_VISUALBLOCKS_TITLE (2.9.18) ? | WF_CONTEXTMENU_TITLE (2.9.18) ? | WF_LISTS_TITLE (2.9.18) ? | WF_NONBREAKING_TITLE (2.9.18) ? | WF_PRINT_TITLE (2.9.18) ? | WF_ATTRIBUTES_TITLE (2.9.2) ? | WF_STYLE_TITLE (2.9.18) ? | WF_DIRECTIONALITY_TITLE (2.9.18) ? | WF_FORMATSELECT_TITLE (2.9.18) ? | WF_PREVIEW_TITLE (2.9.18) ? | WF_XHTMLXTRAS_TITLE (2.9.18) ? |

Components :: Admin ::
Core :: com_workflow (4.0.0) ? | com_postinstall (4.0.0) 1 | com_fields (4.0.0) 1 | com_messages (4.0.0) 1 | com_categories (4.0.0) 1 | com_templates (4.0.0) 1 | com_wrapper (4.0.0) 1 | com_menus (4.0.0) 1 | com_languages (4.0.0) 1 | com_tags (4.0.0) 1 | com_joomlaupdate (4.0.3) 1 | com_ajax (4.0.0) 1 | com_installer (4.0.0) 1 | com_actionlogs (3.9.0) 1 | com_plugins (4.0.0) 1 | com_banners (4.0.0) 1 | com_content (4.0.0) 1 | com_mails (4.0.0) ? | com_search (3.0.0) 1 | com_scheduler (4.1.0) ? | com_finder (4.0.0) 1 | com_media (3.0.0) 1 | com_privacy (3.9.0) 1 | com_contenthistory (4.0.0) 1 | com_users (4.0.0) 1 | com_guidedtours (4.3.0) ? | com_associations (4.0.0) 1 | com_cpanel (4.0.0) 1 | com_modules (4.0.0) 1 | com_cache (4.0.0) 1 | com_config (4.0.0) 1 | com_checkin (4.0.0) 1 | com_newsfeeds (4.0.0) 1 | com_redirect (4.0.0) 1 | com_login (4.0.0) 1 | com_admin (4.0.0) 1 |
3rd Party:: COM_YENDIFVIDEOSHARE (1.2.8) 1 | FlexiContact (15.02.01) 1 | ActiveHelper_LiveHelp (5.1.0) 1 | sysbreezingforms (1.0.0) 1 | COM_BREEZINGFORMS ((build 940)) 1 | com_sitemapgenerator (1.4.1) 1 | com_facebookpagereviews (1.5.5) 0 | COM_JCE (2.9.18) 1 | com_gantry5 (5.5.17) 1 | JMap (4.7.4) 1 |

Modules :: Site ::
Core :: mod_articles_latest (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_menu (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_login (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_search (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_tags_popular (3.1.0) 1 | mod_custom (3.0.0) 1 |
3rd Party:: Yendif Video Share - Categories (1.2.8) 1 | EB Whatsapp Chat (2.1) 1 | Yendif Video Share - Player (1.2.8) 1 | iCagenda - Calendar (3.8.0) 1 | Yendif Video Share - Playlist (1.2.8) 1 | Yendif Video Share - Videos (1.2.8) 1 | Carousel Banner (3.1.0) 1 | BreezingForms (1.8.4) 0 | mod_gantry5_particle (5.5.17) 1 | JSitemap module (4.7.4) 1 | Yendif Video Share - Search (1.2.8) 1 |

Modules :: Admin ::
Core :: mod_frontend (4.0.0) ? | mod_toolbar (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_post_installation_messages (4.0.0) ? | mod_loginsupport (4.0.0) ? | mod_stats_admin (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_latest (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_messages (4.0.0) ? | mod_privacy_status (4.0.0) ? | mod_login (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_title (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_user (4.0.0) ? | mod_multilangstatus (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_guidedtours (4.3.0) ? | mod_quickicon (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_version (3.0.0) 1 |
3rd Party:: JSitemap Quickicons (4.7.4) 1 | MOD_ADDTOMENU (6.10.0) 1 | Add to Menu Component XML - com_cat (6.10.0) ? | Add to Menu Component XML - com_cat (6.10.0) ? | Add to Menu Component XML - com_cat (6.10.0) ? | Add to Menu Component XML - com_cat (6.10.0) ? | Add to Menu Component XML - com_cat (6.10.0) ? | Add to Menu Component XML - com_cat (6.10.0) ? | Add to Menu Component XML - com_cat (6.10.0) ? |

Libraries ::
Core ::
3rd Party:: Regular Labs Library (23.9.3039) 1 |

Plugins ::
Core :: plg_privacy_message (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_sampledata_multilang (4.0.0) ? | plg_api-authentication_token (4.0.0) ? | plg_api-authentication_basic (4.0.0) ? | plg_extension_finder (4.0.0) ? | plg_extension_namespacemap (4.0.0) ? | plg_extension_joomla (3.0.0) 1 | plg_quickicon_overridecheck (4.0.0) ? | plg_quickicon_downloadkey (4.0.0) ? | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_eos310 (3.10.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_eos (4.4.0) ? | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_jooa11y (4.2.0) ? | plg_system_actionlogs (3.9.0) ? | plg_system_log (3.0.0) 1 | plg_system_guidedtours (4.3.0) ? | plg_system_sef (3.0.0) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_updatenotification (3.5.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_privacyconsent (3.9.0) 0 | plg_system_task_notification (4.1) ? | plg_system_logrotation (3.9.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_skipto (4.0.0) ? | plg_system_webauthn (4.0.0) ? | plg_system_accessibility (4.0.0) ? | plg_system_shortcut (4.2.0) ? | plg_system_schedulerunner (4.1) ? | plg_system_logout (3.0.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_httpheaders (4.0.0) ? | plg_system_highlight (3.0.0) 1 | plg_user_token (3.9.0) ? | plg_user_terms (3.9.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_profile (3.0.0) 0 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_media-action_resize (4.0.0) ? | plg_media-action_crop (4.0.0) ? | plg_media-action_rotate (4.0.0) ? | plg_fields_text (3.7.0) 1 | plg_fields_subform (4.0.0) ? | plg_fields_color (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_workflow_publishing (4.0.0) ? | plg_workflow_notification (4.0.0) ? | plg_workflow_featuring (4.0.0) ? | plg_content_pagenavigation (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_emailcloak (3.0.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_vote (3.0.0) 0 | plg_content_fields (3.7.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_filesystem_local (4.0.0) ? | plg_behaviour_taggable (4.0.0) ? | plg_behaviour_versionable (4.0.0) ? | plg_behaviour_compat (4.4.0) ? | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_task_demo_tasks (4.1) ? | plg_task_check_files (4.1) ? | plg_task_requests (4.1) ? | plg_task_site_status (4.1) ? | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_actionlog_joomla (3.9.0) ? | plg_multifactorauth_yubikey (3.2.0) ? | plg_multifactorauth_fixed (4.2.0) ? | plg_multifactorauth_totp (3.2.0) ? | plg_multifactorauth_email (4.2.0) ? | plg_multifactorauth_webauthn (4.2.0) ? | plg_webservices_privacy (4.0.0) ? | plg_webservices_redirect (4.0.0) ? | plg_webservices_messages (4.0.0) ? | plg_webservices_languages (4.0.0) ? | plg_webservices_newsfeeds (4.0.0) ? | plg_webservices_users (4.0.0) ? | plg_webservices_tags (4.0.0) ? | plg_webservices_content (4.0.0) ? | plg_webservices_plugins (4.0.0) ? | plg_webservices_config (4.0.0) ? | plg_webservices_media (4.1.0) ? | plg_webservices_templates (4.0.0) ? | plg_webservices_menus (4.0.0) ? | plg_webservices_banners (4.0.0) ? | plg_webservices_modules (4.0.0) ? | plg_webservices_installer (4.0.0) ? | plg_installer_urlinstaller (3.6.0) ? | plg_installer_folderinstaller (3.6.0) ? | plg_installer_override (4.0.0) ? | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_webinstaller (4.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_search_categories (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_search_content (3.0.0) 1 |
3rd Party:: PLG_PRIVACY_ICAGENDA (1.1.0) 1 | plg_extension_jce (2.9.18) 1 | plg_quickicon_jce (2.9.18) 1 | plg_quickicon_icagendaupdate (2.0.0) 1 | plg_quickicon_gantry5 (5.5.17) 1 | plg_system_jce (2.9.18) 1 | System - Helix3 Framework (3.0.5) 0 | System - iCagenda :: Autologin (1.5.0) 1 | System - Helix Ultimate Framework (2.1.0) 1 | System - JSitemap utilities (4.7.4) 1 | Simple Google Analytics (1.0) 0 | sysbreezingforms (1.0.0) 1 | PLG_SYSTEM_COALAWEBANALYTICS (1.0.1) 1 | plg_system_gantry5 (5.5.17) 1 | System - Facebook Page Reviews (1.5.5) 1 | sysbreezingforms (1.0.0) 1 | PLG_CWGEARS (0.6.1) 1 | PLG_SYSTEM_REGULARLABS (23.9.3039) 0 | plg_fields_mediajce (2.9.18) 1 | Content - JSitemap Pingomatic (4.7.4) 1 | plg_content_jce (2.9.18) 1 | Yendif Video Share - Player (1.2.8) 1 | BreezingForms (1.8) 0 | Helix3 - Ajax (3.0.5) 1 | PLG_ACTIONLOG_ICAGENDA (1.3) 1 | plg_gantry5_preset (5.5.17) 1 | plg_editors_tinymce (5.10.9) 1 | plg_editors_jce (2.9.18) 1 | plg_editors_codemirror (5.65.15) 1 | PLG_INSTALLER_ICAGENDA (1.0) 1 | plg_installer_jce (2.9.18) 1 | PLG_SEARCH_ICAGENDA (2.5.0) 1 | Yendif Video Share - Search (1.2.8) 1 |
Templates Discovered :: wrote:Templates :: Site :: lt_company (4.0) 1 | astroid_template_zero (2.0.0) ? | cassiopeia (1.0) ? | shaper_helixultimate (2.1.0) 0 |
Templates :: Admin :: atum (1.0) ? |
Last edited by imanickam on Tue May 14, 2024 2:59 pm, edited 1 time in total.
Reason: Disabled Smilies

gws
Joomla! Champion
Joomla! Champion
Posts: 6005
Joined: Tue Aug 23, 2005 1:56 pm
Location: South coast, UK
Contact:

Re: Unknown column 'm.publish_up' in 'where clause'

Post by gws » Tue May 14, 2024 5:04 pm

Session Path Writable: No , should be yes. Ask your host to fix.
Open Base: /home/id2787297/:/tmp:/var/tmp:/opt/alt/php55/usr/share/pear/:/dev/urandom:/usr/local/lib/php/:/usr/local/php55/lib/php/
This points to php 5.5?? Modern hosts / servers don't need this ask your host to remove it, if they say its necessary for security consider changing hosts.


Post Reply

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