thr3ads.net - Rails - error in your SQL syntax [Jan 2012]

If this information is useful, please help other people find it:
Share via:

sachin kewale

2012-Jan-09 06:18 UTC

error in your SQL syntax

hi all,
 i am getting the following exception ,can anyone know what is the problem
? or can any one what is SQL syntax for following query to run in ruby on
rails ?
 i am using
 Ruby: 1.8.7 (2011-02-18 patchlevel 334) [i386-mingw32]
 Rails 2.3.11
 gem :1.6.2


Processing ExpertController#view_expert_brief (for 127.0.0.1 at 2012-01-09
11:36:03) [GET]
  Parameters: {"slug"=>"stephencovey"}
  [4;36;1mExpert Columns (0.s)[   [0;1mSHOW FIELDS FROM `experts`[
  [4;35;1mExpert Load (0.s)[   [SELECT * FROM `experts` WHERE
(`experts`.`approved` = 1 AND `experts`.`deleted` = 0 AND `experts`.`slug`
= ''stephencovey'') LIMIT 1[
  [4;36;1mExpertCategory Load (0.s)[   [0;1mSELECT `expert_categories`.*
FROM `expert_categories` INNER JOIN `experts` ON `experts`.expert_id
`expert_categories`.expert_id INNER JOIN `categories` ON
`categories`.category_id = `expert_categories`.category_id WHERE
(expert_categories.expert_id=178 and category_approved=1 and
category_deleted=0 and approved=1 and deleted=0) [
  [4;35;1mExpertCategory Columns (15.6ms)[   [SHOW FIELDS FROM
`expert_categories`[
  [4;36;1mCategory Columns (0.s)[   [0;1mSHOW FIELDS FROM `categories`[
  [4;35;1mCategory Load (0.s)[   [SELECT * FROM `categories` WHERE
(`categories`.`category_id` = 1) [
  [4;36;1mCategory Load (0.s)[   [0;1mSELECT * FROM `categories` WHERE
(`categories`.`category_id` = 7) [
  [4;35;1mCategory Load (0.s)[   [SELECT * FROM `categories` WHERE
(`categories`.`category_id` = 8) [
  [4;36;1mCategory Load (15.6ms)[   [0;1mSELECT * FROM `categories` WHERE
(`categories`.`category_id` = 18) [
  [4;35;1mExpert Load (0.s)[   [SELECT * FROM `experts` WHERE
(`experts`.`approved` = 1 AND `experts`.`deleted` = 0 AND
`experts`.`expert_id` = 178) LIMIT 1[
  [4;36;1mExpertBio Load (0.s)[   [0;1mSELECT * FROM `expert_bio` WHERE
(`expert_bio`.expert_id = 178) LIMIT 1[
  [4;35;1mExpertBio Columns (0.s)[   [SHOW FIELDS FROM `expert_bio`[
  [4;36;1mEvent Load (15.6ms)[   [0;1mSELECT `events`.* FROM `events` INNER
JOIN `experts` ON `experts`.expert_id = `events`.expert_id WHERE
(events.expert_id= 178 and event_date >= ''2012-01-09'' and
expert_events_approved=1 and expert_events_deleted=0 and experts.approved=1
and experts.deleted=0) ORDER BY event_date ASC LIMIT 5[
  [4;35;1mEvent Columns (0.s)[   [SHOW FIELDS FROM `events`[
  [4;36;1mSQL (0.s)[   [0;1mMysql::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 ''? and event_date >= ? and
expert_events_approved=1 and expert_events_deleted=017'' at line 1:
SELECT
count(expert_id=? and event_date >= ? and expert_events_approved=1 and
expert_events_deleted=01782012-01-09) AS
count_expert_id_and_event_date_and_expert_events_approved_1_and_expert_events_deleted_0_178_2012_01_09
FROM `events` [

-- 
Thanks and Regards
 Sachin S. kewale

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Thorsten Müller

2012-Jan-09 11:04 UTC

head link

Re: error in your SQL syntax

The error seems to be in this SQL statement:

SELECT count(expert_id=? and event_date >= ? and expert_events_approved=1 
and expert_events_deleted01782012-01-09) AS 
count_expert_id_and_event_date_and_expert_events_approved_1_and_expert_events_deleted_0_178_2012_01_09
FROM `events`

It complains about the "event_date >= ?" where of course the
questionmark
is wrong.
It looks like you do somehing on the line of

MyModel.where("event_date >= ?", @date_var) 
(simplified)

But for some reason the questionmark is not replaced by the actual value. 

Could you provide the actual Ruby code that is used to generate this query?

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/8sFqbo3dVEEJ.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Rails - Jan 2012 - error in your SQL syntax

error in your SQL syntax

Re: error in your SQL syntax