Welcome, Guest. Please login or register.

Author Topic: Nedi 1.9  (Read 244 times)

swepart

  • Newbie
  • *
  • Posts: 33
    • View Profile
Nedi 1.9
« on: September 03, 2019, 10:37:05 PM »
Have tested 1.9 on a small scale and found something that might be a bug or some misconfiguration of my php

when running "noodle"  I get back data that is correct but this  at the same time I get this messages.

nodarp: Illegal mix of collations for operation 'concat'
nodnd: Illegal mix of collations for operation 'concat'
dns: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'concat'
iptrack: Illegal mix of collations for operation 'concat'

I am using
Centos 7
PHP ver 7.2.21
Mariadb mysql  Ver 15.1 Distrib 5.5.60-MariaDB
Apache 2.4.6

/swepart

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2701
    • View Profile
    • NeDi
Re: Nedi 1.9
« Reply #1 on: September 05, 2019, 02:33:58 PM »
This can be seen on various Nedi versions. I don't really know why it occurs, but apparently the encoding should be set upon creating the DB. I'll do this in coming NeDi versions from now on...

In order to fix exiting DBs (NeDi 2.0 will have templates in System-Database):
LTER DATABASE nedi DEFAULT COLLATE utf8_unicode_ci;

Then execute this for every table showing a warning (e.g. devices):
LTER TABLE devices CONVERT TO CHARACTER SET utf8;

Add an A at the beginning (can't post the proper query due to security :-)
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

swepart

  • Newbie
  • *
  • Posts: 33
    • View Profile
Re: Nedi 1.9
« Reply #2 on: September 07, 2019, 02:39:50 AM »
Tnx,, that solved that issue.