500 Unknown column 'fp.featured_up' in 'field list' Topic is solved

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
User avatar
TomT
Joomla! Ace
Joomla! Ace
Posts: 1288
Joined: Thu Aug 18, 2005 5:50 am
Location: Amsterdam
Contact:

500 Unknown column 'fp.featured_up' in 'field list'

Post by TomT » Thu Aug 19, 2021 12:38 pm

I updates a 3.10 site to 4.0 and get this error: 500 Unknown column 'fp.featured_up' in 'field list'
What does this mean and how can I solve this?

Friedlieb
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Thu Aug 19, 2021 3:31 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Friedlieb » Thu Aug 19, 2021 3:35 pm

I have the very same problem. In fact, I found this post doing a google search for the error message I got.
And I would like to point out that I very closely obeyed the migration guide.
Standard installation, no special extensions or templates, only multilanguage enabled.
Any help would be greatly appreciated.

User avatar
TomT
Joomla! Ace
Joomla! Ace
Posts: 1288
Joined: Thu Aug 18, 2005 5:50 am
Location: Amsterdam
Contact:

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by TomT » Fri Aug 20, 2021 6:51 am

I did a second update after and made sure there weren't any warnings in the Update Checker. It appeared I had to re-install the contact component which I had uninstalled long ago. When I did this and fixed the database I had no more warnings.
This time after upgrading I didn't get the error.

Friedlieb
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Thu Aug 19, 2021 3:31 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Friedlieb » Fri Aug 20, 2021 11:03 am

No warnings in the Update Checker at my site. The contact component is installed. I will try again in a few days and report further findings.

User avatar
zero24
Joomla! Intern
Joomla! Intern
Posts: 96
Joined: Fri Sep 27, 2013 6:46 am
Contact:

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by zero24 » Fri Aug 20, 2021 9:51 pm

Hi,

can you please got to the configuration.php and set $debug = '1'; and $error_reporting = 'maximum';

And post the result here. Thanks!
Nothing in the world is as fair as the understanding. Because everyone is convinced that he had enough of it. (Rene Descartes, mathematician & philosopher, 1596 - 1650)

Friedlieb
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Thu Aug 19, 2021 3:31 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Friedlieb » Sat Aug 21, 2021 9:34 am

Thanks, zero24. I will do this in my next try.
As first step for this, I restored my saved installation and updated to Joomla 3.10 again. And now, after changing the update channel, the pre-update check does not even appear. This is what I see on the Joomla Update page:

Image

No Pre-Update Check tab here.
I begin to suspect that I am doing something terribly wrong.

User avatar
Pavel-ww
Joomla! Explorer
Joomla! Explorer
Posts: 460
Joined: Tue Jun 30, 2020 12:17 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Pavel-ww » Sat Aug 21, 2021 9:42 am

zero24 wrote:
Fri Aug 20, 2021 9:51 pm
Hi,

can you please got to the configuration.php and set $debug = '1'; and $error_reporting = 'maximum';

And post the result here. Thanks!
Hi.
The same problem on my test site. I deleted everything that is possible, including from the database.

After the update was completed, I get such error.
1.jpg
Home Dashboard is destroyed.
2.jpg
System empty
3.jpg
All errors can see here

Code: Select all

http://teach.webworkers.su/
And here

Code: Select all

