[horde] DataTree Errors with MS SQL Server

[Alexander Maier]

Hi,

this is a child thread of "no such table" with IIS6 and MSSQL as it 
handles a different problem.

I explained the problem getting an pear error that the data tree system 
cannot find the parents when I try to create a new usergroup.
about the log files: php, iis and mssql logs are empty - or at least 
don't contain anything about that error. The horde log file is attached 
to the end of the mail.

I set up a mysql server (which was just for testing and should not be 
the productive system) and the error was gone. So this means to me that 
either something is configured completely wrong with my mssql server or 
my conversion from the create.mysql.sql to the create.mssql.sql was 
faulty (I changed LONGTEXT to TEXT and all kinds of BLOBs to IMAGE, 
removed the Flush Privileges and the @localhost).

Perhaps someone has experienced a similar problem or has a working setup 
with the head cvs, MSSQL, IIS6 and PHP 4.3.9.

Thanks,

Alex.



__________________________________________________
here comes the horde log excerpt

Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::_loadById(): SELECT datatree_id, datatree_parents FROM 
horde_datatree WHERE datatree_id IN (11) AND group_uid = 'horde.groups' 
ORDER BY datatree_id [on line 254 of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::_loadById(): SELECT datatree_id, datatree_name, 
datatree_parents, datatree_order FROM horde_datatree WHERE datatree_id 
IN (11, 0) AND group_uid = 'horde.groups' ORDER BY datatree_id [on line 
285 of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::getAttributes(): SELECT attribute_name AS name, 
attribute_key AS "key", attribute_value AS value FROM 
horde_datatree_attributes WHERE datatree_id = 11 [on line 884 of 
"C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::updateData(): UPDATE horde_datatree SET datatree_data = 
NULL WHERE datatree_id = 11 [on line 1164 of 
"C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::updateData(): DELETE FROM horde_datatree_attributes WHERE 
datatree_id = 11 [on line 1175 of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::updateData(): INSERT INTO horde_datatree_attributes 
(datatree_id, attribute_name, attribute_key, attribute_value) VALUES 
(11, 'email', '', ?) [on line 1195 of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::_load(): SELECT datatree_id, datatree_name, 
datatree_parents, datatree_order FROM horde_datatree WHERE group_uid = 
'horde.history' [on line 106 of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::getAttributes(): SELECT attribute_name AS name, 
attribute_key AS "key", attribute_value AS value FROM 
horde_datatree_attributes WHERE datatree_id = 12 [on line 884 of 
"C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::updateData(): UPDATE horde_datatree SET datatree_data = 
NULL WHERE datatree_id = 12 [on line 1164 of 
"C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::updateData(): DELETE FROM horde_datatree_attributes WHERE 
datatree_id = 12 [on line 1175 of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::updateData(): INSERT INTO horde_datatree_attributes 
(datatree_id, attribute_name, attribute_key, attribute_value) VALUES 
(12, '0', 'action', ?) [on line 1195 of 
"C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::updateData(): INSERT INTO horde_datatree_attributes 
(datatree_id, attribute_name, attribute_key, attribute_value) VALUES 
(12, '0', 'who', ?) [on line 1195 of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::updateData(): INSERT INTO horde_datatree_attributes 
(datatree_id, attribute_name, attribute_key, attribute_value) VALUES 
(12, '0', 'ts', ?) [on line 1195 of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::updateData(): INSERT INTO horde_datatree_attributes 
(datatree_id, attribute_name, attribute_key, attribute_value) VALUES 
(12, '1', 'action', ?) [on line 1195 of 
"C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::updateData(): INSERT INTO horde_datatree_attributes 
(datatree_id, attribute_name, attribute_key, attribute_value) VALUES 
(12, '1', 'who', ?) [on line 1195 of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::updateData(): INSERT INTO horde_datatree_attributes 
(datatree_id, attribute_name, attribute_key, attribute_value) VALUES 
(12, '1', 'ts', ?) [on line 1195 of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::getAttributes(): SELECT attribute_name AS name, 
attribute_key AS "key", attribute_value AS value FROM 
horde_datatree_attributes WHERE datatree_id = 11 [on line 884 of 
"C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::_load(): SELECT datatree_id, datatree_name, 
datatree_parents, datatree_order FROM horde_datatree WHERE group_uid = 
'horde.groups' [on line 106 of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::_loadById(): SELECT datatree_id, datatree_parents FROM 
horde_datatree WHERE datatree_id IN (0) AND group_uid = 'horde.groups' 
ORDER BY datatree_id [on line 254 of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [debug] [horde] SQL Query by 
DataTree_sql::_loadById(): SELECT datatree_id, datatree_name, 
datatree_parents, datatree_order FROM horde_datatree WHERE datatree_id 
IN (0) AND group_uid = 'horde.groups' ORDER BY datatree_id [on line 285 
of "C:\PHP\pear\Horde\DataTree\sql.php"]
Dec 14 12:14:07 HORDE [emergency] [horde] Parents not found:  not found 
[on line 180 of "D:\IISwwwRoot\horde\admin\groups.php"]