[Tickets #14177] Re: ActiveSync SQL error

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: https://bugs.horde.org/ticket/14177
------------------------------------------------------------------------------
  Ticket             | 14177
  Updated By         | o+horde at immerda.ch
  Summary            | ActiveSync SQL error
  Queue              | Synchronization
  Version            | FRAMEWORK_5_2
  Type               | Bug
  State              | No Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky
------------------------------------------------------------------------------


o+horde at immerda.ch (2015-12-25 11:04) wrote:

> Those array values should be string values (share names) and not  
> even integers. Look in your share table (probably  
> kronolith_sharesng) and see if you can find any shares with a share  
> name of 0 or 1 (or ANY integer value). My guess is those are old  
> left over cruft.

I already checked this table, there is nothing obviously suspicious  
there. I tried:

SELECT * FROM "public"."kronolith_sharesng" WHERE  
char_length("share_name") < 10

and

CREATE OR REPLACE FUNCTION convert_to_integer(v_input text)
RETURNS INTEGER AS $$
DECLARE v_int_value INTEGER DEFAULT NULL; BEGIN
BEGIN
     v_int_value := v_input::INTEGER;
     EXCEPTION WHEN OTHERS THEN
         RETURN NULL;
     END;
RETURN v_int_value;
END;
$$ LANGUAGE plpgsql;
SELECT * FROM "public"."kronolith_sharesng" where  
convert_to_integer("share_name") is not null

none of those queries returned a single row