- Posts: 687
- Home
- Forum
- Community Forum
- Report bugs
- [3.0.0] Experience > Gallery tab - issues
Error 500 - Properties List menu item
- joomleb
- Topic Author
- Offline
Less
More
4 years 2 weeks ago #18164
by joomleb
Error 500 - Properties List menu item was created by joomleb
Hi guys,
PHP 7.4.16 + Joomla 3.9.26 + Solidres 2.11.3 Devekoper
Into Properties List menu item, selecting as Default search ordering: "Review Descending", if the properties still have no reviews, I have back an Error 500;
Unknown column 'reviewScore' in 'order clause' Unknown column 'reviewScore' in 'order clause'
Call stack
# Function Location
1 () JROOT/plugins/solidres/hub/components/com_solidres/views/search/view.html.php:337
2 SolidresViewSearch->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
3 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_solidres/controller.php:107
4 SolidresController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
5 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_solidres/solidres.php:18
6 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
7 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
8 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
9 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
10 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203
11 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Expected behaviour: Until there is no any review, a random ordering should be applied...
PHP 7.4.16 + Joomla 3.9.26 + Solidres 2.11.3 Devekoper
Into Properties List menu item, selecting as Default search ordering: "Review Descending", if the properties still have no reviews, I have back an Error 500;
Unknown column 'reviewScore' in 'order clause' Unknown column 'reviewScore' in 'order clause'
Call stack
# Function Location
1 () JROOT/plugins/solidres/hub/components/com_solidres/views/search/view.html.php:337
2 SolidresViewSearch->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
3 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_solidres/controller.php:107
4 SolidresController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
5 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_solidres/solidres.php:18
6 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
7 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
8 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
9 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
10 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203
11 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Expected behaviour: Until there is no any review, a random ordering should be applied...
Please Log in or Create an account to join the conversation.
- solidres
-
- Away
Less
More
- Posts: 2955
4 years 2 weeks ago #18167
by solidres
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Replied by solidres on topic Error 500 - Properties List menu item
Hi,
Please raise a new support ticket and provide us your website info so that we can check it further for you.
Regards,
Please raise a new support ticket and provide us your website info so that we can check it further for you.
Regards,
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Please Log in or Create an account to join the conversation.
Moderators: solidres