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
[email protected]
https://mail.gna.org/listinfo/glpi-dev
