[GroupDAV] GroupDAV Connector & Synthesis SyncML Palm Client

[Adam Williams]

On Sun, 2006-09-24 at 18:02 -0400, Adam Williams wrote:
> On Mon, 2006-09-25 at 08:00 +1000, Mathew McBride wrote:
> > Adam Williams wrote:
> > > Now that I have the connector working reasonably well with Outlook's
> > > calendar I've moved on to testing from the Synthesis AG SyncML client
> > > [STD edition, version 2.5.0.68] for the Palm [Verizon Treo 650, firmware
> > > 1.04-VZW].
> > > The SyncML client installs, and the first sync fails immediately - but
> > > produces the device record on the Funambol server.  After connecting the
> > > user and the device into a principle the sync configures saying "Sent
> > > 44/60" until it fails with an error of "Database not found" after fairly
> > > long period saying "Waiting..."
> > Uncheck the 30-90 day event filter that is on in Synthesis - should work 
> > then.
> I was just trying that when I got this message! :)
> It did change things... not it fails with an "Error code = 500". :)
> Checking the logs now....

One problem at least appears to be that some component is not properly
handling the escaping of characters like single quotes.

Tail end of log:
------------------------------
<Item>
<Source>
<LocURI>32771</LocURI>
</Source>
<Data>Invalid quoted-printable encoding</Data>
</Item>
</Status>
<Status>
<CmdID>31</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>33</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32834</SourceRef>
<Data>201</Data>
</Status>
<Status>
<CmdID>32</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>34</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32770</SourceRef>
<Data>201</Data>
</Status>
<Status>
<CmdID>33</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>35</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32842</SourceRef>
<Data>201</Data>
</Status>
<Status>
<CmdID>34</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>36</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32838</SourceRef>
<Data>201</Data>
</Status>
<Status>
<CmdID>35</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>37</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32854</SourceRef>
<Data>201</Data>
</Status>
<Status>
<CmdID>36</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>38</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32836</SourceRef>
<Data>201</Data>
</Status>
<Status>
<CmdID>37</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>39</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32832</SourceRef>
<Data>201</Data>
</Status>
<Status>
<CmdID>38</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>40</CmdRef>
<Cmd>Replace</Cmd>
<Data>500</Data>
<Item>
<Source>
<LocURI>32863</LocURI>
</Source>
<Data>Syntax error at offset 62 on 's''. Additional token after end of
SQL statement
"namelist" WHERE "obj_name" = 'Thompson's'
                                        ^</Data>
</Item>
</Status>
<Status>
<CmdID>39</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>41</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32869</SourceRef>
<Data>201</Data>
</Status>
<Status>
<CmdID>40</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>42</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32864</SourceRef>
<Data>201</Data>
</Status>
<Status>
<CmdID>41</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>43</CmdRef>
<Cmd>Replace</Cmd>
<Data>500</Data>
<Item>
<Source>
<LocURI>32868</LocURI>
</Source>
<Data>Syntax error at offset 59 on 's'. Additional token after end of
SQL statement
OM "namelist" WHERE "obj_name" = 'Janet's Graduation'
                                        ^</Data>
</Item>
</Status>
<Status>
<CmdID>42</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>44</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32873</SourceRef>
<Data>201</Data>
</Status>
<Status>
<CmdID>43</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>45</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32875</SourceRef>
<Data>201</Data>
</Status>
<Status>
<CmdID>44</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>46</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32877</SourceRef>
<Data>201</Data>
</Status>
<Status>
<CmdID>45</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>47</CmdRef>
<Cmd>Replace</Cmd>
<Data>500</Data>
<Item>
<Source>
<LocURI>32881</LocURI>
</Source>
<Data>An error ocurred during parsing - line: 8</Data>
</Item>
</Status>
<Status>
<CmdID>46</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>48</CmdRef>
<Cmd>Replace</Cmd>
<Data>500</Data>
<Item>
<Source>
<LocURI>32884</LocURI>
</Source>
<Data>The store already has an object for: Dentist Appointment</Data>
</Item>
</Status>
<Status>
<CmdID>47</CmdID>
<MsgRef>2</MsgRef>
<CmdRef>49</CmdRef>
<Cmd>Replace</Cmd>
<SourceRef>32878</SourceRef>
<Data>201</Data>
</Status>
</SyncBody