Whether these tables for sequence emulation need to be created depends 
on the database system you use. They are created automatically by the 
PEAR DB package. Yes, on some RDMBs you need to use a user that has 
permissions to create tables.
Fixed in CVS, thanks.

Just for your information, i've found two errors that I've solved:



Horde wants to create a table named "horde_datatree_seq". Typically, 
the user used to connect to the sql didn't have the necessary rigths( 
only datareader and datawriter). So I need to create the table myself 
(including this on ths sql scripts ?)



On the table "horde_datatree_attributes", the field "attribute_value" 
is TEXT. I need to change it to varchar(MAX) because i've these errors:



Mar 23 20:42:55 HORDE [error] [turba] DB Error: unknown error: SELECT 
c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN 
horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id WHERE 
c.group_uid = 'horde.shares.turba' AND ((a1.attribute_name = 'owner' 
AND a1.attribute_value = 'mymailaddress') OR (a1.attribute_name = 
'perm_users' AND a1.attribute_key = 'mymailaddress' AND (CASE WHEN 
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 4) ELSE 3 
END) = 4) OR (a1.attribute_name = 'perm_creator' AND (CASE WHEN 
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 4) ELSE 3 
END) = 4) OR (a1.attribute_name = 'perm_default' AND (CASE WHEN 
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 4) ELSE 3 
END) = 4))   GROUP BY c.datatree_id, c.datatree_name, c.datatree_order 
ORDER BY c.datatree_order, c.datatree_name, c.datatree_id 
[nativecode=402 - The data types text and varchar are incompatible in 
the equal to operator.] [on line 1123 of 
"xxxx\horde\lib\Horde\DataTree\sql.php"]

Mar 23 20:42:55 HORDE [error] [turba] DB Error: unknown error: SELECT 
c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN 
horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id WHERE 
c.group_uid = 'horde.shares.turba' AND ((a1.attribute_name = 'owner' 
AND a1.attribute_value = 'mymailaddress') OR (a1.attribute_name = 
'perm_users' AND a1.attribute_key = 'mymailaddress' AND (CASE WHEN 
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 4) ELSE 3 
END) = 4) OR (a1.attribute_name = 'perm_creator' AND (CASE WHEN 
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 4) ELSE 3 
END) = 4) OR (a1.attribute_name = 'perm_default' AND (CASE WHEN 
ISNUMERIC(a1.attribute_value) = 1 THEN (a1.attribute_value & 4) ELSE 3 
END) = 4))   GROUP BY c.datatree_id, c.datatree_name, c.datatree_order 
ORDER BY c.datatree_order, c.datatree_name, c.datatree_id 
[nativecode=402 - The data types text and varchar are incompatible in 
the equal to operator.] [on line 425 of 
"xxxx\horde\turba\lib\Turba.php"]

Mar 23 20:42:55 HORDE [error] [kronolith] DB Error: unknown error: 
SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN 
horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id WHERE 
c.group_uid = 'horde.shares.kronolith' AND ((a1.attribute_name = 
'owner' AND a1.attribute_value = 'mymailaddress') OR 
(a1.attribute_name = 'perm_users' AND a1.attribute_key = 
'mymailaddress' AND (CASE WHEN ISNUMERIC(a1.attribute_value) = 1 THEN 
(a1.attribute_value & 2) ELSE 1 END) = 2) OR (a1.attribute_name = 
'perm_creator' AND (CASE WHEN ISNUMERIC(a1.attribute_value) = 1 THEN 
(a1.attribute_value & 2) ELSE 1 END) = 2) OR (a1.attribute_name = 
'perm_default' AND (CASE WHEN ISNUMERIC(a1.attribute_value) = 1 THEN 
(a1.attribute_value & 2) ELSE 1 END) = 2))   GROUP BY c.datatree_id, 
c.datatree_name, c.datatree_order ORDER BY c.datatree_order, 
c.datatree_name, c.datatree_id [nativecode=402 - The data types text 
and varchar are incompatible in the equal to operator.] [on line 1123 
of "xxxx\horde\lib\Horde\DataTree\sql.php"]

Mar 23 20:42:55 HORDE [error] [kronolith] DB Error: unknown error: 
SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN 
horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id WHERE 
c.group_uid = 'horde.shares.kronolith' AND ((a1.attribute_name = 
'owner' AND a1.attribute_value = 'mymailaddress') OR 
(a1.attribute_name = 'perm_users' AND a1.attribute_key = 
'mymailaddress' AND (CASE WHEN ISNUMERIC(a1.attribute_value) = 1 THEN 
(a1.attribute_value & 2) ELSE 1 END) = 2) OR (a1.attribute_name = 
'perm_creator' AND (CASE WHEN ISNUMERIC(a1.attribute_value) = 1 THEN 
(a1.attribute_value & 2) ELSE 1 END) = 2) OR (a1.attribute_name = 
'perm_default' AND (CASE WHEN ISNUMERIC(a1.attribute_value) = 1 THEN 
(a1.attribute_value & 2) ELSE 1 END) = 2))   GROUP BY c.datatree_id, 
c.datatree_name, c.datatree_order ORDER BY c.datatree_order, 
c.datatree_name, c.datatree_id [nativecode=402 - The data types text 
and varchar are incompatible in the equal to operator.] [on line 801 
of "xxxx\horde\kronolith\lib\Kronolith.php"]

