I believe the issue is with inserting messages that end (or
possibly contain) dollar signs ('$'). Here is the json and SQL
where we get an SQLite error. Note that the last "$" in the message
is cut off of the sql insert:
{"favorited":false,"coordinates":null,"source":"<a
href=\"http://www.echofon.com/\"
rel=\"nofollow\">Echofon</a>","created_at":"Mon Jun 28
18:14:19 +0000
2010","place":null,"in_reply_to_screen_name":"funkatron","truncated":false,"contributors":null,"in_reply_to_user_id":65583,"geo":null,"in_reply_to_status_id":17268756850,"text":"<span
class=\"user-screen-name clickable\" title=\"View user's profile\"
user-screen_name=\"funkatron\">@funkatron</span> My mood
is good, but that's because it's !@#$ DESIGNED TO FUNCTION
CORRECTLY1$%!@#$","SC_timeline_from":"replies","SC_user_received_by":"funkatron","SC_is_reply":true,"SC_created_at_unixtime":1277748859000,"SC_text_raw":"@funkatron
My mood is good, but that's because it's !@#$ DESIGNED TO FUNCTION
CORRECTLY1$%!@#$","SC_retrieved_unixtime":1277756099506,"SC_thumbnail_urls":null,"SC_is_read":false,"user_id":177,"twitter_id":17269574884}
INSERT INTO tweets (user_id, favorited,
in_reply_to_user_id, in_reply_to_screen_name, text, created_at,
truncated, twitter_id, in_reply_to_status_id, source,
SC_timeline_from, SC_user_received_by, SC_is_reply,
SC_created_at_unixtime, SC_text_raw, SC_retrieved_unixtime, isSent,
id) VALUES(177, 0, 65583, 'funkatron', '<span
class="user-screen-name clickable" title="View user''s profile"
user-screen_name="funkatron">@funkatron</span> My mood is
good, but that''s because it''s !@#$ DESIGNED TO FUNCTION
CORRECTLY1$%!@# , 'Mon Jun 28 18:14:19 +0000 2010', 0, 17269574884,
17268756850, '<a href="http://www.echofon.com/"
rel="nofollow">Echofon</a>', 'replies', 'funkatron', 1,
1277748859000, '@funkatron My mood is good, but that''s because
it''s !@#$ DESIGNED TO FUNCTION CORRECTLY1$%!@# , 1277756099506, 0,
NULL)
