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@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

Search Discussions

  • Thorsten Müller at Jan 9, 2012 at 11:04 am
    The error seems to be in this SQL statement:

    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`

    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@googlegroups.com.
    To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
    For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouprubyonrails-talk @
categoriesrubyonrails
postedJan 9, '12 at 6:18a
activeJan 9, '12 at 11:04a
posts2
users2
websiterubyonrails.org
irc#RubyOnRails

2 users in discussion

Sachin kewale: 1 post Thorsten Müller: 1 post

People

Translate

site design / logo © 2021 Grokbase