Problems editing questions

[sbischof]

We are looking at libstats and were able to install it without any
trouble but we seem to have a problem when we try to edit an
question. We can add questions without any trouble. Any one have an
hints on what the problem might be? Here is the error dump

object(db_error)(8) {
["error_message_prefix"]=>
string(0) ""
["mode"]=>
int(1)
["level"]=>
int(1024)
["code"]=>
int(-20)
["message"]=>
string(36) "DB Error: insufficient data supplied"
["userinfo"]=>
string(449) "UPDATE questions SET location_id = ?,question_type_id
= ?,question_type_other = ?,time_spent_id = ?,patron_type_id
= ?,question_format_id = ?,initials = ?,question = ?,answer = ?,hide
= ?,delete_hide = ?,question_date = ? WHERE UPDATE questions SET
location_id = ?,question_type_id = ?,question_type_other
= ?,time_spent_id = ?,patron_type_id = ?,question_format_id
= ?,initials = ?,question = ?,answer = ?,hide = ?,delete_hide
= ?,question_date = ?"
["backtrace"]=>
array(9) {
[0]=>
array(6) {
["file"]=>
string(22) "/usr/share/pear/DB.php"
["line"]=>
int(604)
["function"]=>
string(10) "pear_error"
["class"]=>
string(8) "db_error"
["type"]=>
string(2) "->"
["args"]=>
array(5) {
[0]=>
string(36) "DB Error: insufficient data supplied"
[1]=>
int(-20)
[2]=>
int(1)
[3]=>
int(1024)
[4]=>
string(449) "UPDATE questions SET location_id
= ?,question_type_id = ?,question_type_other = ?,time_spent_id
= ?,patron_type_id = ?,question_format_id = ?,initials = ?,question
= ?,answer = ?,hide = ?,delete_hide = ?,question_date = ? WHERE UPDATE
questions SET location_id = ?,question_type_id = ?,question_type_other
= ?,time_spent_id = ?,patron_type_id = ?,question_format_id
= ?,initials = ?,question = ?,answer = ?,hide = ?,delete_hide
= ?,question_date = ?"
}
}
[1]=>
array(6) {
["file"]=>
string(24) "/usr/share/pear/PEAR.php"
["line"]=>
int(569)
["function"]=>
string(8) "db_error"
["class"]=>
string(8) "db_error"
["type"]=>
string(2) "->"
["args"]=>
array(4) {
[0]=>
int(-20)
[1]=>
int(1)
[2]=>
int(1024)
[3]=>
string(449) "UPDATE questions SET location_id
= ?,question_type_id = ?,question_type_other = ?,time_spent_id
= ?,patron_type_id = ?,question_format_id = ?,initials = ?,question
= ?,answer = ?,hide = ?,delete_hide = ?,question_date = ? WHERE UPDATE
questions SET location_id = ?,question_type_id = ?,question_type_other
= ?,time_spent_id = ?,patron_type_id = ?,question_format_id
= ?,initials = ?,question = ?,answer = ?,hide = ?,delete_hide
= ?,question_date = ?"
}
}
[2]=>
array(6) {
["file"]=>
string(29) "/usr/share/pear/DB/common.php"
["line"]=>
int(296)
["function"]=>
string(10) "raiseerror"
["class"]=>
string(4) "pear"
["type"]=>
string(2) "::"
["args"]=>
array(7) {
[0]=>
NULL
[1]=>
int(-20)
[2]=>
NULL
[3]=>
NULL
[4]=>
string(449) "UPDATE questions SET location_id
= ?,question_type_id = ?,question_type_other = ?,time_spent_id
= ?,patron_type_id = ?,question_format_id = ?,initials = ?,question
= ?,answer = ?,hide = ?,delete_hide = ?,question_date = ? WHERE UPDATE
questions SET location_id = ?,question_type_id = ?,question_type_other
= ?,time_spent_id = ?,patron_type_id = ?,question_format_id
= ?,initials = ?,question = ?,answer = ?,hide = ?,delete_hide
= ?,question_date = ?"
[5]=>
string(8) "DB_Error"
[6]=>
bool(true)
}
}
[3]=>
array(6) {
["file"]=>
string(29) "/usr/share/pear/DB/common.php"
["line"]=>
int(603)
["function"]=>
string(10) "raiseerror"
["class"]=>
string(8) "db_mysql"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
int(-20)
}
}
[4]=>
array(6) {
["file"]=>
string(29) "/usr/share/pear/DB/common.php"
["line"]=>
int(555)
["function"]=>
string(19) "executeemulatequery"
["class"]=>
string(8) "db_mysql"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
int(0)
[1]=>
array(12) {
[0]=>
int(1)
[1]=>
int(1)
[2]=>
string(0) ""
[3]=>
int(1)
[4]=>
int(1)
[5]=>
int(3)
[6]=>
string(10) "sablllllll"
[7]=>
string(4) "test"
[8]=>
string(6) "ttttt4"
[9]=>
int(0)
[10]=>
int(0)
[11]=>
string(19) "2009-08-07 10:29:00"
}
}
}
[5]=>
array(6) {
["file"]=>
string(29) "/usr/share/pear/DB/common.php"
["line"]=>
int(469)
["function"]=>
string(7) "execute"
["class"]=>
string(8) "db_mysql"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
int(0)
[1]=>
array(12) {
[0]=>
int(1)
[1]=>
int(1)
[2]=>
string(0) ""
[3]=>
int(1)
[4]=>
int(1)
[5]=>
int(3)
[6]=>
string(10) "sablllllll"
[7]=>
string(4) "test"
[8]=>
string(6) "ttttt4"
[9]=>
int(0)
[10]=>
int(0)
[11]=>
string(19) "2009-08-07 10:29:00"
}
}
}
[6]=>
array(6) {
["file"]=>
string(57) "/new_www/www/libr/php/libstats/finders/
QuestionFinder.php"
["line"]=>
int(85)
["function"]=>
string(11) "autoexecute"
["class"]=>
string(8) "db_mysql"
["type"]=>
string(2) "->"
["args"]=>
array(4) {
[0]=>
string(9) "questions"
[1]=>
array(12) {
["location_id"]=>
int(1)
["question_type_id"]=>
int(1)
["question_type_other"]=>
string(0) ""
["time_spent_id"]=>
int(1)
["patron_type_id"]=>
int(1)
["question_format_id"]=>
int(3)
["initials"]=>
string(10) "sablllllll"
["question"]=>
string(4) "test"
["answer"]=>
string(6) "ttttt4"
["hide"]=>
int(0)
["delete_hide"]=>
int(0)
["question_date"]=>
string(19) "2009-08-07 10:29:00"
}
[2]=>
int(2)
[3]=>
string(16) "question_id = 41"
}
}
[7]=>
array(6) {
["file"]=>
string(61) "/new_www/www/libr/php/libstats/actions/
QuestionEditAction.php"
["line"]=>
int(66)
["function"]=>
string(12) "editquestion"
["class"]=>
string(14) "questionfinder"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
int(41)
[1]=>
array(12) {
["location_id"]=>
int(1)
["question_type_id"]=>
int(1)
["question_type_other"]=>
string(0) ""
["time_spent_id"]=>
int(1)
["patron_type_id"]=>
int(1)
["question_format_id"]=>
int(3)
["initials"]=>
string(10) "sablllllll"
["question"]=>
string(4) "test"
["answer"]=>
string(6) "ttttt4"
["hide"]=>
int(0)
["delete_hide"]=>
int(0)
["question_date"]=>
string(19) "2009-08-07 10:29:00"
}
}
}
[8]=>
array(6) {
["file"]=>
string(45) "/new_www/www/libr/php/libstats/Controller.php"
["line"]=>
int(39)
["function"]=>
string(7) "perform"
["class"]=>
string(18) "questioneditaction"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
}
["callback"]=>
NULL
}

[Randal Baier]

I see that this is quite an older post now. We have had the same problem and are trying to make a fix for it. All the other types are editable properly except for Question Type editing.

Has anyone created a fix for this since this post was written in Aug 2009.

We are looking at it too and don't want to reinvent the wheel.

Randal Baier

Eastern Michigan University

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "libstats" group.
To post to this group, send email to libs...@googlegroups.com
To unsubscribe from this group, send email to libstats+u...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/libstats?hl=en
-~----------~----~----~----~------~----~------~--~---