6.0.0-beta6
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
3/31/26
H
istory
A
ttachments
C
omment
W
atch
Download
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
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers