Forum GLPI-Project

Eric Hofland

Member

From: Radboud Universiteit - Holland

Registered: 2006-02-15

Posts: 81

SQL Errors when synchronising with OCSNG

I get following errors in \glpi\files\log\slq-errors.log

02-09-2008 14:34
*** MySQL query error :
***
SQL: SELECT glpi_software.ID as ID, glpi_software.deleted as deleted 
            FROM glpi_software
            WHERE name = \'Skype™ 3.5\' AND is_template=\'0\' AND FK_entities=0
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Backtrace :
C:\Inetpub\wwwroot\glpi\inc\software.function.php:1487        DBmysql->query()
C:\Inetpub\wwwroot\glpi\inc\ocsng.function.php:2948        addSoftwareOrRestoreFromTrash()
C:\Inetpub\wwwroot\glpi\inc\ocsng.function.php:905        ocsUpdateSoftware()
C:\Inetpub\wwwroot\glpi\front\ocsng.sync.php:53        ocsUpdateComputer()
c:\inetpub\wwwroot\glpi\front\ocsng.sync.php

GLPI 0.71.1
Windows 2003 Server
IIS6
PHP 5.2.6

---

Windows 2003 - IIS6  PHP 5.2.5   Mysql 5.0.51
IE8 & Fiefox 4.0

GLPI 0.72.3