[trean] 2005-03-15_move_to_horde_share.php didn't do what I expected.

[Edwin L. Culp]

I updated horde and family this morning to the latest, installed 
framework, updated configurations, etc.  I ran the new traen script 
that looked great, no errors.  Below is the cut and paste of the 
results.

# ./2005-03-15_move_to_horde_share.php
Converting trean.bookmarks.eculp at unixmania.com
  Multimedia...done
  Diccionarios...done
  SetUpHelp...done
  NON-IMMIGRANT VISAS...done
  SEGURIDAD...done
  UNIX...done
  DOMINIOS...done
  ADMIN EMPRESA...done
  Newsletters...done
  REFERENCIA...done
  Building Applications...done
  RealEstate...done
  BENCHMARKS...done
  MSWINDOWS...done
  WWW...done

I opened bookmarks and get "An error occured listing categories: DB 
Error: syntax error" I checked horde.log and see the following:


Mar 16 10:54:09 HORDE [error] [trean] DB Error: syntax error: SELECT 
c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOI
N 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.trean' AND (((a1.attribute_name = 
'owner' AND a1.attribute_value = 'eculp at unixmania.com') OR (a1.attribu
te_name = 'perm_users' AND a1.attribute_key = 'eculp at unixmania.com' AND 
a1.attribute_value & 2) OR (a1.attribute_name = 'perm_creator' AND
a1.attribute_value & 2) OR (a1.attribute_name = 'perm_default' AND 
a1.attribute_value & 2) OR (a1.attribute_name = 'perm_groups' AND a1.a
ttribute_key IN '(580, 599, 616, 559, 561, 576, 595, 612)' AND 
a1.attribute_value & 2)) AND a2.attribute_name = 'owner' AND 
a2.attribute_v
alue = 'eculp at unixmania.com')  AND a1.attribute_name = 
a2.attribute_name GROUP BY c.datatree_id, c.datatree_name, 
c.datatree_order ORDER B
Y c.datatree_order, c.datatree_name, c.datatree_id [nativecode=1064 ** 
You have an error in your SQL syntax.  Check the manual that corres
ponds to your MySQL server version for the right syntax to use near 
''(580, 599, 616, 559, 561, 576, 595, 612)' AND a1.attribute_val] [on
line 1101 of "/usr/local/share/pear/Horde/DataTree/sql.php"]

Is it an error in trean or could I have missed another update?

thanks,

ed