Call stack
# 	Function 	Location
1 	() 	JROOT/administrator/modules/mod_popular/src/Helper/PopularHelper.php:82
2 	Joomla\Module\Popular\Administrator\Helper\PopularHelper::getList() 	JROOT/administrator/modules/mod_popular/mod_popular.php:18
3 	include() 	JROOT/libraries/src/Dispatcher/ModuleDispatcher.php:54
4 	Joomla\CMS\Dispatcher\ModuleDispatcher::Joomla\CMS\Dispatcher\{closure}() 	JROOT/libraries/src/Dispatcher/ModuleDispatcher.php:57
5 	Joomla\CMS\Dispatcher\ModuleDispatcher->dispatch() 	JROOT/libraries/src/Helper/ModuleHelper.php:293
6 	Joomla\CMS\Helper\ModuleHelper::renderRawModule() 	JROOT/libraries/src/Helper/ModuleHelper.php:166
7 	Joomla\CMS\Helper\ModuleHelper::renderModule() 	JROOT/administrator/components/com_cpanel/tmpl/cpanel/default.php:62
8 	include() 	JROOT/libraries/src/MVC/View/HtmlView.php:429
9 	Joomla\CMS\MVC\View\HtmlView->loadTemplate() 	JROOT/libraries/src/MVC/View/HtmlView.php:218
10 	Joomla\CMS\MVC\View\HtmlView->display() 	JROOT/administrator/components/com_cpanel/src/View/Cpanel/HtmlView.php:180
11 	Joomla\Component\Cpanel\Administrator\View\Cpanel\HtmlView->display() 	JROOT/libraries/src/MVC/Controller/BaseController.php:692
12 	Joomla\CMS\MVC\Controller\BaseController->display() 	JROOT/administrator/components/com_cpanel/src/Controller/DisplayController.php:54
13 	Joomla\Component\Cpanel\Administrator\Controller\DisplayController->display() 	JROOT/libraries/src/MVC/Controller/BaseController.php:730
14 	Joomla\CMS\MVC\Controller\BaseController->execute() 	JROOT/libraries/src/Dispatcher/ComponentDispatcher.php:146
15 	Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch() 	JROOT/libraries/src/Component/ComponentHelper.php:389
16 	Joomla\CMS\Component\ComponentHelper::renderComponent() 	JROOT/libraries/src/Application/AdministratorApplication.php:143
17 	Joomla\CMS\Application\AdministratorApplication->dispatch() 	JROOT/libraries/src/Application/AdministratorApplication.php:186
18 	Joomla\CMS\Application\AdministratorApplication->doExecute() 	JROOT/libraries/src/Application/CMSApplication.php:278
19 	Joomla\CMS\Application\CMSApplication->execute() 	JROOT/administrator/includes/app.php:63
20 	require_once() 	JROOT/administrator/index.php:32 
You do not have the required permissions to view the files attached to this post.

Friedlieb
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Thu Aug 19, 2021 3:31 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Friedlieb » Sat Aug 21, 2021 10:26 am

Status Update:
I recognized that I was using MySQL 5.5, which is lower than the minimum required version. After moving the database to MySQL 5.7, the pre-update check appeared.
Learning: If using a MySQL version that is too old, the Pre-Update Check will not show up.

Only one problem was indicated by the pre-update check, and I had to uninstall the EN-US language pack. After this the pre-update check was happy and I proceeded.

But after the update, the error is still the same. And, no debug info available on the live site even with $debug = '1'; and $error_reporting = 'maximum'; set. The only improvement with my new try is that the left menu in the admin panel is diplayed. But no modules show up in the system dashboard and no modules can be added.

Any help is appreciated.

User avatar
zero24
Joomla! Intern
Joomla! Intern
Posts: 96
Joined: Fri Sep 27, 2013 6:46 am
Contact:

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by zero24 » Sat Aug 21, 2021 12:01 pm

Hi,

thanks it seems the database upgrade failed can you provide the upgrade log?
IIRC its stored here administrator/logs
Nothing in the world is as fair as the understanding. Because everyone is convinced that he had enough of it. (Rene Descartes, mathematician & philosopher, 1596 - 1650)

User avatar
Pavel-ww
Joomla! Explorer
Joomla! Explorer
Posts: 460
Joined: Tue Jun 30, 2020 12:17 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Pavel-ww » Sat Aug 21, 2021 1:05 pm

zero24 wrote:
Sat Aug 21, 2021 12:01 pm
Hi,

thanks it seems the database upgrade failed can you provide the upgrade log?
IIRC its stored here administrator/logs
Here is my
You do not have the required permissions to view the files attached to this post.

User avatar
zero24
Joomla! Intern
Joomla! Intern
Posts: 96
Joined: Fri Sep 27, 2013 6:46 am
Contact:

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by zero24 » Sun Aug 22, 2021 9:37 am

Hi,

ok the problem is that not all SQL queries for the upgrade have been run. The last that run is: Ran query from file 4.0.0-2018-05-15.

Can you please provide the exact versions of the database as well as try to manually exectute this queries here and let us know what command fails:
https://github.com/joomla/joomla-cms/bl ... -05-15.sql
Nothing in the world is as fair as the understanding. Because everyone is convinced that he had enough of it. (Rene Descartes, mathematician & philosopher, 1596 - 1650)

