Yii Framework Forum: Database Error In Data Filter - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

Database Error In Data Filter Rate Topic: -----

#1 User is offline   liveproject101 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 1
  • Joined: 09-April 13

Posted 11 April 2013 - 07:23 AM

Don't know is it right place to ask or not, but I am having following issue:

Fatal error: Database error 1242: Subquery returns more than 1 row
Invalid SQL: SELECT EP.es_preadmissionid, EP.pre_name, (SELECT roll_no FROM es_sections_student ESS WHERE ESS.student_id=EP.es_preadmissionid ) AS ROLL_NO, (SELECT section_id FROM es_sections_student ESS WHERE ESS.student_id=EP.es_preadmissionid) AS SECTION FROM es_preadmission EP , es_preadmission_details EPD where EP.pre_status !='inactive' AND EPD.es_preadmissionid=EP.es_preadmissionid AND EPD.pre_class=1 ORDER BY es_preadmissionid ASC in /home/content/16/9882416/html/products.projectdesk.info/s-erp/office_admin/includes/classes/developer.mysql.class.php on line 136

Got this error while filtering data, it is returning more than one value as result. If help me
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users