After enable module i get this error in home page
The website encountered an unexpected error. Please try again later.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."theme_code"' at line 7: SELECT "s"."id" AS "id", "sp"."pattern" AS "pattern", "st"."theme_code" AS "theme_code", GROUP_CONCAT(sr.role_code) AS "roles" FROM "switch_theme" "s" INNER JOIN "switch_theme_role" "sr" ON s.id = sr.switch_theme_id INNER JOIN "switch_theme_pattern" "sp" ON s.id = sp.switch_theme_id INNER JOIN "switch_theme_theme" "st" ON s.id = st.switch_theme_id GROUP BY "s"."idsp"."patternst"."theme_code"; Array ( ) in Drupal\switch_theme\SwitchthemeManager->getSwitchThemes() (line 41 of modules/contrib/switch_theme/src/SwitchthemeManager.php).
Drupal\Core\Database\StatementWrapper->execute(Array, Array) (Line: 946)
Drupal\Core\Database\Connection->query('SELECT "s"."id" AS "id", "sp"."pattern" AS "pattern", "st"."theme_code" AS "theme_code", GROUP_CONCAT(sr.role_code) AS "roles"
FROM
{switch_theme} "s"
INNER JOIN {switch_theme_role} "sr" ON s.id = sr.switch_theme_id
INNER JOIN {switch_theme_pattern} "sp" ON s.id = sp.switch_theme_id
INNER JOIN {switch_theme_theme} "st" ON s.id = st.switch_theme_id
GROUP BY "s"."idsp"."patternst"."theme_code"', Array, Array) (Line: 525)
Drupal\Core\Database\Query\Select->execute() (Line: 41)
Drupal\switch_theme\SwitchthemeManager->getSwitchThemes() (Line: 68)
Drupal\switch_theme\Theme\ThemeNegotiator->applies(Object) (Line: 67)
Drupal\Core\Theme\ThemeNegotiator->determineActiveTheme(Object) (Line: 405)
Drupal\Core\Theme\ThemeManager->initTheme(Object) (Line: 96)
Drupal\Core\Theme\ThemeManager->getActiveTheme() (Line: 56)
Drupal\block\BlockRepository->getVisibleBlocksPerRegion(Array) (Line: 137)
Drupal\block\Plugin\DisplayVariant\BlockPageVariant->build() (Line: 274)
Drupal\Core\Render\MainContent\HtmlRenderer->prepare(Array, Object, Object) (Line: 132)
Drupal\Core\Render\MainContent\HtmlRenderer->renderResponse(Array, Object, Object) (Line: 90)
Drupal\Core\EventSubscriber\MainContentViewSubscriber->onViewRenderArray(Object, 'kernel.view', Object)
call_user_func(Array, Object, 'kernel.view', Object) (Line: 142)
Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch(Object, 'kernel.view') (Line: 174)
Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 2) (Line: 81)
Symfony\Component\HttpKernel\HttpKernel->handle(Object, 2, 1) (Line: 58)
Drupal\Core\StackMiddleware\Session->handle(Object, 2, 1) (Line: 48)
Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object, 2, 1) (Line: 106)
Drupal\page_cache\StackMiddleware\PageCache->pass(Object, 2, 1) (Line: 85)
Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 2, 1) (Line: 48)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 2, 1) (Line: 51)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 2, 1) (Line: 23)
Stack\StackedHttpKernel->handle(Object, 2) (Line: 166)
Drupal\Core\EventSubscriber\DefaultExceptionHtmlSubscriber->makeSubrequest(Object, '/system/403', 403) (Line: 112)
Drupal\Core\EventSubscriber\DefaultExceptionHtmlSubscriber->on403(Object) (Line: 109)
Drupal\Core\EventSubscriber\HttpExceptionSubscriberBase->onException(Object, 'kernel.exception', Object)
call_user_func(Array, Object, 'kernel.exception', Object) (Line: 142)
Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch(Object, 'kernel.exception') (Line: 229)
Symfony\Component\HttpKernel\HttpKernel->handleThrowable(Object, Object, 1) (Line: 92)
Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 58)
Drupal\Core\StackMiddleware\Session->handle(Object, 1, 1) (Line: 48)
Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object, 1, 1) (Line: 191)
Drupal\page_cache\StackMiddleware\PageCache->fetch(Object, 1, 1) (Line: 128)
Drupal\page_cache\StackMiddleware\PageCache->lookup(Object, 1, 1) (Line: 82)
Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 1, 1) (Line: 48)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 51)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 23)
Stack\StackedHttpKernel->handle(Object, 1, 1) (Line: 718)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)
Install module and got to home page
Fixed
1.0
Code
Hi,
my bad, after some investigations, the release 1.0.0 is not the last one ( :/ ) , 1.1.0 is. I updated it on the drupal module page.
So, you just need to desinstall the current switch theme module & take the release 1.1.0 (via composer or manually) & install it.
Sorry for this inconvenience !
Pleasure
Automatically closed - issue fixed for 2 weeks with no activity.