User avatar
zero24
Joomla! Intern
Joomla! Intern
Posts: 96
Joined: Fri Sep 27, 2013 6:46 am
Contact:

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by zero24 » Sun Aug 22, 2021 9:47 am

And just in case did you updated any of the sites you get this issue one to any J4 development release and restored back to J310? If so please make sure any tables are fully remove before restoring J310 and try again.
Nothing in the world is as fair as the understanding. Because everyone is convinced that he had enough of it. (Rene Descartes, mathematician & philosopher, 1596 - 1650)

User avatar
Pavel-ww
Joomla! Explorer
Joomla! Explorer
Posts: 460
Joined: Tue Jun 30, 2020 12:17 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Pavel-ww » Sun Aug 22, 2021 10:13 am

zero24 wrote:
Sun Aug 22, 2021 9:37 am
Can you please provide the exact versions of the database
Hi. Here is
1.jpg
zero24 wrote:
Sun Aug 22, 2021 9:37 am
as well as try to manually exectute this queries here and let us know what command fails:
https://github.com/joomla/joomla-cms/bl ... -05-15.sql
Thanks. I will try
You do not have the required permissions to view the files attached to this post.

User avatar
Pavel-ww
Joomla! Explorer
Joomla! Explorer
Posts: 460
Joined: Tue Jun 30, 2020 12:17 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Pavel-ww » Sun Aug 22, 2021 10:26 am

zero24 wrote:
Sun Aug 22, 2021 9:47 am
And just in case did you updated any of the sites you get this issue one to any J4 development release and restored back to J310?
No. Only from J310 to J4 Stable. I have backup J3928 and will try from scratch with a clean database

Richard67
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 236
Joined: Fri Sep 16, 2011 6:13 pm
Location: Germany
Contact:

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Richard67 » Sun Aug 22, 2021 11:24 am

When restoring the backup, make sure that it does not only restore database tables and files form the 3.10 but also removes the database tables and files which have been added by the (failed) update to 4.0. Otherwise there will still be tables in database belonging to Joomla 4, and these will cause the next try of the update to fail with primary key violated error.

Same for the files: Restoring the 3.10 backup should include removing the 4.0 files.

User avatar
Pavel-ww
Joomla! Explorer
Joomla! Explorer
Posts: 460
Joined: Tue Jun 30, 2020 12:17 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Pavel-ww » Mon Aug 23, 2021 9:04 am

Richard67 wrote:
Sun Aug 22, 2021 11:24 am
When restoring the backup, make sure that it does not only restore database tables and files form the 3.10 but also removes the database tables and files which have been added by the (failed) update to 4.0. Otherwise there will still be tables in database belonging to Joomla 4, and these will cause the next try of the update to fail with primary key violated error.

Same for the files: Restoring the 3.10 backup should include removing the 4.0 files.
Hi @Richard67. Thanks for the direction of this path. I started from scratch and carefully cleaned the database. After that, migration was successful.

Hi @zero24. Thank you for your participation. The problem was in a dirty database.

User avatar
zero24
Joomla! Intern
Joomla! Intern
Posts: 96
Joined: Fri Sep 27, 2013 6:46 am
Contact:

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by zero24 » Mon Aug 23, 2021 10:17 am

I'm very glad to hear that, thanks for your update.
Nothing in the world is as fair as the understanding. Because everyone is convinced that he had enough of it. (Rene Descartes, mathematician & philosopher, 1596 - 1650)

Richard67
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 236
Joined: Fri Sep 16, 2011 6:13 pm
Location: Germany
Contact:

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Richard67 » Mon Aug 23, 2021 10:37 am

Yes, am glad, too.

Friedlieb
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Thu Aug 19, 2021 3:31 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Friedlieb » Wed Aug 25, 2021 2:56 pm

zero24 wrote:
Sat Aug 21, 2021 12:01 pm
thanks it seems the database upgrade failed can you provide the upgrade log?
IIRC its stored here administrator/logs
Unfortunately, I restored my backup of 3.10 before reading this, so I did not save the upgrade log. But I made a screenshot of the "success message" the updater gave me:
Image

Richard67 wrote:
Sun Aug 22, 2021 11:24 am
When restoring the backup, make sure that it does not only restore database tables and files form the 3.10 but also removes the database tables and files which have been added by the (failed) update to 4.0.
...
Same for the files: Restoring the 3.10 backup should include removing the 4.0 files.
I did this, started from a backup of a clean directory and database I created while on 3.10.
If someone has another suggestion, I will try again. Thank you!

