Forum GLPI-Project

spheron

Member

Registered: 2007-08-02

Posts: 32

MySQL Error while syncing with OCS

Hallo @all,

having a problem here with the sync from GLPI with OCS. While syncing the existing GLPI computers the message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Guide (v. N/A)')' at line 1

appears. GLPI is running since a few months without any error. :-) There are no duplicate computers in GLPI. I'm using GLPI 0.68.3 on Debian Etch. (Apache 2.2.3-4 / MySQL 5.0.32-7et)

Hope someone can help me... Many Thx

Greets
Marco

spheron

Member

Registered: 2007-08-02

Posts: 32

Re: MySQL Error while syncing with OCS

Sorry, forget the OCS Version: 1.01. At clients the agent V4032 is running.

Greets Marco

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: MySQL Error while syncing with OCS

strange problem.
Do you try with the 0.68.3-2 version of GLPI ?

Could you send us your ocs database to check some things ?

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

spheron

Member

Registered: 2007-08-02

Posts: 32

Re: MySQL Error while syncing with OCS

strange problem.
Do you try with the 0.68.3-2 version of GLPI ?

No, want to do this today...

I will check back later this day when i have done this. I will delete the GLPI Files and the GLPI database. After a clean install of GLPI i try the sync with OCS one more time...

strange problem.
Could you send us your ocs database to check some things ?

Hmm, this are about 150 PC's and the software-inventory of our whole company... In order to be honest i want not to give this data away... Sorry...

Will call back later after installing GLPI new as described above.

Greets
Marco

spheron

Member

Registered: 2007-08-02

Posts: 32

Re: MySQL Error while syncing with OCS

At last Friday i made a clean GLPI (V0.68.3-2) install (new database!)...

No Problems at all... Import works well. Try to make a manual sync later this day...

Greets
Marco

spheron

Member

Registered: 2007-08-02

Posts: 32

Re: MySQL Error while syncing with OCS

Since Friday the cron sync to OCS works properly and without any error.

The message appeared with 0.68.3-1 was not shown again with 0.68.3-2

Thanx for the fast help and sorry again that i could not send you the OCS Database...

Greets
Marco

PS: GLPI is a fascinating piece of OpenSource.... :-)

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: MySQL Error while syncing with OCS

ok thanks for the information.
I close the thread.

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat