[geeklog-devel] Fwd: Windows Live Writer, now with AtomPub

[Oliver Spiesshofer]

Dirk,

I inserted an error log call and got the following:

11/08/07 06:36:41 - 1406: Data too long for column 'sid' at row 1. SQL 
in question:
REPLACE INTO gl_stories (sid, uid, draft_flag, tid, date, title, 
introtext, bodytext,
hits, numemails, comments, trackbacks, related, featured, 
show_topic_icon, commentcode,
trackbackcode, statuscode, expire, postmode, advanced_editor_mode, 
frontpage, in_transit,
owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon)  VALUES
('urn-uuid-4083dea9-0422-4c57-b789-e08eff988b9f', '2', '0', 'Geeklog',
'2007-11-08 06:36:41', 'test', '<p>test</p>  ', '', '0', '0', '0', '0',
'', '0', '1', '0', '0', '0', '2007-11-08 06:36:41', 'html', '0', '1',
'1', '2', '3', '3', '2', '2', '2')

Obviously it tries to assign a SID that is far too long:
urn-uuid-4083dea9-0422-4c57-b789-e08eff988b9f

Oliver

Dirk Haun wrote:
> Oliver Spiesshofer wrote:
>
>   
>> The response to the POST method received from the weblog server was invalid:
>> The HTTP response was missing the required Location header.
>>     
>
> These things are always "fun" to debug when you can't see what is
> actually being sent back and forth ...
>
> I'm sure that Geeklog does send a Location header. But maybe it's
> throwing an error (e.g. a PHP error) and WLW doesn't understand that of
> course.
>
> Can you try the APE, <http://www.tbray.org/ape/>, with your site? It
> will at least log the communication so you'll see what happens.
>
> Note: The APE will leave a post on your site. It would usually delete it
> again by itself, but we have a problem with the IDs it's using, as
> discussed here before.
>
> bye, Dirk
>
>
>