Unfortunatelly I see this issue while upgrading.
Upgrading from latest 4.x to 5.x

Unknown column 'post_featured' in 'field list'

#0 /var/www/[my-site]/public_html/system/Db/Db.php(1232): IPS\Db->preparedQuery() #1 /var/www/[my-site]/public_html/applications/core/setup/upg_5000057/upgrade.php(60): IPS\Db->update() #2 /var/www/[my-site]/public_html/applications/core/sources/Setup/Upgrade.php(648): IPS\core\setup\upg_5000057\Upgrade->step1() #3 /var/www/[my-site]/public_html/applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1() #4 /var/www/[my-site]/public_html/applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process() #5 /var/www/[my-site]/public_html/system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}() #6 /var/www/[my-site]/public_html/applications/core/modules/setup/upgrade/upgrade.php(90): IPS\Helpers\MultipleRedirect->__construct() #7 /var/www/[my-site]/public_html/system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage() #8 /var/www/[my-site]/public_html/system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute() #9 /var/www/[my-site]/public_html/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run() #10 {main}

/var/www/[my-site]/public_html/applications/core/setup/upg_5000057/upgrade.php::60

UPDATE forums_posts forums_posts SET post_featured=? WHERE pid IN (SELECT promote_class_id FROM core_content_promote WHERE promote_class=?)

Where do I find database schema in source?

What version are you upgrading from?

Latest 4 to 5.

I've added manually from mysql client:

ALTER TABLE forums_posts

ADD COLUMN post_featured INT UNSIGNED NOT NULL DEFAULT 0;

It worked!

Still, I'm in a process.

Now interesting. I get this:

ALTER TABLE forums_posts ADD( post_score FLOAT NULL , post_score_last_event BIGINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Last time an event occurred which requires the post score to be recalculated', post_share_count BIGINT UNSIGNED NOT NULL DEFAULT 0 , post_quote_count BIGINT UNSIGNED NULL DEFAULT 0 , post_linked_count BIGINT UNSIGNED NOT NULL DEFAULT 0 , post_reaction_count BIGINT NULL DEFAULT 0 , post_view_time INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Average time this post was displayed on screen', post_view_time_view_count INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'The number of times (roughly) this post\'s content was displayed in a browser', post_force_in_summary TINYINT UNSIGNED NOT NULL DEFAULT 0 , post_embed_count BIGINT UNSIGNED NOT NULL DEFAULT 0 , post_featured INT UNSIGNED NOT NULL DEFAULT 0 );

And this gives me:

Duplicate column name 'post_featured'

So now ... I dropped column I created and I did this SQL Query installer gave me.

Upgrade completed. So basically just this error. It looks like installer is at first checking if there is this column and stopping with error. And the next step is to create this column with this big query.

I dropped column I created and then I run everything installer was telling me and it's done.

Glad to hear you got everything updated :)

Do you have any other error logs stored in System Logs or your servers PHP log around the same time you ran into this issue? I believe this is a symptom caused by a different issue.

I've got different issue.

From one plugin creator - I thnink he pointed one issue. For many threads (topics) - I see a lot of spacer.png instead of correct images added in the post.

He told me - at some point of upgrade there was update for posts from v4 to v5. It looks like that didn't went well in my case.

Is there a way to push this process once again? Maybe when I got this error at the beginning that didn't run for all my topics?

Edited March 6Mar 6 by adekk

That's the feedback I have from one plugin creator:

For unknown reason, it adds spacer as image

<a href="//site.amazonaws.com/monthly_2025_02/Dagan_02.jpg.6a4bd1efe6aff7d7b17d8b6231a159d9.jpg" class="ipsAttachLink ipsAttachLink_image ipsRichText__align--block" data-fileid="16528" data-fileext="jpg" rel="">
	<img class="ipsImage ipsImage_thumbnailed" data-fileid="16528" src="https://max3d.pl/applications/core/interface/js/spacer.png" alt="Dagan_02 kopia.jpg" width="1440" loading="lazy">
</a>

I tested another topic https://max3d.pl/forums/topic/103163-porsche-911-sunny-yellow/ which has image, but it uses the old lazyload from v4

<p><a href="//site.amazonaws.com/monthly_2025_02/cam01_pres.jpg.25774402b8990585a2739ec1944e6a68.jpg" class="ipsAttachLink ipsAttachLink_image" ><img data-fileid="16487" src="//max3d.pl/applications/core/interface/js/spacer.png" data-src="//site/monthly_2025_02/cam01_pres.thumb.jpg.38962cea8ccf5dc6be817b1c7b8d8ad9.jpg" data-ratio="150" width="600" class="ipsImage ipsImage_thumbnailed" alt="cam01_pres.jpg"></a></p>

You can see it has data-src

While v5 has class loading="lazy". Test image

How can I rebuild my topics and posts?

Edited March 6Mar 6 by adekk

Could you provide a link to one that is not working, then we can take a look at that?

Can I send you this in private?

As mentioned in the message you sent me, it does indeed seem its background tasks there

But not sure we are talking about same thing. I asked here, but coudn't find the answer. The only option to rebuild anything with posts was this URL so I clicked that. But update got process and it was finished.

I'll wait now and we'll see.

I believe we are, based on what you sent me over. If those are still present on your dashboard, you will indeed be seeing broken content

Rebuilding task is done. No changes. Some topics are corrupted. I mean, the one with graphics.

It looks like that:

I can send you in private example.

But it looks like that - I see the topic, I see image posted by user (from the topic)

But when you want to edit this topic.

It's like that.

When you inspect this element - target link is correct but image is showing spacer.png


<img class="ipsImage ipsImage_thumbnailed" data-fileid="16480" src="//domain.my/applications/core/interface/js/spacer.png" alt="" width="1440">

This is also generating for us issues, when we load posts from API - we get this as image.

What is interesting.
This topic contains this graphic

his

And this graphic is showing at attachment in the topic.

I found out that manual fix is to:

• Edit topic

• Delete that image showing in editor

After that topic is showing just attachment.

But not sure what happened. I did rebuilding of the whole community 2 times. It looks like v4->v5 issue.
Maybe it's editor issue?

The question is - is there some query I can make to fix it?

I have moved this to a ticket so we can investigate this more closely. Please go to your email inbox for next steps.

Thanks. I've sent to your mail more info (with video)