You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

Pages: 1

#1 2009-01-15 17:54:32

unital
Member
From: Paris
Registered: 2009-01-13
Posts: 28

Bug suite à mis à jour

Bonjour à tous
alors nous avons un ptit soucis sur glpi nous avons un bug et nous ne pouvons plus nous connecter avec le nom d'utilisateur glpi ou les autres suite à la mise à jour  0.71.3

c'est une debian avec Apache/2.2.3 (Debian) PHP/5.2.0-8+etch13 mod_perl/2.0.2 Perl/v5.8.8
memroy_limit à 60M

Tout à été installé depuis le serveur lui meme sans soucis

nous avons fait le lien avec notre serveur ldap

voici les log

dans le fichier sql-errors.log  (pas de fichier php-error)

05-01-2009 12:00
*** MySQL query error :
***
SQL: SELECT hostgroup.hg_name AS name_group, hostgroup.hg_id AS id_group, hostgroup.hg_alias AS alias, hostgroup_relation.hostgroup_hg_id AS d_type, count( * ) AS cmp
            FROM hostgroup_relation
            LEFT JOIN hostgroup ON ( hostgroup.hg_id = hostgroup_relation.hostgroup_hg_id )
            GROUP BY hostgroup_relation.hostgroup_hg_id, hostgroup.hg_id, hostgroup.hg_name
            ORDER BY hostgroup.hg_name,hostgroup_relation.hostgroup_hg_id
Error: Table 'Centreon_DB.hostgroup_relation' doesn't exist
Backtrace :
/var/www/glpi/plugins/centreon/inc/plugin_centreon.functions_display.host.php:69        DBmysql->query()
/var/www/glpi/plugins/centreon/front/plugin_centreon.index.php:62        plugin_centreon_showListGroupHost()
/var/www/glpi/plugins/centreon/front/plugin_centreon.index.php
05-01-2009 12:00
*** MySQL query error :
***
SQL: SELECT servicegroup.sg_name AS name_group, servicegroup.sg_id AS id_group, servicegroup.sg_alias AS alias, servicegroup_relation.servicegroup_sg_id AS d_type, count( * ) AS cmp
            FROM servicegroup_relation
            LEFT JOIN servicegroup ON ( servicegroup.sg_id = servicegroup_relation.servicegroup_sg_id )
            GROUP BY servicegroup_relation.servicegroup_sg_id, servicegroup.sg_id, servicegroup.sg_name
            ORDER BY servicegroup.sg_name, servicegroup_relation.servicegroup_sg_id
