× If you are using BS MyJspace, please post a rating and a review at the Joomla! Extensions Directory . Thanks!

For each issue topic, post your BS MyJspace version and PHP version + extra information with the 'Report to help BS MyJspace support forum for troubleshooting' from the Backend BS MyJspace Help menu.

question-circle error when i want go to page (com_myjspace&view=pages)

  • saeed
  • saeed's Avatar Topic Author
22 Jul 2017 09:25 #3042 by saeed
saeed created the topic: error when i want go to page (com_myjspace&view=pages)
this is error my version is 2.6.2
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like' 1267
More
22 Jul 2017 14:22 #3044 by bernard
bernard replied the topic: error when i want go to page (com_myjspace&view=pages)
It seems that there is an issue into the query for the component search view. May be charset issue … It's probably due to the usage and environment.

Can you provide more information about your environment and use case, to be able to reproduce the issue?
Do you have more error details into logs? Can you activate the Joomla ‘Global configuraiton’ / ‘system’ system option ‘debug’ = ‘yes’ and recall this page to have the SQL query text into the error message?
  • saeed
  • saeed's Avatar Topic Author
03 Sep 2017 12:10 #3050 by saeed
saeed replied the topic: error when i want go to page (com_myjspace&view=pages)
k
# Function Location
1 () JROOT\libraries\joomla\database\driver\mysqli.php:660
2 JDatabaseDriverMysqli->execute() JROOT\libraries\joomla\database\driver.php:1720
3 JDatabaseDriver->loadResult() JROOT\administrator\components\com_myjspace\views\pages\view.html.php:100
4 MyjspaceViewPages->display() JROOT\libraries\legacy\controller\legacy.php:671
5 JControllerLegacy->display() JROOT\administrator\components\com_myjspace\controller.php:59
6 MyjspaceController->display() JROOT\libraries\legacy\controller\legacy.php:709
7 JControllerLegacy->execute() JROOT\administrator\components\com_myjspace\myjspace.php:33
8 require_once() JROOT\libraries\cms\component\helper.php:389
9 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:364
10 JComponentHelper::renderComponent() JROOT\libraries\cms\application\administrator.php:98
11 JApplicationAdministrator->dispatch() JROOT\libraries\cms\application\administrator.php:156
12 JApplicationAdministrator->doExecute() JROOT\libraries\cms\application\cms.php:265
13 JApplicationCms->execute() JROOT\administrator\index.php:51
  • saeed
  • saeed's Avatar Topic Author
03 Sep 2017 12:14 #3051 by saeed
saeed replied the topic: error when i want go to page (com_myjspace&view=pages)
k
# Function Location
1 () JROOT\libraries\joomla\database\driver\mysqli.php:660
2 JDatabaseDriverMysqli->execute() JROOT\libraries\joomla\database\driver.php:1720
3 JDatabaseDriver->loadResult() JROOT\administrator\components\com_myjspace\views\pages\view.html.php:100
4 MyjspaceViewPages->display() JROOT\libraries\legacy\controller\legacy.php:671
5 JControllerLegacy->display() JROOT\administrator\components\com_myjspace\controller.php:59
6 MyjspaceController->display() JROOT\libraries\legacy\controller\legacy.php:709
7 JControllerLegacy->execute() JROOT\administrator\components\com_myjspace\myjspace.php:33
8 require_once() JROOT\libraries\cms\component\helper.php:389
9 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:364
10 JComponentHelper::renderComponent() JROOT\libraries\cms\application\administrator.php:98
11 JApplicationAdministrator->dispatch() JROOT\libraries\cms\application\administrator.php:156
12 JApplicationAdministrator->doExecute() JROOT\libraries\cms\application\cms.php:265
13 JApplicationCms->execute() JROOT\administrator\index.php:51
More
11 Sep 2017 20:36 #3056 by bernard
bernard replied the topic: error when i want go to page (com_myjspace&view=pages)
Thank you for this additional information. But unfortunately it's not enough to reproduce the issue.

Can you add, as requested at the top of this topic the information with the 'Report to help BS MyJspace support forum for troubleshooting' from the Backend BS MyJspace Help menu.
Can you add information about use cases: are you using categories, Joomla tags, all the updated options in the general option and for the menu option for the 'pages' view ...?
Moderators: bernard