500 Unknown column 'fp.featured_up' in 'field list' Topic is solved
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.
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.
- TomT
- Joomla! Ace
- Posts: 1324
- Joined: Thu Aug 18, 2005 5:50 am
- Location: Amsterdam
- Contact:
500 Unknown column 'fp.featured_up' in 'field list'
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?
What does this mean and how can I solve this?
-
- Joomla! Apprentice
- Posts: 6
- Joined: Thu Aug 19, 2021 3:31 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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.
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.
- TomT
- Joomla! Ace
- Posts: 1324
- Joined: Thu Aug 18, 2005 5:50 am
- Location: Amsterdam
- Contact:
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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.
This time after upgrading I didn't get the error.
-
- Joomla! Apprentice
- Posts: 6
- Joined: Thu Aug 19, 2021 3:31 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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.
- zero24
- Joomla! Enthusiast
- Posts: 119
- Joined: Fri Sep 27, 2013 6:46 am
- Contact:
Re: 500 Unknown column 'fp.featured_up' in 'field list'
Hi,
can you please got to the configuration.php and set $debug = '1'; and $error_reporting = 'maximum';
And post the result here. Thanks!
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)
-
- Joomla! Apprentice
- Posts: 6
- Joined: Thu Aug 19, 2021 3:31 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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:
No Pre-Update Check tab here.
I begin to suspect that I am doing something terribly wrong.
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:
No Pre-Update Check tab here.
I begin to suspect that I am doing something terribly wrong.
- Pavel-ww
- Joomla! Ace
- Posts: 1614
- Joined: Tue Jun 30, 2020 12:17 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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. Home Dashboard is destroyed. System empty All errors can see here
Code: Select all
http://teach.webworkers.su/
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.
-
- Joomla! Apprentice
- Posts: 6
- Joined: Thu Aug 19, 2021 3:31 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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.
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.
- zero24
- Joomla! Enthusiast
- Posts: 119
- Joined: Fri Sep 27, 2013 6:46 am
- Contact:
Re: 500 Unknown column 'fp.featured_up' in 'field list'
Hi,
thanks it seems the database upgrade failed can you provide the upgrade log?
IIRC its stored here administrator/logs
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)
- Pavel-ww
- Joomla! Ace
- Posts: 1614
- Joined: Tue Jun 30, 2020 12:17 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
Here is my
You do not have the required permissions to view the files attached to this post.
- zero24
- Joomla! Enthusiast
- Posts: 119
- Joined: Fri Sep 27, 2013 6:46 am
- Contact:
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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
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)
- zero24
- Joomla! Enthusiast
- Posts: 119
- Joined: Fri Sep 27, 2013 6:46 am
- Contact:
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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)
- Pavel-ww
- Joomla! Ace
- Posts: 1614
- Joined: Tue Jun 30, 2020 12:17 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
Hi. Here is
Thanks. I will tryzero24 wrote: ↑Sun Aug 22, 2021 9:37 amas 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
You do not have the required permissions to view the files attached to this post.
- Pavel-ww
- Joomla! Ace
- Posts: 1614
- Joined: Tue Jun 30, 2020 12:17 pm
-
- Joomla! Explorer
- Posts: 270
- Joined: Fri Sep 16, 2011 6:13 pm
- Location: Germany
- Contact:
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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.
Same for the files: Restoring the 3.10 backup should include removing the 4.0 files.
- Pavel-ww
- Joomla! Ace
- Posts: 1614
- Joined: Tue Jun 30, 2020 12:17 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
Hi @Richard67. Thanks for the direction of this path. I started from scratch and carefully cleaned the database. After that, migration was successful.Richard67 wrote: ↑Sun Aug 22, 2021 11:24 amWhen 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 @zero24. Thank you for your participation. The problem was in a dirty database.
- zero24
- Joomla! Enthusiast
- Posts: 119
- Joined: Fri Sep 27, 2013 6:46 am
- Contact:
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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)
-
- Joomla! Explorer
- Posts: 270
- Joined: Fri Sep 16, 2011 6:13 pm
- Location: Germany
- Contact:
Re: 500 Unknown column 'fp.featured_up' in 'field list'
Yes, am glad, too.
-
- Joomla! Apprentice
- Posts: 6
- Joined: Thu Aug 19, 2021 3:31 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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:
I did this, started from a backup of a clean directory and database I created while on 3.10.Richard67 wrote: ↑Sun Aug 22, 2021 11:24 amWhen 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.
If someone has another suggestion, I will try again. Thank you!
-
- Joomla! Apprentice
- Posts: 6
- Joined: Thu Aug 19, 2021 3:31 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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.
PHP 7.4.23, MySQL 5.7.33.
Any ideas are appreciated.
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sun Sep 19, 2021 2:40 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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?
- Pavel-ww
- Joomla! Ace
- Posts: 1614
- Joined: Tue Jun 30, 2020 12:17 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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.
It is also an important point, recovery after unsuccessful attempt must be done to a new database, but not to the existing one.
-
- Joomla! Apprentice
- Posts: 36
- Joined: Thu Dec 13, 2007 9:15 am
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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?
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?
-
- Joomla! Explorer
- Posts: 434
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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):
I have 30 websites that will need to be updated, this is not sustainable!
Come on Joomla team, it shouldn't be this hard.
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); }
Come on Joomla team, it shouldn't be this hard.
Perfection is a state of mind, not reality
www.cavespider.co.uk
www.cavespider.co.uk
-
- Joomla! Explorer
- Posts: 434
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Re: 500 Unknown column 'fp.featured_up' in 'field list'
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)
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
www.cavespider.co.uk
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sun Feb 06, 2022 5:14 am
Re: 500 Unknown column 'fp.featured_up' in 'field list'
In case anyone else is still having this issue, this might help you.
1. Open the joomla database in your favorite tool
a. Find the largest moduleid in the #__modules_menu table.
b. Find the largest id in the in the #__modules table.
If the value of b is smaller than a, then you are likely seeing the same issue and can fix with step 2.
2. Open the website admin "Extension:Module Manager". Create dummy modules until you reach the ID (the module ID is last column of table) the you found in step 1a.
You should now be able to upgrade assuming there aren't any other problems.
---
Here's a bit more detail in case someone who works on Joomla wants to update the Joomla upgrade code.
The root cause of the errors reported after the upgrade is that some SQL tables have not been upgraded. The specific problem is that the SQL statement on line 30 of this file fails: https://github.com/joomla/joomla-cms/bl ... -07-13.sql
Line 29 inserts a module into the __modules table. Line 30 uses the newly inserted id from line 29 to insert into the __modules_menu table assumeing that the new id is not in the table. I'm not sure how it gets into a state where this isn't true, but if I had to guess, deleting an extension that a module uses might delete the module but is missing the code to update the the modules_menu table.
1. Open the joomla database in your favorite tool
a. Find the largest moduleid in the #__modules_menu table.
b. Find the largest id in the in the #__modules table.
If the value of b is smaller than a, then you are likely seeing the same issue and can fix with step 2.
2. Open the website admin "Extension:Module Manager". Create dummy modules until you reach the ID (the module ID is last column of table) the you found in step 1a.
You should now be able to upgrade assuming there aren't any other problems.
---
Here's a bit more detail in case someone who works on Joomla wants to update the Joomla upgrade code.
The root cause of the errors reported after the upgrade is that some SQL tables have not been upgraded. The specific problem is that the SQL statement on line 30 of this file fails: https://github.com/joomla/joomla-cms/bl ... -07-13.sql
Line 29 inserts a module into the __modules table. Line 30 uses the newly inserted id from line 29 to insert into the __modules_menu table assumeing that the new id is not in the table. I'm not sure how it gets into a state where this isn't true, but if I had to guess, deleting an extension that a module uses might delete the module but is missing the code to update the the modules_menu table.
-
- Joomla! Explorer
- Posts: 434
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Re: 500 Unknown column 'fp.featured_up' in 'field list'
Thank you. That is really helpful.
I will give it a go at the next opportunity. Fairly soon I suspect.
All the best
I will give it a go at the next opportunity. Fairly soon I suspect.
All the best
Perfection is a state of mind, not reality
www.cavespider.co.uk
www.cavespider.co.uk
-
- Joomla! Explorer
- Posts: 434
- Joined: Fri May 30, 2008 12:36 pm
- Location: Redhill
- Contact:
Re: 500 Unknown column 'fp.featured_up' in 'field list'
I have now tried this on one of my sites and the site migrated without problems.
Next, one that I know has problems migrating to 4
Next, one that I know has problems migrating to 4
Perfection is a state of mind, not reality
www.cavespider.co.uk
www.cavespider.co.uk
-
- Joomla! Fledgling
- Posts: 1
- Joined: Mon Feb 07, 2022 9:43 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
Hi all,
I've seen that this error seems not to be specific to the migration from 3.10.(5) to 4.0.(6).
I am running my site since about 2003 with Joomla (started with 1.xx) and got now stuck while migrating from 3.10.5 to 4.0.6.
I've read a lot about this error, followed the step by step migration instructions, checked incompatible elements, deleted my database, restored it by Akeeba backup (not modified by previous migration to 4.0.6) but I am always ending with the same error message (and empty control panel and system menue) after upgrading to 4.0.6:
the above mentioned error and
"mydatabasename".jsd_history does not exist.
Moreover "JInstaller: : Install: Error SQL Duplicate entry '1' for key 'Primary'
It seems to be a problem with the database. However, it is not clear for me where and what I would need to do.
Any help is very appreciated!
Thanks in advance!
Here comes the FPA report before migrating to 4.0.6
I've seen that this error seems not to be specific to the migration from 3.10.(5) to 4.0.(6).
I am running my site since about 2003 with Joomla (started with 1.xx) and got now stuck while migrating from 3.10.5 to 4.0.6.
I've read a lot about this error, followed the step by step migration instructions, checked incompatible elements, deleted my database, restored it by Akeeba backup (not modified by previous migration to 4.0.6) but I am always ending with the same error message (and empty control panel and system menue) after upgrading to 4.0.6:
the above mentioned error and
"mydatabasename".jsd_history does not exist.
Moreover "JInstaller: : Install: Error SQL Duplicate entry '1' for key 'Primary'
It seems to be a problem with the database. However, it is not clear for me where and what I would need to do.
Any help is very appreciated!
Thanks in advance!
Here comes the FPA report before migrating to 4.0.6
Forum Post Assistant (v1.6.5) : 12-Feb-2022 wrote:Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.10.5-Stable (Daraja) 15-January-2022
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Writable (644) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: No | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 30 | Session handler: database | Shared sessions: false | SSL: 0 | Error Reporting: none | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.10.5: Yes | Database Supports J! 3.10.5: Yes | Database Credentials Present: Yes |
Host Configuration :: OS: Linux | OS Version: 4.9.0-12-amd64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 498.00 GiB |
PHP Configuration :: Version: 7.4.27 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 22527 | Log Errors To: /var/www/web35/logs/priv/php_errors.log | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: /var/www/web35/html/:/var/www/web35/apps/:/var/www/web35/priv/:/var/www/web35/tmp/:/usr/share/pear/:/usr/share/php/:/tmp/ | Uploads: 1 | Max. Upload Size: 128M | Max. POST Size: 128M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 64M
Database Configuration :: Version: 5.5.5-10.1.48-MariaDB-0+deb9u2 (Client:mysqlnd 7.4.27) | Database Size: 19.99 MiB | #of Tables with config prefix: 154 | #of other Tables: 207 | User Privileges : GRANT ALLDetailed Environment :: wrote:PHP Extensions :: Core (7.4.27) | date (7.4.27) | libxml (7.4.27) | openssl (7.4.27) | pcre (7.4.27) | zlib (7.4.27) | filter (7.4.27) | hash (7.4.27) | mbstring (7.4.27) | Reflection (7.4.27) | SPL (7.4.27) | session (7.4.27) | xml (7.4.27) | cgi-fcgi (7.4.27) | bcmath (7.4.27) | bz2 (7.4.27) | calendar (7.4.27) | ctype (7.4.27) | curl (7.4.27) | dom (20031129) | standard (7.4.27) | fileinfo (7.4.27) | ftp (7.4.27) | gd (7.4.27) | gettext (7.4.27) | gmp (7.4.27) | iconv (7.4.27) | imagick (3.5.0) | imap (7.4.27) | intl (7.4.27) | json (7.4.27) | mysqlnd (mysqlnd 7.4.27) | mysqli (7.4.27) | PDO (7.4.27) | pdo_mysql (7.4.27) | pdo_sqlite (7.4.27) | Phar (7.4.27) | posix (7.4.27) | readline (7.4.27) | exif (7.4.27) | SimpleXML (7.4.27) | soap (7.4.27) | sockets (7.4.27) | sodium (7.4.27) | sqlite3 (7.4.27) | sysvmsg (7.4.27) | sysvsem (7.4.27) | sysvshm (7.4.27) | tokenizer (7.4.27) | xmlreader (7.4.27) | xmlwriter (7.4.27) | xsl (7.4.27) | zip (1.15.6) | Zend OPcache (7.4.27) | Zend Engine (3.4.0) |
Potential Missing Extensions ::
Disabled Functions :: show_source | highlight_file | apache_child_terminate | apache_get_modules | apache_note | apache_setenv | virtual | dl | disk_total_space | posix_getpwnam | posix_getpwuid | posix_mkfifo | posix_mknod | posix_setpgid | posix_setsid | posix_setuid | posix_uname | proc_nice | openlog | syslog | pfsockopen |
Switch User Environment :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Potential Ownership Issues: NoFolder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) |
Elevated Permissions (First 10) ::Database Information :: wrote:Database statistics :: Uptime: 5194736 | Threads: 7 | Questions: 226623990 | Slow queries: 2340 | Opens: 105825312 | Flush tables: 1 | Open tables: 2000 | Queries per second avg: 43.625 |Extensions Discovered :: wrote:Components :: Site ::
Core :: com_wrapper (3.0.0) 1 | com_mailto (3.0.0) 1 |
3rd Party::
Components :: Admin ::
Core :: com_messages (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_admin (3.0.0) 1 | com_banners (3.0.0) 1 | com_checkin (3.0.0) 1 | com_finder (3.0.0) 1 | com_joomlaupdate (3.10.1) 1 | com_modules (3.0.0) 1 | com_config (3.0.0) 1 | com_installer (3.0.0) 1 | com_media (3.0.0) 1 | com_associations (3.7.0) 1 | com_languages (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_categories (3.0.0) 1 | com_cache (3.0.0) 1 | com_fields (3.7.0) 1 | com_cpanel (3.0.0) 1 | com_privacy (3.9.0) 1 | com_weblinks (3.9.0) 1 | com_menus (3.0.0) 1 | com_contenthistory (3.2.0) 1 | com_tags (3.1.0) 1 | com_content (3.0.0) 1 | com_templates (3.0.0) 1 | com_plugins (3.0.0) 1 | com_ajax (3.2.0) 1 | com_users (3.0.0) 1 | com_redirect (3.0.0) 1 | com_login (3.0.0) 1 | com_search (3.0.0) 1 | com_newsfeeds (3.0.0) 1 |
3rd Party:: Akeeba (8.1.0) 1 | Admintools (6.1.5) 1 |
Modules :: Site ::
Core :: mod_menu (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_languages (3.5.0) 1 | mod_stats (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_weblinks (3.9.0) 1 | mod_syndicate (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_whosonline (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_login (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_search (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_articles_categories (3.0.0) 1 |
3rd Party:: mod_matukio_timeline (3.0.7) 0 |
Modules :: Admin ::
Core :: mod_menu (3.0.0) 1 | mod_status (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_custom (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_submenu (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_login (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_title (3.0.0) 1 | mod_version (3.0.0) 1 | mod_sampledata (3.8.0) 1 |
3rd Party::
Libraries ::
Core ::
3rd Party:: file_fof30 (3.6.2) ? | file_fof40 (4.1.0) ? |
Plugins ::
Core :: plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_authentication_cookie (3.0.0) 0 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_fields_url (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_search_tags (3.0.0) 0 | plg_search_newsfeeds (3.0.0) 1 | plg_search_weblinks (3.9.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_system_sef (3.0.0) 1 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 0 | plg_system_fields (3.7.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_cache (3.0.0) 0 | plg_system_stats (3.5.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_highlight (3.0.0) 1 | plg_system_weblinks (3.9.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_redirect (3.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_p3p (3.0.0) 1 | plg_system_languagecode (3.0.0) 0 | plg_system_logout (3.0.0) 1 | plg_system_languagefilter (3.0.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_captcha_recaptcha (3.4.0) 1 | plg_finder_tags (3.0.0) 0 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_weblinks (3.9.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_installer_webinstaller (2.1.2) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_weblink (3.9.0) 0 | plg_editors-xtd_menu (3.7.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_eos310 (3.10.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_pagenavigation (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_finder (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 |
3rd Party:: PLG_SYSTEM_BACKUPONUPDATE (8.1.0) 1 | PLG_SYSTEM_ADMINTOOLS (6.1.5) 1 | plg_editors_codemirror (5.60.0) 1 | plg_editors_tinymce (4.5.12) 1 | plg_quickicon_akeebabackup (8.1.0) 1 | PLG_ACTIONLOG_AKEEBABACKUP (8.1.0) 0 | PLG_ACTIONLOG_ADMINTOOLS (6.1.5) 0 |Templates Discovered :: wrote:Templates :: Site :: protostar (1.0) 0 | flowerbeez (1.0.1) 0 | beez3 (3.1.0) 1 | rhuk_milkyway (1.0.2) 0 | JA_Purity (1.2.0) ? | go_roundy (1.0.1) 0 |
Templates :: Admin :: isis (1.0) 1 | hathor (3.0.0) 1 |
Last edited by toivo on Sun Feb 13, 2022 1:58 am, edited 1 time in total.
Reason: mod note: disabled smilies in post Options for readability
Reason: mod note: disabled smilies in post Options for readability
-
- Joomla! Fledgling
- Posts: 3
- Joined: Wed Feb 05, 2020 6:36 pm
Re: 500 Unknown column 'fp.featured_up' in 'field list'
hi
I have exactly the same problem as rendance on one of my Joomla 3.10.5 websites.I have also tried everything as far as I know; even the latest hint from rokyu did not bring any solution.
I have already migrated a few sites from 3.10 to 4.06 or 4.1 (no problems), but this one site just won't upgrade, it's really frustrating.
wolf.
I have exactly the same problem as rendance on one of my Joomla 3.10.5 websites.I have also tried everything as far as I know; even the latest hint from rokyu did not bring any solution.
I have already migrated a few sites from 3.10 to 4.06 or 4.1 (no problems), but this one site just won't upgrade, it's really frustrating.
wolf.