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

[catchergourmet]

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

[trogladyte]

@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.

[catchergourmet]

@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?

[Per Yngve Berg]

Use FTP or your host's cpanel.

[catchergourmet]

Hi @Per Yngve Berg,

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

[catchergourmet]

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]

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

[gws]

Enable it in php options on your server cpanel.

[catchergourmet]

Enable it in php options on your server cpanel.

which one from here?

Screenshot 2023-10-02 182343.png

[gws]

which php version is this?
If 8.2 use mysqlind

[catchergourmet]

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'"

[ceford]

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]

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

[catchergourmet]

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]

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]

That doesn't answer my question...

[catchergourmet]

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.

[ceford]

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]

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.

[gws]

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

[Per Yngve Berg]

The FPA is in the Red Frame above.

[ceford]

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.

[trogladyte]

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!! 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.