Friedlieb
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Thu Aug 19, 2021 3:31 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Friedlieb » Fri Sep 10, 2021 1:13 pm

Today, I tried again, from Joomla 3.10.1 to Joomla 4.0.2, and got the exact same results as above. Installer log claims success, every database query went okay according to the log. The table #_history is not even mentioned in the log. Also, the JInstaller error shown in the screenshot above does not appear in the log.

PHP 7.4.23, MySQL 5.7.33.
Any ideas are appreciated.

RobertoCravallo
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sun Sep 19, 2021 2:40 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by RobertoCravallo » Sun Sep 19, 2021 2:43 pm

Pavel-ww wrote:
Mon Aug 23, 2021 9:04 am
Richard67 wrote:
Sun Aug 22, 2021 11:24 am
but also removes the database tables and files which have been added by the (failed) update to 4.0.
Hi @Richard67. Thanks for the direction of this path. I started from scratch and carefully cleaned the database. After that, migration was successful.

Hi @zero24. Thank you for your participation. The problem was in a dirty database.
Having the same problem! But which database tables and files are added by a failed update? Actually, I am pretty sure, that I have a clean database. As I always deleted everything and restored with AKEEBA, after the fail. Did not use DROP ALL when reinstalling, so there might be some sort of garbage in the database. But what does not belong in a 3.x installation?

User avatar
Pavel-ww
Joomla! Explorer
Joomla! Explorer
Posts: 460
Joined: Tue Jun 30, 2020 12:17 pm

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Pavel-ww » Sun Sep 19, 2021 4:17 pm

It is not always enough to uninstall an extension to clean up the database. In my case, it was Fabrik. Even after the uninstall, its tables remain in the database.

It is also an important point, recovery after unsuccessful attempt must be done to a new database, but not to the existing one.

jarosz
Joomla! Apprentice
Joomla! Apprentice
Posts: 35
Joined: Thu Dec 13, 2007 9:15 am

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by jarosz » Fri Sep 24, 2021 10:10 am

I get the same problem when updating a Joomla 3.10.2 site to 4.0.3.
I may have some obsolete tables in the database; should there be any tables of type MyISAM in the db or should I drop them all?

Donethat
Joomla! Explorer
Joomla! Explorer
Posts: 346
Joined: Fri May 30, 2008 12:36 pm
Location: Redhill
Contact:

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Donethat » Tue Sep 28, 2021 11:12 am

I am getting this error.

I have worked through this forum making the changes suggested to no avail

Cleaned the database
Disabled nearly all the extension, excluding Joomla core of course.
No warning on update page

Example error, libraries/src/Menu/SiteMenu.php (line 155):

Code: Select all

 )                ->bind(':currentDate2', $currentDate)                ->order($this->db->quoteName('m.lft'));            $items    = [];            $iterator = $this->db->setQuery($query)->getIterator();            foreach ($iterator as $item)            {                $items[$item->id] = new MenuItem((array) $item);            }
I have 30 websites that will need to be updated, this is not sustainable!

Come on Joomla team, it shouldn't be this hard.
Perfection is a state of mind, not reality
www.cavespider.co.uk

Donethat
Joomla! Explorer
Joomla! Explorer
Posts: 346
Joined: Fri May 30, 2008 12:36 pm
Location: Redhill
Contact:

Re: 500 Unknown column 'fp.featured_up' in 'field list'

Post by Donethat » Thu Sep 30, 2021 9:33 am

I give up. I have stripped this website down to it's bare bones. Cleaned out the database of anything that shouldn't be there. No warnings on the update page so should be all clear to go. Still get the same error, aaarrggh.

I have done a fresh install of V4 on the server which was fine.

Even followed the step by Step on https://docs.joomla.org/Joomla_3.x_to_4 ... _Migration

Any ideas would be much appreciated

As before:

libraries/src/Menu/SiteMenu.php (line 155)

Code: Select all

 )                ->bind(':currentDate2', $currentDate)                ->order($this->db->quoteName('m.lft'));            $items    = [];            $iterator = $this->db->setQuery($query)->getIterator();            foreach ($iterator as $item)            {                $items[$item->id] = new MenuItem((array) $item);            }
Perfection is a state of mind, not reality
www.cavespider.co.uk


Post Reply

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