"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
borrisvocschool
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sun Jan 16, 2022 9:50 pm

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

Post by borrisvocschool » Sun Jan 16, 2022 10:03 pm

Hi, I decided to run the upgrade from version 3 to version 4 of Joomla. But it failed at 90%. Now I cannot access my admin panel or gain access to the site at all. Please help.. We are a secondary school and are not professional at this. All other updates ran smoothly til now. The mess can be seen here: http://www.borrisvocationalschool.ie/ Cheers! Shane
Last edited by imanickam on Mon Jan 17, 2022 1:04 am, edited 1 time in total.
Reason: Split from the topic https://forum.joomla.org/viewtopic.php?f=810&t=991138

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 14607
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

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

Post by toivo » Mon Jan 17, 2022 2:01 am

Welcome to the Joomla forum!

Do you have a full backup created before attempting the upgrade?
Toivo Talikka, Global Moderator

User avatar
ceford
Joomla! Guru
Joomla! Guru
Posts: 734
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

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

Post by ceford » Mon Jan 17, 2022 3:54 am

Your site message tells you a database table was not updated.

Administrator access suggests you tried to upgrade with Joomla 4 incompatible plugins in place. Restore from backup and follow the prescribed procedure:

https://docs.joomla.org/Joomla_3.x_to_4 ... _Migration

User avatar
brian
Joomla! Master
Joomla! Master
Posts: 12474
Joined: Fri Aug 12, 2005 7:19 am
Location: Leeds, UK
Contact:

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

Post by brian » Mon Jan 17, 2022 8:10 am

And as shown in the stack trace you also have at least one plugin that is not compatible with joomla 4.

/plugins/system/jscsscontrol/jscsscontrol.php
"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/


Post Reply

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