×
New post ... suspended

Due to Spam, new post are not allowed.

× 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
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

Please Log in to join the conversation.

  • bernard
  • bernard's Avatar
More
22 Jul 2017 14:22 #3044 by bernard
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?

Please Log in to join the conversation.

  • saeed
  • saeed's Avatar Topic Author
03 Sep 2017 12:10 #3050 by saeed
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

Please Log in to join the conversation.

  • saeed
  • saeed's Avatar Topic Author
03 Sep 2017 12:14 #3051 by saeed
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

Please Log in to join the conversation.

  • bernard
  • bernard's Avatar
More
11 Sep 2017 20:36 #3056 by bernard
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 ...?

Please Log in to join the conversation.

Moderators: bernard