Update not completed and issue with '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
catchergourmet
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 26, 2023 3:34 pm

Update not completed and issue with 'm.publish_up' in 'where clause'

Post by catchergourmet » Tue Sep 26, 2023 3:40 pm

I got the same problem,

Update was not completed.

PHP on my CPanel is now up-to-date but still error.

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

PLEASE HELP ME
Last edited by toivo on Fri Sep 29, 2023 11:40 pm, edited 1 time in total.
Reason: mod note: split from https://forum.joomla.org/viewtopic.php?f=812&t=989178&start=30 - please create your own topics in the future!

User avatar
trogladyte
Joomla! Guru
Joomla! Guru
Posts: 552
Joined: Sat May 03, 2008 9:27 pm
Location: Phoenix, AZ
Contact:

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

Post by trogladyte » Wed Sep 27, 2023 9:05 pm

@catchergourmet I tried a lot to resolve this but never did. Just delete the installation and retry the update. Make sure you remove ANY extension which is not J!4 compatible. That's where most of the issues arise.
Ian Shere - Phoenix Website Design & Hosting
http://www.citruskiwi.com
Certified Flight Instructor http://www.flygoodyear.com

catchergourmet
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 26, 2023 3:34 pm

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

Post by catchergourmet » Mon Oct 02, 2023 2:59 am

trogladyte wrote:
Wed Sep 27, 2023 9:05 pm
@catchergourmet I tried a lot to resolve this but never did. Just delete the installation and retry the update. Make sure you remove ANY extension which is not J!4 compatible. That's where most of the issues arise.
Unfortunately, I can't log in and delete the installation.

How can I delete?

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

Re: Update not completed and issue with 'm.publish_up' in 'where clause'

Post by Per Yngve Berg » Mon Oct 02, 2023 4:17 am

Use FTP or your host's cpanel.

catchergourmet
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 26, 2023 3:34 pm

Re: Update not completed and issue with 'm.publish_up' in 'where clause'

Post by catchergourmet » Mon Oct 02, 2023 5:23 am

Hi @Per Yngve Berg,

Do I need to uninstall the Joomla Scripts Installations on our Cpanel and reinstall?

catchergourmet
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 26, 2023 3:34 pm

Re: Update not completed and issue with 'm.publish_up' in 'where clause'

Post by catchergourmet » Mon Oct 02, 2023 9:31 am

Deleting the Installation will delete the website?

Can you guys help me what to do step by step?

thank you so much in advance.

catchergourmet
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 26, 2023 3:34 pm

Step by Step Support - The MySQLi extension is not available

Post by catchergourmet » Mon Oct 02, 2023 10:19 am

Hi Everyone!

Anyone can help me?

I updated Joomla then suddenly got an error.
"The MySQLi extension is not available"


Current Setting is:

Current PHP version : 8.2
You do not have the required permissions to view the files attached to this post.
Last edited by toivo on Mon Oct 02, 2023 9:53 pm, edited 1 time in total.
Reason: mod note: merged with the current topic

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

Re: Step by Step Support - The MySQLi extension is not available

Post by gws » Mon Oct 02, 2023 10:22 am

Enable it in php options on your server cpanel.

catchergourmet
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 26, 2023 3:34 pm

Re: Step by Step Support - The MySQLi extension is not available

Post by catchergourmet » Mon Oct 02, 2023 10:24 am

gws wrote:
Mon Oct 02, 2023 10:22 am
Enable it in php options on your server cpanel.
which one from here?
Screenshot 2023-10-02 182343.png
You do not have the required permissions to view the files attached to this post.

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

Re: Step by Step Support - The MySQLi extension is not available

Post by gws » Mon Oct 02, 2023 10:29 am

which php version is this?
If 8.2 use mysqlind

catchergourmet
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 26, 2023 3:34 pm

Re: Step by Step Support - The MySQLi extension is not available

Post by catchergourmet » Mon Oct 02, 2023 10:32 am

gws wrote:
Mon Oct 02, 2023 10:29 am
which php version is this?
Currently its 8.2

Cuz if I use lower version I got "Unknown column 'm.publish_up' in 'where clause'"

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

Re: Update not completed and issue with 'm.publish_up' in 'where clause'

Post by ceford » Mon Oct 02, 2023 10:55 am

First step: use a text editor to open administrator/logs/joomla_update.php

You should see a report on how the update went - first some lines about the start version, then 400+ lines of sql queries, then a finish up report. How far did the queries get? What do you see at the end?

It may be best to restore your previous version from backup and then follow the Step by Step upgrade procedure.

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

Re: Step by Step Support - The MySQLi extension is not available

Post by gws » Mon Oct 02, 2023 11:02 am

Are you installing joomla properly or using a one click installation programme ?

catchergourmet
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 26, 2023 3:34 pm

Re: Update not completed and issue with 'm.publish_up' in 'where clause'

Post by catchergourmet » Mon Oct 02, 2023 11:02 am

ceford wrote:
Mon Oct 02, 2023 10:55 am
First step: use a text editor to open administrator/logs/joomla_update.php

