Skip to content

Instantly share code, notes, and snippets.

@axavio
Created February 11, 2012 17:16
Show Gist options
  • Save axavio/1802593 to your computer and use it in GitHub Desktop.
Save axavio/1802593 to your computer and use it in GitHub Desktop.
chat error
ActiveRecord::StatementInvalid in MultisController#index
Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read = 1
) ORDER BY id DESC LIMIT 5' at line 6: SELECT `chat_messages`.* FROM `chat_messages` WHERE (
(
recipient_id = 3 AND author_id = 2
OR recipient_id = 2 AND author_id = 3
)
AND read = 1
) ORDER BY id DESC LIMIT 5
Rails.root: /Users/dad/dev/diaspora
Application Trace | Framework Trace | Full Trace
app/models/chat_message.rb:26:in `history_between'
app/helpers/chat_helper.rb:18:in `initialize_chat_variables'
app/helpers/chat_helper.rb:15:in `each'
app/helpers/chat_helper.rb:15:in `initialize_chat_variables'
app/controllers/application_controller.rb:46:in `set_header_data'
lib/chrome_frame.rb:39:in `call'
Request
Parameters:
None
Show session dump
Show env dump
Response
Headers:
None
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment