| Issue Number | 389 |
|---|---|
| Summary | SQL error when creating literature packets by non-board member |
| Created | 2016-06-28 12:29:11 |
| Issue Type | Bug |
| Submitted By | zhangy41 |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2016-09-09 10:14:49 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/oceebms/issue.187043 |
Steps to reproduce on QA Server:
1. Login to an account that hasn't been assigned to any board, and go
to https://ebms-qa.nci.nih.gov/review/add
to create a packet
2. Select any board and any topic, and click “Upload Packet” at the
bottom
3. A SQL error occurred: 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 ')) ORDER BY t.topic_name ASC' at line 1: SELECT
t.topic_id AS topic_id, t.topic_name AS topic_name FROM {ebms_topic} t
WHERE (t.board_id IN ()) ORDER BY t.topic_name ASC; Array ( ) in
EbmsReview::packet_topic_list() (line 3477 of
/local/drupal/sites/ebms.nci.nih.gov/modules/custom/ebms/review.inc).
Fixed on DEV. Tested by developer (would be tricky, but not impossible, for the users to test, but I don't think that's necessary).
| File Name | Posted | User |
|---|---|---|
| EBMS_packet.png | 2016-06-28 12:29:11 | |
| Error EBMS.png | 2016-06-28 12:29:11 |
Elapsed: 0:00:00.000634