Tickets :: Comment on [#14177] ActiveSync SQL error

* Your Email Address
* Spam protection	Enter the letters below: .__ __ .__ __. . \| \/ `[ __(__ \| \|__/\__.[_./.__)\__\|
Comment	>> 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
Attachment
Watch this ticket