Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

SQL Error within TweetModel.saveTweet breaks displaying of tweets

#55

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.

Reported by alab · June 7th, 2010 @ 04:22 AM

State: resolved
Milestone: none
Assigned to: Ed Finkler Ed Finkler

Activity

  1. alab
  2. alab
  3. alab
    alab
    • Tag changed from db to db, jazzrecord

    Debuggin a little deeper this happens in JazzRecord.Model.create when calling A.save()

    June 7th, 2010 @ 07:06 AM

  4. Ed Finkler
    Ed Finkler
    • State changed from new to resolved
    • Milestone order changed from 0 to 0

    We stopped using JazzRecord, so this can be closed.

    December 4th, 2010 @ 07:50 PM

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.