resolved here :) https://dev.indepnet.net:8080/glpi/changeset/4775
Selon Spyros Theodosis <[EMAIL PROTECTED]>: > Hi to all, > > > > I have a working installation of GLPI 0.68.3 and multiple OCS. > > I decided to updated to ver 7.0 in order to test the the multiple OCS sync. > > I followed the update procedure successfully but when i logged into the new > installation I got the following error: > > PHP ERROR : > Warning: mysql_result(): supplied argument is not a valid MySQL result > resource in /opt/apache2ssl/htdocs/glpi_test/inc/dbmysql.class.php on line > 123 > > 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 ') GROUP BY ID > ORDER BY glpi_dropdown_locations.completename ASC LIMIT 0, 9999' at line 1 > > > > I tried the query successfully with phpMyAdmin without the AND ( ) from the > ` WHERE glpi_computers.deleted='0' AND glpi_computers.is_template='0' AND > ( ) GROUP BY ID : `. > > > > Thanks in advance > > Spyros Theodosis > > more from the debug output: > > 0.073s - GLPI 0.7 Copyright (C) 2003-2007 by the INDEPNET Development > Team. > > GLPI MODE DEBUG > GLPI MODE DEBUG > SQL REQUEST : 5 Queries took 0.001s > N° Queries Time > 1 SELECT * > FROM glpi_display > WHERE type='1' AND FK_users='31' > ORDER BY rank 0.000s > 2 SELECT * > FROM glpi_display > WHERE type='1' AND FK_users='0' > ORDER BY rank 0.000s > 3 SELECT count(glpi_computers.ID) > FROM glpi_computers > WHERE glpi_computers.deleted='0' AND glpi_computers.is_template='0' > AND ( ) 0.000s > 4 SET SESSION group_concat_max_len = 9999999; 0.000s > 5 SELECT glpi_computers.name AS ITEM_0, glpi_dropdown_state.name AS > ITEM_1, glpi_computers.serial AS ITEM_2, glpi_dropdown_model.name AS ITEM_3, > glpi_dropdown_os.name AS ITEM_4, glpi_dropdown_os_version.name AS ITEM_5, > glpi_dropdown_os_sp.name AS ITEM_6, glpi_computers.date_mod AS ITEM_7, > GROUP_CONCAT( DISTINCT glpi_networking_ports.ifaddr SEPARATOR '$$$$') AS > ITEM_8, glpi_users_tech_num.name AS ITEM_9, glpi_users_tech_num.realname AS > ITEM_9_2, glpi_users_tech_num.ID AS ITEM_9_3, glpi_users_tech_num.firstname > AS ITEM_9_4,glpi_computers.contact AS ITEM_10, > glpi_dropdown_locations.completename AS ITEM_11, glpi_computers.ID AS ID > FROM glpi_computers > LEFT JOIN glpi_dropdown_state ON (glpi_computers.state = > glpi_dropdown_state.ID) > LEFT JOIN glpi_dropdown_model ON (glpi_computers.model = > glpi_dropdown_model.ID) > LEFT JOIN glpi_dropdown_os ON (glpi_computers.os = > glpi_dropdown_os.ID) > LEFT JOIN glpi_dropdown_os_version ON (glpi_computers.os_version = > glpi_dropdown_os_version.ID) > LEFT JOIN glpi_dropdown_os_sp ON (glpi_computers.os_sp = > glpi_dropdown_os_sp.ID) > LEFT JOIN glpi_computer_device AS DEVICE_5 ON (glpi_computers.ID = > DEVICE_5.FK_computers AND DEVICE_5.device_type='5') > LEFT JOIN glpi_networking_ports ON (glpi_computers.ID = > glpi_networking_ports.on_device AND glpi_networking_ports.device_type='1') > LEFT JOIN glpi_users AS glpi_users_tech_num ON > (glpi_computers.tech_num = glpi_users_tech_num.ID) > LEFT JOIN glpi_dropdown_locations ON (glpi_computers.location = > glpi_dropdown_locations.ID) > WHERE glpi_computers.deleted='0' AND glpi_computers.is_template='0' > AND ( ) GROUP BY ID > ORDER BY glpi_dropdown_locations.completename ASC LIMIT 0, 9999999 > 0.001s > > POST VARIABLE > GET VARIABLE > KEY => VALUE > start => 0 > order => ASC > deleted => 0 > distinct => N > link => > field => KEY => VALUE > 0 => view > > contains => KEY => VALUE > 0 => > > link2 => > field2 => KEY => VALUE > 0 => view > > contains2 => KEY => VALUE > 0 => > > type2 => > sort => 3 > > SESSION VARIABLE > KEY => VALUE > dict => en_GB > Test_session_GLPI => 1 > glpi_plugins => > glpi_currenttime => 2007-04-16 14:28:54 > glpiID => 31 > glpiname => sthe > glpirealname => > glpifirstname => > glpilanguage => en_GB > glpitracking_order => 0 > glpiauthorisation => 1 > glpiextauth => 0 > glpisearchcount => KEY => VALUE > 1 => 1 > 32 => 1 > 4 => 1 > 10 => 2 > 6 => 1 > 2 => 1 > 3 => 1 > 17 => 1 > 22 => 1 > 21 => 1 > > glpisearchcount2 => KEY => VALUE > 1 => 0 > 32 => 0 > 4 => 0 > 10 => 0 > 6 => 0 > 2 => 0 > 3 => 0 > 17 => 0 > 22 => 0 > 21 => 0 > > glpiroot => > glpilist_limit => 9999999 > glpicrontimer => 1176722934 > glpiprofiles => KEY => VALUE > 4 => KEY => VALUE > ID => 4 > name => super-admin > interface => central > is_default => 0 > computer => w > monitor => w > software => w > networking => w > printer => w > peripheral => w > cartridge => w > consumable => w > phone => w > notes => w > contact_enterprise => w > document => w > contract_infocom => w > knowbase => w > faq => w > reservation_helpdesk => 1 > reservation_central => w > reports => r > ocsng => w > view_ocsng => r > sync_ocsng => w > dropdown => w > entity_dropdown => w > device => w > typedoc => w > link => w > config => w > rule_tracking => w > rule_ocs => w > rule_ldap => w > search_config => w > search_config_global => w > check_update => r > profile => w > user => w > group => w > entity => w > logs => r > reminder_public => w > backup => w > create_ticket => 1 > delete_ticket => 1 > comment_ticket => 1 > comment_all_ticket => 1 > update_ticket => 1 > own_ticket => 1 > steal_ticket => 1 > assign_ticket => 1 > show_ticket => 1 > show_full_ticket => 1 > observe_ticket => 1 > show_planning => 1 > show_all_planning => 1 > statistic => 1 > password_update => 1 > helpdesk_hardware => 3 > helpdesk_hardware_type => 8388674 > show_group_ticket => 0 > show_group_hardware => 0 > entities => KEY => VALUE > 32 => KEY => VALUE > ID => 0 > name => > completename => > recursive => 1 > > > > > glpiactiveprofile => KEY => VALUE > ID => 4 > name => super-admin > interface => central > is_default => 0 > computer => w > monitor => w > software => w > networking => w > printer => w > peripheral => w > cartridge => w > consumable => w > phone => w > notes => w > contact_enterprise => w > document => w > contract_infocom => w > knowbase => w > faq => w > reservation_helpdesk => 1 > reservation_central => w > reports => r > ocsng => w > view_ocsng => r > sync_ocsng => w > dropdown => w > entity_dropdown => w > device => w > typedoc => w > link => w > config => w > rule_tracking => w > rule_ocs => w > rule_ldap => w > search_config => w > search_config_global => w > check_update => r > profile => w > user => w > group => w > entity => w > logs => r > reminder_public => w > backup => w > create_ticket => 1 > delete_ticket => 1 > comment_ticket => 1 > comment_all_ticket => 1 > update_ticket => 1 > own_ticket => 1 > steal_ticket => 1 > assign_ticket => 1 > show_ticket => 1 > show_full_ticket => 1 > observe_ticket => 1 > show_planning => 1 > show_all_planning => 1 > statistic => 1 > password_update => 1 > helpdesk_hardware => 3 > helpdesk_hardware_type => 8388674 > show_group_ticket => 0 > show_group_hardware => 0 > entities => KEY => VALUE > 32 => KEY => VALUE > ID => 0 > name => > completename => > recursive => 1 > > > > glpiactiveentities => > glpi_entities_tree => KEY => VALUE > 0 => > > glpiactive_entity => > glpiactive_entity_name => Root entity > glpigroups => > glpi_viewcentral => all > glpi_mailconfig => 1 > MESSAGE_AFTER_REDIRECT => > glpi_configgen => 3 > glpi_searchconfig => 1 > ocs_server_id => 1 > ocs_update_count => 6 > glpisearch => KEY => VALUE > 1 => KEY => VALUE > contains => KEY => VALUE > 0 => > > field => KEY => VALUE > 0 => view > > sort => 3 > deleted => 0 > start => 0 > > 10 => KEY => VALUE > reset_before => 1 > glpisearchcount => 2 > sort => 12 > order => DESC > start => 0 > field => KEY => VALUE > 0 => 12 > 1 => 12 > > link => KEY => VALUE > 1 => AND > > contains => KEY => VALUE > 0 => <0 > 1 => >-30 > > deleted => 0 > > 22 => KEY => VALUE > synthese => no > > > > > > _______________________________________________ > Glpi-dev mailing list > Glpi-dev@gna.org > https://mail.gna.org/listinfo/glpi-dev > _______________________________________________ Glpi-dev mailing list Glpi-dev@gna.org https://mail.gna.org/listinfo/glpi-dev
