×
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.
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.
error when i want go to page (com_myjspace&view=pages)
- saeed
- Topic Author
22 Jul 2017 09:25 #3042
by saeed
error when i want go to page (com_myjspace&view=pages) was created 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
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
Less
More
- Posts: 891
22 Jul 2017 14:22 #3044
by bernard
Replied by bernard on 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?
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
- Topic Author
03 Sep 2017 12:10 #3050
by saeed
Replied by saeed on 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
# 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
- Topic Author
03 Sep 2017 12:14 #3051
by saeed
Replied by saeed on 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
# 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
Less
More
- Posts: 891
11 Sep 2017 20:36 #3056
by bernard
Replied by bernard on 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 ...?
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