jDiction Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

jDiction 2.2.0 released. http://jdiction.org/downloads

Author Topic: jDiction 2 and Joomla 3.6.2 problem in Global Check-in  (Read 10406 times)

Xtream

  • Newbie
  • *
  • Posts: 13
    • View Profile
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?

« Last Edit: August 26, 2016, 02:16:09 pm by Harald Leithner »
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1688
    • View Profile
Re: jDiction 2 and Joomla 3.6.2 problem in Global Check-in
« Reply #1 on: August 25, 2016, 09:17:23 pm »

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.
Logged
Joomla! 5.0 Release Manager
Vote at JED

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1688
    • View Profile
Re: jDiction 2 and Joomla 3.6.2 problem in Global Check-in
« Reply #2 on: August 26, 2016, 02:15:39 pm »

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?
Logged
Joomla! 5.0 Release Manager
Vote at JED

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1688
    • View Profile
Re: jDiction 2 and Joomla 3.6.2 problem in Global Check-in
« Reply #3 on: August 26, 2016, 02:59:53 pm »

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.
Logged
Joomla! 5.0 Release Manager
Vote at JED

Xtream

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: jDiction 2 and Joomla 3.6.2 problem in Global Check-in
« Reply #4 on: August 26, 2016, 03:17:30 pm »

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?
« Last Edit: August 26, 2016, 03:21:31 pm by Xtream »
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1688
    • View Profile
Re: jDiction 2 and Joomla 3.6.2 problem in Global Check-in
« Reply #5 on: August 26, 2016, 04:10:59 pm »

should work now.
Logged
Joomla! 5.0 Release Manager
Vote at JED

Xtream

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: jDiction 2 and Joomla 3.6.2 problem in Global Check-in
« Reply #6 on: August 26, 2016, 07:20:49 pm »

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.
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1688
    • View Profile
Re: jDiction 2 and Joomla 3.6.2 problem in Global Check-in
« Reply #7 on: August 26, 2016, 07:43:26 pm »

yes thats ok, I have to fix the other database driver.
Logged
Joomla! 5.0 Release Manager
Vote at JED