SQL Error within TweetModel.saveTweet breaks displaying of tweets
Reported by alab | June 7th, 2010 @ 04:22 AM
I was able to debug this down into JazzRecord.save which throws the SQL Error
JazzRecord.save() sql:
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(1, 0, NULL,
NULL, 'Floyd Landis never doped to improve his result$ & David
Stern would never influence the refs in historic rivalry just for
ratings #NBACARE , 'Mon Jun 07 03:45:11 +0000 2010', 0,
15603865080, NULL, 'web', 'home', 'c_alb', 0, 1275882311000, 'Floyd
Landis never doped to improve his result$ & David Stern would
never influence the refs in historic rivalry just for ratings
#NBACARE , 1275897932404, 0, NULL)
SQLError: 'Error #3115: SQL Error.', details:'near 'Mon': syntax error', operation:'execute', detailID:'2003'
The problem is the text Value – the original tweet ends with #NBACARE$ – and in the SQL statement the last '$' is lost as well as the the closing quote.
Comments and changes to this ticket
-
alab June 7th, 2010 @ 04:41 AM
This is the failing message http://twitter.com/joedevon/status/15603865080
-
alab June 7th, 2010 @ 05:09 AM
- Tag set to “db”
-
alab June 7th, 2010 @ 07:06 AM
- Tag changed from “db” to “db, jazzrecord”
Debuggin a little deeper this happens in JazzRecord.Model.create when calling A.save()
-
Ed Finkler December 4th, 2010 @ 07:50 PM
- State changed from “new” to “resolved”
- Milestone order changed from “0” to “0”
We stopped using JazzRecord, so this can be closed.
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
alab
Ed Finkler