1
General Questions / jDiction 2 and Joomla 3.6.2 problem in Global Check-in
« on: August 25, 2016, 09:14:42 pm »
Hello
I have installed clean Joomla 3.6.2 and jDiction 2. My check page:
Version Library Version: 2.0.0
Joomla Version 3.6.2 is ok.
Plugin Joomla Languagefilter Plugin is enabled
JDiction Plugin is enabled.
Database jDiction Database Driver Legacy is selected
Language Seam to be good
Module Module is enabled
Common mistakes It seems that there are no common mistakes.
1) When I want to make a global Check-in I have next error 1267 Illegal mix of collations (utf8mb4_bin,NONE) and (utf8mb4_unicode_ci,IMPLICIT) for operation 'ifnull' SQL=SHOW FULL COLUMNS FROM `#__jd_1_categories`
2) in sql are some strange tables like jd_1_categories, jd_1_contact_details, jd_3_categories ..... with status In use.
3) in Global configuration, in Database Type are two options: Jdiction_mysqli, Jdiction_mysqli_viewxml. Which one do we need to select and what the difference?
I have installed clean Joomla 3.6.2 and jDiction 2. My check page:
Version Library Version: 2.0.0
Joomla Version 3.6.2 is ok.
Plugin Joomla Languagefilter Plugin is enabled
JDiction Plugin is enabled.
Database jDiction Database Driver Legacy is selected
Language Seam to be good
Module Module is enabled
Common mistakes It seems that there are no common mistakes.
1) When I want to make a global Check-in I have next error 1267 Illegal mix of collations (utf8mb4_bin,NONE) and (utf8mb4_unicode_ci,IMPLICIT) for operation 'ifnull' SQL=SHOW FULL COLUMNS FROM `#__jd_1_categories`
2) in sql are some strange tables like jd_1_categories, jd_1_contact_details, jd_3_categories ..... with status In use.
3) in Global configuration, in Database Type are two options: Jdiction_mysqli, Jdiction_mysqli_viewxml. Which one do we need to select and what the difference?