#67 ✓resolved
Ed Finkler

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

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.

New-ticket Create new ticket

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

Shared Ticket Bins

People watching this ticket

Pages