Databases
StackOverflow2013
Postsdbo
POSubquery returns more than 1 row sql query
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSubquery returns more than 1 row sql query
    primarykey
    data
    text
    <p>I had such an error can explain what I did wrong? <br /> I only add this sql query: <br /></p> <pre><code> (? = (select travel_region_id from relationships where travel_id = travels.id)) </code></pre> <p>error</p> <pre><code>ActiveRecord::StatementInvalid (Mysql::Error: Subquery returns more than 1 row: select count(*) from travel_start_days, cars, travels where travels.id = travel_start_days.travel_id and travels.id = travel.car_id and travel_start_days.day &gt; adddate(curdate(), interval '2' day) and (7 = (select travel_region_id from relationships where travel_id = travels.id)) and '2013-08-16' &lt;= travel_start_days.day): </code></pre> <p><strong>Update</strong> Whis is method create query</p> <pre><code>def conditions where = '' param = [] if @region &amp;&amp; @region != '' where += 'travels.region_id = ?' param += [@region.to_i] end if @car &amp;&amp; @car != '' where += ' and ' if where != '' where += 'cars.id = ?' param += [@car.to_i] end if @relation &amp;&amp; @relation != '' where += ' and ' if where != '' where += '(? = (select travel_region_id from relationships where travel_id = travels.id))' param += [@relation.to_i] end if @start_port &amp;&amp; @start_port != '' where += ' and ' if where != '' where += '(? = (select location_id from travel_days where travel_id = travel_start_days.travel_id and day_no = 1 order by arrival asc limit 1))' param += [@start_port.to_i] end return where == '' ? nil : ["travel_start_days.day &gt; adddate(curdate(), interval ? day) and " + where] + [@criteria[5]] + param end </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAndrew
    1. USAndrew
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSubquery returns more than 1 row sql query
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSubquery returns more than 1 row sql query
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSubquery returns more than 1 row sql query
      1. This table or related slice is empty.
      1. VTUpMod
    1. COsample data and table structure pls
      singulars
      1. POSubquery returns more than 1 row sql query
      1. USPraveen Prasannan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload