NeDi Community
NeDi Software Specific => Installation => Topic started by: swepart 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
-
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 :-)
-
Tnx,, that solved that issue.
-
can someone tell me how to install the Tool "Library"
over system files - update nedi (replace configuration) ???
an how i can now run the "cable-diagnostics"
-
nobody ?? :(
-
It's intended to copy parts of it into your devtools.php or iftools.php. I'm collection ideas and use cases for sharing with customers. Contact me, if you need any help...