Fatal Error when using search schedule

[GoogleCodeExporter]

on at least 2 computers, you can't schedules babies at all.  you pick a
study, and it says it's going to reload and put in the ages, and then it
just brings up a fatal error.  this is what the error says:

Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with message
'SQLSTATE[HY093]: Invalid parameter number: no parameters were bound' in
/home/wpl/public_html/babydb/library/Zend/Db/Statement/Pdo.php:238 Stack
trace: #0 /home/wpl/public_html/babydb/library/Zend/Db/Statement.php(283):
Zend_Db_Statement_Pdo->_execute(Array) #1
/home/wpl/public_html/babydb/library/Zend/Db/Adapter/Abstract.php(405):
Zend_Db_Statement->execute(Array) #2
/home/wpl/public_html/babydb/library/Zend/Db/Adapter/Pdo/Abstract.php(205):
Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array) #3
/home/wpl/public_html/babydb/library/Zend/Db/Select.php(639):
Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select)) #4
/home/wpl/public_html/babydb/app/models/Study.php(204):
Zend_Db_Select->query() #5
/home/wpl/public_html/babydb/app/modules/default/controllers/Appointment2Control
ler.php(644):
Study->getRecordOwners('short', false, Array) #6
/home/wpl/public_html/babydb/app/modules/default/controllers/Appointment2Control
ler.php(479):
App in /home/wpl/public_html/babydb/library/Zend/Db/Statement/Pdo.php on
line 238

Original issue reported on code.google.com by czar...@gmail.com on 10 Jul 2009 at 7:29

[GoogleCodeExporter]

I have no idea what this problem is, particularly since it doesn't happen on my 
end.
What I can do is make the schedule appointments into a 2-page form. On the 
first page
will only be a selection for studies and nothing else. After you select your 
study,
you click submit and you will be directed to the next page which will have your 
study
selected and everything else that is currently on the 'scheduling appointments' 
form.
I believe this would fix the problem. Let me know if this is good for you.

Original comment by czar...@gmail.com on 24 Jul 2009 at 6:37

• Changed state: Accepted

[GoogleCodeExporter]

that sounds fine - let's try it and see if it works on those computers.

Original comment by cstarm...@gmail.com on 24 Jul 2009 at 2:56

[GoogleCodeExporter]

Ok I changed the search schedule/appointments to be a 2-step form. Let me know 
if
this fixes the problem for the computers that have the fatal error.

Original comment by czar...@gmail.com on 25 Jul 2009 at 10:10

• Changed state: Started

[GoogleCodeExporter]

Original comment by czar...@gmail.com on 25 Jul 2009 at 10:10

• Changed state: Fixed

[GoogleCodeExporter]

this works.

Original comment by cstarm...@gmail.com on 26 Jul 2009 at 3:06

• Changed state: Verified