Error: Table 'Centreon_DB.servicegroup_relation' doesn't exist
Backtrace :
/var/www/glpi/plugins/centreon/inc/plugin_centreon.functions_display.service.php:87        DBmysql->query()
/var/www/glpi/plugins/centreon/front/plugin_centreon.index.php:71        plugin_centreon_showListGroup()
/var/www/glpi/plugins/centreon/front/plugin_centreon.index.php
05-01-2009 17:30
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
06-01-2009 14:37
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
06-01-2009 14:37
*** MySQL query error :
***
SQL:     SELECT host.* FROM host where (host.host_name LIKE \'%%\')  ORDER BY host.host_name ASC
Error: Table 'Centreon_DB.host' doesn't exist
Backtrace :
/var/www/glpi/plugins/centreon/inc/plugin_centreon.functions_search.host.php:162        DBmysql->query()
/var/www/glpi/plugins/centreon/front/index-host.php:57        plugin_centreon_showHostList()
/var/www/glpi/plugins/centreon/front/index-host.php
06-01-2009 17:30
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
06-01-2009 18:04
*** MySQL query error :
***
SQL: INSERT INTO glpi_connect_wire (end1,end2,type) VALUES (\'5\',\'3\',\'3\')
Error: Duplicate entry '5-3-3' for key 2
Backtrace :
/var/www/glpi/inc/connection.class.php:122        DBmysql->query()
/var/www/glpi/inc/connection.function.php:314        Connection->addToDB()
/var/www/glpi/front/computer.form.php:104        Connect()
/var/www/glpi/front/computer.form.php
06-01-2009 18:04
*** MySQL query error :
***
SQL: INSERT INTO glpi_connect_wire (end1,end2,type) VALUES (\'1\',\'3\',\'4\')
Error: Duplicate entry '1-3-4' for key 2
Backtrace :
/var/www/glpi/inc/connection.class.php:122        DBmysql->query()
/var/www/glpi/inc/connection.function.php:314        Connection->addToDB()
/var/www/glpi/front/monitor.form.php:117        Connect()
/var/www/glpi/front/monitor.form.php
06-01-2009 18:35
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
07-01-2009 12:02
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
08-01-2009 16:03
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
08-01-2009 19:59
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
08-01-2009 20:01
*** MySQL query error :
***
SQL: SELECT DISTINCT glpi_dropdown_kbcategories.* FROM glpi_dropdown_kbcategories WHERE ID IN Array AND  (glpi_dropdown_kbcategories.parentID = \'0\') ORDER  BY name ASC
Error: 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 'Array AND  (glpi_dropdown_kbcategories.parentID = '0') ORDER  BY name ASC' at line 1
Backtrace :
/var/www/glpi/inc/knowbase.function.php:148        DBmysql->query()
/var/www/glpi/front/helpdesk.faq.php:79        showKbCategoriesFirstLevel()
/var/www/glpi/front/helpdesk.faq.php
09-01-2009 11:58
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
09-01-2009 17:37
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
12-01-2009 13:25
*** MySQL query error :
***
SQL: SHOW COLUMNS FROM glpi_plugin_network
Error: Table 'glpi.glpi_plugin_network' doesn't exist
Backtrace :
/var/www/glpi/inc/dbmysql.class.php:249        DBmysql->query()
/var/www/glpi/inc/db.function.php:856        DBmysql->list_fields()
/var/www/glpi/plugins/network/front/plugin_network.update.php:40        FieldExists()
/var/www/glpi/plugins/network/front/plugin_network.update.php
12-01-2009 13:25
*** MySQL query error :
***
SQL:


Error: Query was empty
Backtrace :
/var/www/glpi/plugins/network/inc/plugin_network.functions_setup.php:87        DBmysql->query()
/var/www/glpi/plugins/network/front/plugin_network.update.php:42        plugin_network_updatev13()
/var/www/glpi/plugins/network/front/plugin_network.update.php
12-01-2009 17:08
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 09:50
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 10:44
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 12:11
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 13:19
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 13:46
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 13:46
*** MySQL query error :
***
SQL: INSERT INTO glpi_connect_wire (end1,end2,type) VALUES (\'7\',\'65\',\'4\')
Error: Duplicate entry '7-65-4' for key 2
Backtrace :
/var/www/glpi/inc/connection.class.php:122        DBmysql->query()
/var/www/glpi/inc/connection.function.php:314        Connection->addToDB()
/var/www/glpi/inc/ocsng.function.php:2424        Connect()
/var/www/glpi/inc/ocsng.function.php:888        ocsUpdatePeripherals()
/var/www/glpi/inc/ocsng.function.php:507        ocsUpdateComputer()
/var/www/glpi/inc/ocsng.function.php:653        ocsImportComputer()
/var/www/glpi/front/ocsng.import.php:72        ocsProcessComputer()
/var/www/glpi/front/ocsng.import.php
13-01-2009 14:39
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 14:52
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 15:23
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 15:36
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 17:05
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 17:22
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 17:23
*** MySQL query error :
***
SQL: SELECT DISTINCT glpi_dropdown_kbcategories.* FROM glpi_dropdown_kbcategories WHERE ID IN Array AND  (glpi_dropdown_kbcategories.parentID = \'0\') ORDER  BY name ASC
Error: 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 'Array AND  (glpi_dropdown_kbcategories.parentID = '0') ORDER  BY name ASC' at line 1
Backtrace :
05-01-2009 12:00
*** MySQL query error :
***
SQL: SELECT hostgroup.hg_name AS name_group, hostgroup.hg_id AS id_group, hostgroup.hg_alias AS alias, hostgroup_relation.hostgroup_hg_id AS d_type, count( * ) AS cmp
            FROM hostgroup_relation
            LEFT JOIN hostgroup ON ( hostgroup.hg_id = hostgroup_relation.hostgroup_hg_id )
            GROUP BY hostgroup_relation.hostgroup_hg_id, hostgroup.hg_id, hostgroup.hg_name
            ORDER BY hostgroup.hg_name,hostgroup_relation.hostgroup_hg_id
Error: Table 'Centreon_DB.hostgroup_relation' doesn't exist
Backtrace :
/var/www/glpi/plugins/centreon/inc/plugin_centreon.functions_display.host.php:69        DBmysql->query()
/var/www/glpi/plugins/centreon/front/plugin_centreon.index.php:62        plugin_centreon_showListGroupHost()
/var/www/glpi/plugins/centreon/front/plugin_centreon.index.php
05-01-2009 12:00
*** MySQL query error :
***
SQL: SELECT servicegroup.sg_name AS name_group, servicegroup.sg_id AS id_group, servicegroup.sg_alias AS alias, servicegroup_relation.servicegroup_sg_id AS d_type, count( * ) AS cmp
            FROM servicegroup_relation
            LEFT JOIN servicegroup ON ( servicegroup.sg_id = servicegroup_relation.servicegroup_sg_id )
            GROUP BY servicegroup_relation.servicegroup_sg_id, servicegroup.sg_id, servicegroup.sg_name
            ORDER BY servicegroup.sg_name, servicegroup_relation.servicegroup_sg_id
Error: Table 'Centreon_DB.servicegroup_relation' doesn't exist
Backtrace :
/var/www/glpi/plugins/centreon/inc/plugin_centreon.functions_display.service.php:87        DBmysql->query()
/var/www/glpi/plugins/centreon/front/plugin_centreon.index.php:71        plugin_centreon_showListGroup()
/var/www/glpi/plugins/centreon/front/plugin_centreon.index.php
05-01-2009 17:30
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
06-01-2009 14:37
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
06-01-2009 14:37
*** MySQL query error :
***
SQL:     SELECT host.* FROM host where (host.host_name LIKE \'%%\')  ORDER BY host.host_name ASC
Error: Table 'Centreon_DB.host' doesn't exist
Backtrace :
/var/www/glpi/plugins/centreon/inc/plugin_centreon.functions_search.host.php:162        DBmysql->query()
/var/www/glpi/plugins/centreon/front/index-host.php:57        plugin_centreon_showHostList()
/var/www/glpi/plugins/centreon/front/index-host.php
06-01-2009 17:30
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
06-01-2009 18:04
*** MySQL query error :
***
SQL: INSERT INTO glpi_connect_wire (end1,end2,type) VALUES (\'5\',\'3\',\'3\')
Error: Duplicate entry '5-3-3' for key 2
Backtrace :
/var/www/glpi/inc/connection.class.php:122        DBmysql->query()
/var/www/glpi/inc/connection.function.php:314        Connection->addToDB()
/var/www/glpi/front/computer.form.php:104        Connect()
/var/www/glpi/front/computer.form.php
06-01-2009 18:04
*** MySQL query error :
***
SQL: INSERT INTO glpi_connect_wire (end1,end2,type) VALUES (\'1\',\'3\',\'4\')
Error: Duplicate entry '1-3-4' for key 2
Backtrace :
/var/www/glpi/inc/connection.class.php:122        DBmysql->query()
/var/www/glpi/inc/connection.function.php:314        Connection->addToDB()
/var/www/glpi/front/monitor.form.php:117        Connect()
/var/www/glpi/front/monitor.form.php
06-01-2009 18:35
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
07-01-2009 12:02
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
08-01-2009 16:03
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
08-01-2009 19:59
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
08-01-2009 20:01
*** MySQL query error :
***
SQL: SELECT DISTINCT glpi_dropdown_kbcategories.* FROM glpi_dropdown_kbcategories WHERE ID IN Array AND  (glpi_dropdown_kbcategories.parentID = \'0\') ORDER  BY name ASC
Error: 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 'Array AND  (glpi_dropdown_kbcategories.parentID = '0') ORDER  BY name ASC' at line 1
Backtrace :
/var/www/glpi/inc/knowbase.function.php:148        DBmysql->query()
/var/www/glpi/front/helpdesk.faq.php:79        showKbCategoriesFirstLevel()
/var/www/glpi/front/helpdesk.faq.php
09-01-2009 11:58
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
09-01-2009 17:37
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
12-01-2009 13:25
*** MySQL query error :
***
SQL: SHOW COLUMNS FROM glpi_plugin_network
Error: Table 'glpi.glpi_plugin_network' doesn't exist
Backtrace :
/var/www/glpi/inc/dbmysql.class.php:249        DBmysql->query()
/var/www/glpi/inc/db.function.php:856        DBmysql->list_fields()
/var/www/glpi/plugins/network/front/plugin_network.update.php:40        FieldExists()
/var/www/glpi/plugins/network/front/plugin_network.update.php
12-01-2009 13:25
*** MySQL query error :
***
SQL:


Error: Query was empty
Backtrace :
/var/www/glpi/plugins/network/inc/plugin_network.functions_setup.php:87        DBmysql->query()
/var/www/glpi/plugins/network/front/plugin_network.update.php:42        plugin_network_updatev13()
/var/www/glpi/plugins/network/front/plugin_network.update.php
12-01-2009 17:08
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 09:50
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 10:44
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 12:11
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 13:19
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 13:46
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 13:46
*** MySQL query error :
***
SQL: INSERT INTO glpi_connect_wire (end1,end2,type) VALUES (\'7\',\'65\',\'4\')
Error: Duplicate entry '7-65-4' for key 2
Backtrace :
/var/www/glpi/inc/connection.class.php:122        DBmysql->query()
/var/www/glpi/inc/connection.function.php:314        Connection->addToDB()
/var/www/glpi/inc/ocsng.function.php:2424        Connect()
/var/www/glpi/inc/ocsng.function.php:888        ocsUpdatePeripherals()
/var/www/glpi/inc/ocsng.function.php:507        ocsUpdateComputer()
/var/www/glpi/inc/ocsng.function.php:653        ocsImportComputer()
/var/www/glpi/front/ocsng.import.php:72        ocsProcessComputer()
/var/www/glpi/front/ocsng.import.php
13-01-2009 14:39
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 14:52
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 15:23
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 15:36
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 17:05
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 17:22
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 17:23
*** MySQL query error :
***
SQL: SELECT DISTINCT glpi_dropdown_kbcategories.* FROM glpi_dropdown_kbcategories WHERE ID IN Array AND  (glpi_dropdown_kbcategories.parentID = \'0\') ORDER  BY name ASC
Error: 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 'Array AND  (glpi_dropdown_kbcategories.parentID = '0') ORDER  BY name ASC' at line 1
Backtrace :
/var/www/glpi/inc/knowbase.function.php:148        DBmysql->query()
/var/www/glpi/front/helpdesk.faq.php:79        showKbCategoriesFirstLevel()
/var/www/glpi/front/helpdesk.faq.php
13-01-2009 17:23
*** MySQL query error :
***
SQL: SELECT DISTINCT glpi_dropdown_kbcategories.* FROM glpi_dropdown_kbcategories WHERE ID IN Array AND  (glpi_dropdown_kbcategories.parentID = \'0\') ORDER  BY name ASC
Error: 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 'Array AND  (glpi_dropdown_kbcategories.parentID = '0') ORDER  BY name ASC' at line 1
Backtrace :
/var/www/glpi/inc/knowbase.function.php:148        DBmysql->query()
/var/www/glpi/front/helpdesk.faq.php:79        showKbCategoriesFirstLevel()
/var/www/glpi/front/helpdesk.faq.php
13-01-2009 17:27
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 17:41
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 17:47
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 17:53
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 18:06
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
13-01-2009 18:12
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
14-01-2009 11:57
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
14-01-2009 13:20
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
14-01-2009 13:20
*** MySQL query error :
***
SQL: SELECT DISTINCT glpi_dropdown_kbcategories.* FROM glpi_dropdown_kbcategories WHERE ID IN Array AND  (glpi_dropdown_kbcategories.parentID = \'0\') ORDER  BY name ASC
Error: 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 'Array AND  (glpi_dropdown_kbcategories.parentID = '0') ORDER  BY name ASC' at line 1
Backtrace :
/var/www/glpi/inc/knowbase.function.php:148        DBmysql->query()
/var/www/glpi/front/helpdesk.faq.php:79        showKbCategoriesFirstLevel()
/var/www/glpi/front/helpdesk.faq.php
14-01-2009 13:20
*** MySQL query error :
***
SQL: SELECT DISTINCT glpi_dropdown_kbcategories.* FROM glpi_dropdown_kbcategories WHERE ID IN Array AND  (glpi_dropdown_kbcategories.parentID = \'0\') ORDER  BY name ASC
Error: 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 'Array AND  (glpi_dropdown_kbcategories.parentID = '0') ORDER  BY name ASC' at line 1
Backtrace :
/var/www/glpi/inc/knowbase.function.php:148        DBmysql->query()
/var/www/glpi/front/helpdesk.faq.php:79        showKbCategoriesFirstLevel()
/var/www/glpi/front/helpdesk.faq.php
14-01-2009 13:20
*** MySQL query error :
***
SQL: SELECT DISTINCT glpi_dropdown_kbcategories.* FROM glpi_dropdown_kbcategories WHERE ID IN Array AND  (glpi_dropdown_kbcategories.parentID = \'0\') ORDER  BY name ASC
Error: 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 'Array AND  (glpi_dropdown_kbcategories.parentID = '0') ORDER  BY name ASC' at line 1
Backtrace :
/var/www/glpi/inc/knowbase.function.php:148        DBmysql->query()
/var/www/glpi/front/helpdesk.faq.php:79        showKbCategoriesFirstLevel()
/var/www/glpi/front/helpdesk.faq.php
14-01-2009 13:20
*** MySQL query error :
***
SQL: SELECT DISTINCT glpi_dropdown_kbcategories.* FROM glpi_dropdown_kbcategories WHERE ID IN Array AND  (glpi_dropdown_kbcategories.parentID = \'0\') ORDER  BY name ASC
Error: 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 'Array AND  (glpi_dropdown_kbcategories.parentID = '0') ORDER  BY name ASC' at line 1
Backtrace :
/var/www/glpi/inc/knowbase.function.php:148        DBmysql->query()
/var/www/glpi/front/helpdesk.faq.php:79        showKbCategoriesFirstLevel()
/var/www/glpi/front/helpdesk.faq.php
14-01-2009 13:20
*** MySQL query error :
***
SQL: SELECT DISTINCT glpi_dropdown_kbcategories.* FROM glpi_dropdown_kbcategories WHERE ID IN Array AND  (glpi_dropdown_kbcategories.parentID = \'0\') ORDER  BY name ASC
Error: 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 'Array AND  (glpi_dropdown_kbcategories.parentID = '0') ORDER  BY name ASC' at line 1
Backtrace :
/var/www/glpi/inc/knowbase.function.php:148        DBmysql->query()
/var/www/glpi/front/helpdesk.faq.php:79        showKbCategoriesFirstLevel()
/var/www/glpi/front/helpdesk.faq.php
14-01-2009 13:25
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php
15-01-2009 13:14
*** MySQL query error :
***
SQL: SELECT UNIX_TIMESTAMP(MAX(date_mod)) as max_date FROM glpi_history
Error:
Backtrace :
/var/www/glpi/inc/dbreplicate.function.php:183        DBmysql->query()
/var/www/glpi/inc/dbreplicate.function.php:175        getHistoryMaxDate()
/var/www/glpi/inc/dbreplicate.function.php:217        getReplicateDelay()
/var/www/glpi/inc/cron.class.php:223        cron_dbreplicate()
/var/www/glpi/front/cron.php:71        Cron->launch()
/var/www/glpi/front/cron.php

Dans le fichier cron.log j'ai

(...) [supprimé par le modérateur]

Si on vide le dossier /_cache ca nous met une page vierge sans possibilité de se logguer

on a vide cache + cookies de firefox derniere version + IE7



Avant la mise à jour étions entrain de créer la notifaction mail avec notre serveur exchange
le message quand on essaye de se logguer ca nous marque :


Identifiant ou mot de passe erroné
Can't open mailbox {srv-****-****/pop}informatique@xx-xx.org: invalid remote specification

**** correspond au serveur owa  et les "xxx" à notre ndd

Last edited by unital (2009-01-15 17:56:04)

VM : Debian GNU/Linux Lenny 5.0.3 Apache2, Mysql5.0 
Authentification Ldap
GLPI Ver. 72.4
OCS Ver. 1.02

Offline

#2 2009-01-15 17:59:29

wawa
GLPI-DEV
From: Montpellier / France
Registered: 2006-07-03
Posts: 6,019
Website

Re: Bug suite à mis à jour

bonjour,
vous avez un soucis avec le plugin centreon
vous avez bien mis à jour le plugin aussi ?

Offline

#3 2009-01-15 18:02:27

unital
Member
From: Paris
Registered: 2009-01-13
Posts: 28

Re: Bug suite à mis à jour

wawa wrote:

bonjour,
vous avez un soucis avec le plugin centreon
vous avez bien mis à jour le plugin aussi ?

je l'ai installé sur la version 0.71.2
depuis le 0.71.3 je peux plus rien acceder sur l'interface d'admin ...
j'ai juste oublié de décoché que les MAJ auto ne s'installe pas.

Last edited by unital (2009-01-15 18:03:10)

VM : Debian GNU/Linux Lenny 5.0.3 Apache2, Mysql5.0 
Authentification Ldap
GLPI Ver. 72.4
OCS Ver. 1.02

Offline

#4 2009-01-15 19:24:36

JMD
GLPI - Lead
Registered: 2004-09-13
Posts: 9,180
Website

Re: Bug suite à mis à jour

1) il faut enlever les plugins avant de faire une mise à jour
2) installer les plugins uniquement compatible avec la nouvelle version
3) pas la peine de mettre l'intégralité du cron log qui ne sert à rien.
4) en lisant les logs mysql vous auriez pu voir de vous même que le problème vient de votre plugin centreon

JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

Offline

#5 2009-01-15 19:58:28

unital
Member
From: Paris
Registered: 2009-01-13
Posts: 28

Re: Bug suite à mis à jour

JMD wrote:

1) il faut enlever les plugins avant de faire une mise à jour
2) installer les plugins uniquement compatible avec la nouvelle version
3) pas la peine de mettre l'intégralité du cron log qui ne sert à rien.
4) en lisant les logs mysql vous auriez pu voir de vous même que le problème vient de votre plugin centreon

D'accord merci pour les précisions smile
GLPI c'est mis à jour direct quand la nouvelle version est sortie sinon j'aurais tout fait proprement...
Comment puis-je faire désinstaller centreon,juste en supprimant le plugin centreon dans /_plugin?
Et pour le problème de login cela réglera le problème?

VM : Debian GNU/Linux Lenny 5.0.3 Apache2, Mysql5.0 
Authentification Ldap
GLPI Ver. 72.4
OCS Ver. 1.02

Offline

#6 2009-01-15 21:17:37

JMD
GLPI - Lead
Registered: 2004-09-13
Posts: 9,180
Website

Re: Bug suite à mis à jour

GLPI ne se met pas à jour tout seul !

GLPI vous annonce seulement qu'il y a une mise à jour de disponible. C'est à l'administrateur donc de procéder manuellement à mise à jour.

Sauf si vous passez par les packages d'une distribution et dans ce cas il vous incombe avant de valider la mise à jour de faire les interventions nécessaires.

JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

Offline

#7 2009-01-15 23:49:39

unital
Member
From: Paris
Registered: 2009-01-13
Posts: 28

Re: Bug suite à mis à jour

JMD wrote:

GLPI ne se met pas à jour tout seul !

GLPI vous annonce seulement qu'il y a une mise à jour de disponible. C'est à l'administrateur donc de procéder manuellement à mise à jour.

Sauf si vous passez par les packages d'une distribution et dans ce cas il vous incombe avant de valider la mise à jour de faire les interventions nécessaires.

Oui j'ai vu ca ceci n'explique pas la maj auto surtout que j'ai installé glpi l'archive depuis le site idem pour ma machine virtuel que j'ai a des fins de test....(j'ai installé ma debian etch et ensuite chaque paquets php5 etc. installé OCS puis GLPI p Enfin passons wink
Si je désinstalle direct Centreon ça va tout remettre correctement? et je pourrais ravoir accès à la console d'admin?

VM : Debian GNU/Linux Lenny 5.0.3 Apache2, Mysql5.0 
Authentification Ldap
GLPI Ver. 72.4
OCS Ver. 1.02

Offline

#8 2009-01-16 00:04:57

tsmr
GLPI-DEV
From: Rennes
Registered: 2005-08-26
Posts: 11,632
Website

Re: Bug suite à mis à jour

déplace le répertoire centreon dans un répertoire old par exemple (pas besoin de le desinstaller - amoins que tu ne veuille pas le mettre à jour)

Xavier Caillaud
Blog GLPI Infotel

Offline

#9 2009-01-16 00:22:09

JMD
GLPI - Lead
Registered: 2004-09-13
Posts: 9,180
Website

Re: Bug suite à mis à jour

J'insiste si d'autant plus vous avez installé l'archive manuellement. GLPI n'a pas pu se mettre à jour tout seul, c'est tout bonnement impossible car il n'y a aucun script pour cela.

Par ailleurs, je déplace le sujet qui n'est pas un bug.

JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

Offline

#10 2009-01-16 11:44:26

unital
Member
From: Paris
Registered: 2009-01-13
Posts: 28

Re: Bug suite à mis à jour

Ok il y a moyen de savoir le gus qui fait la maj ou du moins l'ip du pc? seul 3 personnes moi compris on les accès, personne ne voudra s'accuser...

maintenant je peux acceder à glpi avec les nom d'utilisateur & mot de passe présent dans notre AD mais je n'est qu'accès à la demande de ticket, l'utilisateur glpi mdp: glpi ne fonctionne pas. il y a un autre moyen d'acceder au panel d'admin?

VM : Debian GNU/Linux Lenny 5.0.3 Apache2, Mysql5.0 
Authentification Ldap
GLPI Ver. 72.4
OCS Ver. 1.02

Offline

#11 2009-01-16 13:00:42

JMD
GLPI - Lead
Registered: 2004-09-13
Posts: 9,180
Website

Re: Bug suite à mis à jour

Ok il y a moyen de savoir le gus qui fait la maj ou du moins l'ip du pc? seul 3 personnes moi compris on les accès, personne ne voudra s'accuser...

Il suffit de consulter les logs sur votre serveur.

Pour votre souci de connexion, regardez ce que vous avez dans votre base.

JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

Offline

Pages: 1

Board footer

Powered by FluxBB