JazzRecord throws error when inserting certain statuses
Reported by Ed Finkler | June 28th, 2010 @ 04:20 PM | in Version 0.10
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)
Comments and changes to this ticket
-
thynctank June 29th, 2010 @ 12:06 AM
Should be fixed in latest master after JazzRecord update escaping $.
-
thynctank June 29th, 2010 @ 12:06 AM
- State changed from new to resolved
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
The Spaz Desktop project