Hello!
I have a rails app using a mysql. Now I need to configure it with
sqlite.
I change database settings in config/database.yml and Gemfile file and
run
rake db:create
rake db:migrate
and did not get any errors.
But in view a have a code
<%[email protected]%>
and get error
SQLite3::SQLException: near “to”: syntax error: SELECT COUNT() FROM
“likes” WHERE (“likes”.to = 1)
in sqlite console sql query working with this syntax
SELECT COUNT() FROM “likes” WHERE (“likes”.“to” = 1)
Why on mysql it’s working, but not working in sqlite?How i can fix it?
rails -v
Rails 3.0.7
ruby -v
ruby 1.8.7 (2009-06-12 patchlevel 174) [universal-darwin10.0]
sqlite3 -version
3.6.12
On Mon, Jul 18, 2011 at 3:04 PM, Aegorov E. [email protected]
wrote:
SQLite3::SQLException: near “to”: syntax error: SELECT COUNT() FROM
“likes” WHERE (“likes”.to = 1)
in sqlite console sql query working with this syntax
SELECT COUNT() FROM “likes” WHERE (“likes”.“to” = 1)
Apparently the SQLite3 adapter isn’t quoting that field name, and
unfortunately for you, “TO” is a SQL reserved word.
The best solution would be to change that. 
HTH,
Hassan S. ------------------------ [email protected]
twitter: @hassan
1 Thank you!it’s help me. I guess that this is the problem.
Hassan S. wrote in post #1011501:
On Mon, Jul 18, 2011 at 3:04 PM, Aegorov E. [email protected]
wrote:
SQLite3::SQLException: near “to”: syntax error: SELECT COUNT() FROM
“likes” WHERE (“likes”.to = 1)
in sqlite console sql query working with this syntax
SELECT COUNT() FROM “likes” WHERE (“likes”.“to” = 1)
Apparently the SQLite3 adapter isn’t quoting that field name, and
unfortunately for you, “TO” is a SQL reserved word.
The best solution would be to change that.
HTH,
Hassan S. ------------------------ [email protected]
Hassan Schroeder | about.me
twitter: @hassan