You should see a report on how the update went - first some lines about the start version, then 400+ lines of sql queries, then a finish up report. How far did the queries get? What do you see at the end?

It may be best to restore your previous version from backup and then follow the Step by Step upgrade procedure.
Hi Ceford,

Unfortunately, I have no idea on everything.

I hope someone can help me fix it for me.

catchergourmet
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 26, 2023 3:34 pm

Re: Step by Step Support - The MySQLi extension is not available

Post by catchergourmet » Mon Oct 02, 2023 11:03 am

gws wrote:
Mon Oct 02, 2023 11:02 am
Are you installing joomla properly or using a one click installation programme ?
Hi,

I think there has been a problem during installation on the new version.

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

Re: Step by Step Support - The MySQLi extension is not available

Post by gws » Mon Oct 02, 2023 11:05 am

That doesn't answer my question...

catchergourmet
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 26, 2023 3:34 pm

Re: Step by Step Support - The MySQLi extension is not available

Post by catchergourmet » Mon Oct 02, 2023 11:08 am

gws wrote:
Mon Oct 02, 2023 11:05 am
That doesn't answer my question...
As I remember, I uploaded the file Joomla_4.3.4-Stable-Full_Package.zip then after I got that error.

Sorry, I am not actually experienced in web design or programming.

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

Re: Update not completed and issue with 'm.publish_up' in 'where clause'

Post by ceford » Mon Oct 02, 2023 11:09 am

In cPanel select File Manager from the Files panel and then find your way to pubic_html and then your joomla installation.

Also, run the Forum Post Assistant and post the public results here so we can see what you have installed.

catchergourmet
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Sep 26, 2023 3:34 pm

Re: Update not completed and issue with 'm.publish_up' in 'where clause'

Post by catchergourmet » Mon Oct 02, 2023 11:17 am

ceford wrote:
Mon Oct 02, 2023 11:09 am
In cPanel select File Manager from the Files panel and then find your way to pubic_html and then your joomla installation.

Also, run the Forum Post Assistant and post the public results here so we can see what you have installed.
Here is my screenshot.

Sorry, I don't know how to run Forum Post Assistance. new here.
You do not have the required permissions to view the files attached to this post.

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

Re: Step by Step Support - The MySQLi extension is not available

Post by gws » Mon Oct 02, 2023 11:23 am

Lets be clear, earlier you state I updated then suddenly got an error. So update or clean install?

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

Re: Update not completed and issue with 'm.publish_up' in 'where clause'

Post by Per Yngve Berg » Mon Oct 02, 2023 11:24 am

The FPA is in the Red Frame above.

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

Re: Update not completed and issue with 'm.publish_up' in 'where clause'

Post by ceford » Mon Oct 02, 2023 11:47 am

In cPanel File Manager open administrator and then logs. Is joomla_update.php there? If yes, open it with the edit button at the top of the screen.

User avatar
trogladyte
Joomla! Guru
Joomla! Guru
Posts: 552
Joined: Sat May 03, 2008 9:27 pm
Location: Phoenix, AZ
Contact:

Re: Update not completed and issue with 'm.publish_up' in 'where clause'

Post by trogladyte » Mon Oct 02, 2023 1:46 pm

catchergourmet wrote:
Mon Oct 02, 2023 9:31 am
Deleting the Installation will delete the website?

Can you guys help me what to do step by step?

thank you so much in advance.
Yes, deleting the installation will delete the entire website. Not that that matters as, with that error, I doubt the site is running anyhow. As I said, I never managed to "fix" this error other than deleting and reinstalling. As Per said, you can do this in cPanel. You could also use an FTP program like FileZilla - https://filezilla-project.org/. I recommend, if you're dealing with websites you get a good FTP program. Much simpler for doing many tasks than cPanel.

Once you have a clean slate (don't forget to trash the existing MySQL database and make a new one. I recommend giving it a different name - probably overkill, but to be safe), reinstall your v3.x Joomla site. Have a look at this (or similar) doc - https://www.joomlart.com/blog/joomla-te ... p-tutorial.

When you start your J!4 upgrade, pay very careful attention to what the pre-check squawks about. Granted, after 90+ upgrades, I've found that it actually lies!! :D Everything it squawks about is not necessarily an issue. I use JoomlaCK's products heavily and it complains about these, as well as Akeeba's products, every time. Yet I only make sure I have the most up-to-date J!3 versions before upgrade. I update the extensions fine afterwards. I have found the biggest issues come from, not components, but, first, templates. A J!3 only template will kill your frontend EVERY TIME. Then modules and plugins. Old, outdated versions will, again, kill your frontend, and, sometimes, the admin too.

I suggest, if you're at all in doubt abut your template, switch to Cassieopia before trying to upgrade. Then go through Extensions | Manage and carefully look at every line in conjunction with the pre-check. Root out any outdated installs. Even if you uninstall at this point, you can reinstall later and the database structure will still be there so you shouldn't lose anything.
Ian Shere - Phoenix Website Design & Hosting
http://www.citruskiwi.com
Certified Flight Instructor http://www.flygoodyear.com


Post Reply

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