#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.

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