Mar 23 20:42:55 HORDE [error] [kronolith] DB Error: unknown error: 
SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN 
horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id LEFT 
JOIN horde_datatree_attributes a2 ON a2.datatree_id = c.datatree_id 
WHERE c.group_uid = 'horde.shares.kronolith' AND (((a1.attribute_name 
= 'owner' AND a1.attribute_value = 'mymailaddress') OR 
(a1.attribute_name = 'perm_users' AND a1.attribute_key = 
'mymailaddress' AND (CASE WHEN ISNUMERIC(a1.attribute_value) = 1 THEN 
(a1.attribute_value & 2) ELSE 1 END) = 2) OR (a1.attribute_name = 
'perm_creator' AND (CASE WHEN ISNUMERIC(a1.attribute_value) = 1 THEN 
(a1.attribute_value & 2) ELSE 1 END) = 2) OR (a1.attribute_name = 
'perm_default' AND (CASE WHEN ISNUMERIC(a1.attribute_value) = 1 THEN 
(a1.attribute_value & 2) ELSE 1 END) = 2)) AND a2.attribute_name = 
'owner' AND a2.attribute_value = 'mymailaddress')  AND a1.datatree_id 
= a2.datatree_id GROUP BY c.datatree_id, c.datatree_name, 
c.datatree_order ORDER BY c.datatree_order, c.datatree_name, 
c.datatree_id [nativecode=402 - The data types text and varchar are 
incompatible in the equal to operator.] [on line 1123 of 
"xxxx\horde\lib\Horde\DataTree\sql.php"]

Mar 23 20:42:55 HORDE [error] [kronolith] DB Error: unknown error: 
SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN 
horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id LEFT 
JOIN horde_datatree_attributes a2 ON a2.datatree_id = c.datatree_id 
WHERE c.group_uid = 'horde.shares.kronolith' AND (((a1.attribute_name 
= 'owner' AND a1.attribute_value = 'mymailaddress') OR 
(a1.attribute_name = 'perm_users' AND a1.attribute_key = 
'mymailaddress' AND (CASE WHEN ISNUMERIC(a1.attribute_value) = 1 THEN 
(a1.attribute_value & 2) ELSE 1 END) = 2) OR (a1.attribute_name = 
'perm_creator' AND (CASE WHEN ISNUMERIC(a1.attribute_value) = 1 THEN 
(a1.attribute_value & 2) ELSE 1 END) = 2) OR (a1.attribute_name = 
'perm_default' AND (CASE WHEN ISNUMERIC(a1.attribute_value) = 1 THEN 
(a1.attribute_value & 2) ELSE 1 END) = 2)) AND a2.attribute_name = 
'owner' AND a2.attribute_value = 'mymailaddress')  AND a1.datatree_id 
= a2.datatree_id GROUP BY c.datatree_id, c.datatree_name, 
c.datatree_order ORDER BY c.datatree_order, c.datatree_name, 
c.datatree_id [nativecode=402 - The data types text and varchar are 
incompatible in the equal to operator.] [on line 801 of 
"xxxx\horde\kronolith\lib\Kronolith.php"]



Is this normal ?

Great !



Many thanks.

There's a problem with forward and backwards slashes in registry.php 
script in Horde 1.01 running on Windows that generates wrong result in 
horde base directory.
Quick and dirty solution to fix it: open the 
/horde/config/registry.php with any editor, go to line 521 and replace 
__FILE__ with str_replace('\\', '/', __FILE__)

This will convert backslashes of Windows file name path to unix-style 
forward slash.

The _detect_webroot function will now return correct horde path.

misconfigured ? I don't understand because the 1.00 works with my 
configuration and some other php's applications too.



Which specific needs do I param ?



I see the ticket #4420 but I don't find the solution.



I knows some programming language but not the php...



Thanks for your help

Sounds like your server is misconfigured.
Fix this first, and then come back if the load problem still exists.

I was not sure to need to run the script. The Horde Webmail isn't 
based on Horde 3.1 ? It's only two nullable fields, I can delete it if 
you want.



I've looking for all of my logs (Apache, PHP, Horde, Windows) and no 
logs or no events for the concerned date/time.



php-cgi.exe and sqlservr.exe runs with 20% to 50% (40% to 100% total) 
a long times (I need to close IE to stop it)



When I go to the mysite/horde/imp age, the login page is shown (after 
cpu comes up to 100% with sql and php), the image at the bottom isn't 
shown and a javascript error is reported by IE.



I've reported the ticket 5145 for the test.php page. But when I click 
on the logon button in imp, IE search for the url 
/horde/imp/index.php/imp/redirect.php, the cpu comes to 100% and imp 
the page is never shown

Why did you do this?



Anyway, check your log files (all log files!) and watch out for any 
suspicious logs.

I can send to you the url of my server, test page and horde 
application by mail if you want

I used Webmail 1.0 successfully.



I failed to update to the version 1.01, so I delete all my Horde 
install (including the database) and recreate the web folder, the web 
application and the database.



I used the 3.0_to_3.1.sql script and run the scripts\setup.php.



Successfull, the test.php page looks to be good. But when I launch 
Horde, my cpu use 50% to 100% of running time and the application is 
never show on IE.



No php.log file, no php error on IE (display_error=on), no horde.log file.



I'm using Webmail 1.01, PHP 5.2.2, Apache 2.2.4 and MSDE 2005 SP2 
(running well with version 1.0)



Thanks for your help