Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Xtream]

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?

[Harald Leithner]

The database driver Jdiction_mysqli_viewxml. is the new one that should solve some problems with some components and database queries.

if you select  Jdiction_mysqli you could delete the 'jd_1_categories' views and you can use global checkin again. its a joomla problem that I didn't notice.

I will write a bug report.

[Harald Leithner]

I'm a bit confused I checked this on my installation and don't get this problem...

Could you make a screenshot of your global checking page?

[Harald Leithner]

Ok its another problem, do you have phpmyadmin?

It seams that the collation of the tables are not the same.

2 ways out,
I change the database format to use the legacy one and you delete all #__jd_<number>... tables

second we try to find the problem and how to fix it.

[Xtream]

From the picture in my first topic we can see that clean joomla generate all tables with collation utf8mb4_unicode_ci, but jdiction create table jd_store with collation utf8_general_ci

I deleted all #__jd_<number>... tables and what I need to do next?

[Harald Leithner]

should work now.

[Xtream]

It works only if is selected Jdiction_mysqli and deleted all #__jd_<number>... tables.
If is selected new Jdiction_mysqli_viewxml nothing work, because in data base come back #__jd_<number>... tables.

[Harald Leithner]

yes thats ok, I have to fix the other database driver.