Nodequeue Generate produces the following error when I attempt to Generate queue assignments:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sandbox.nodequeue_subqueue' doesn't exist: DELETE ns FROM nodequeue_subqueue ns INNER JOIN nodequeue_queue nq ON ns.qid=nq.qid WHERE nq.owner = 'smartqueue_taxonomy'; Array ( ) in nodequeue_generate_rehash() (line 117 of [~mysite~]/sites/all/modules/nodequeue/nodequeue_generate.module)

I looked at line 117 of nodequeue_generate.module and it tries to access the nodequeue_subqueue table directly without checking for a table prefix (which I'm using) and prepending it if it exists. I commented that line out and was able to generate queue assignments, so that appears to be the only place it's an issue.

CommentFileSizeAuthor
#1 1241602.patch736 bytesamateescu

Comments

amateescu’s picture

Status: Active » Fixed
StatusFileSize
new736 bytes

Fixed in 7.x-2.x with the attached patch. Thanks @sethfisher!

http://drupalcode.org/project/nodequeue.git/commit/1b33daf

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.