| Issue Number | 236 |
|---|---|
| Summary | Got SQL Exception error when click on reviewed packet link |
| Created | 2014-08-11 11:38:38 |
| Issue Type | Bug |
| Submitted By | tanguturisk |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2014-08-11 12:18:34 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/oceebms/issue.136247 |
Got SQL Exception error when click on reviewed packet link in Dev
Env.
Steps:
1. Go to Reviewed packet page
2. Click on any review packet link under filter results.
Actual:
Got an SQL Exception error.
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064
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 'FROM
ebms_board b INNER JOIN ebms_topic t ON t.topic_id = b.topic_id INNER
JOIN' at line 1: SELECT FROM {ebms_board} b INNER JOIN {ebms_topic} t ON
t.topic_id = b.topic_id INNER JOIN {ebms_packet} p ON p.topic_id =
t.topic_id WHERE (p.packet_id = :db_condition_placeholder_0) ; Array (
[:db_condition_placeholder_0] => 13762 ) in
EbmsReview->show_reviewed_packet() (line 1213 of
/local/content/web/appdev/sites/ebms.nci.nih.gov/modules/custom/ebms/review.inc).
Note:
Attached the screenshot.
I'm a little confused. The part of the code referenced by the error message looks like code which would only be encountered if the current user is a board manager, not a board member. Could you confirm that you really had logged on as a board member to review a packet (rather than as as board manager to look at reviewed packets)? The key is the distinction between "review packet" which a board member does and "reviewed packets" which a board manager looks at.
In general, it would be helpful for all defect reports if you provide as much detail for the steps used to reproduce the problem. One of the indispensable details is the current user's role.
Thanks.
Logged in as "board manager" and trying view reviewed packet.
Ah, that makes more sense, thanks. Can you give it another try?
Verified and issue fixed in Dev.
Closing as fixed in Dev. Thanks Bob for quick fixed.
| File Name | Posted | User |
|---|---|---|
| screenshot.gif | 2014-08-11 11:38:38 |
Elapsed: 0:00:00.000635