I was having an issue with nodequeue not displaying "add to nodequeue" buttons so I went to upgrade to the newest dev build, ran update.php to no issues then got the following error.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nq.qid' in 'field list': SELECT nq.qid, nq.show_in_tab, nq.show_in_links, nq.show_in_ui, nq.i18n FROM {nodequeue_queue} nq INNER JOIN {nodequeue_types} nt ON nt.qid = nq.qid WHERE nt.type = :type ; Array ( [:type] => blog ) in nodequeue_get_qids() (line 541 of (SiteURL)public_html/sites/all/modules/nodequeue/nodequeue.module).

When this happened I changed the schema value in the DB to 7002 which caused the updates to the DB to occur, but I still get this issue...

Any insights would be hugely helpful as NQ is tied into so many aspects of the site that it would be very hard to get things back on track without it.

Many thanks.

Comments

amateescu’s picture

amateescu commented
Status: Active » Postponed (maintainer needs more info)

This can only mean that you somehow switched between the 7.x-2.x and 7.x-3.x branches, because 7.x-3.x removes that column. Can you confirm this scenario?

faite’s picture

faite commented

That would make sense, but I stayed with the 2x version going from the stable to the dev release. Ill try and find the table from an old backup and restore it I suppose? That or maybe update to the 3.0 release. Ill do all and report back. Thanks!

faite’s picture

faite commented

Huh...so I upgraded to the 3x branch and got this error

Update #7300
Failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nq.qid' in 'field list': SELECT nq.qid AS qid, nq.name AS name FROM {nodequeue_queue} nq; Array ( ) in nodequeue_update_7300() (line 417 of public_html/sites/all/modules/nodequeue/nodequeue.install).

Now the site actually loads however, which is huge!

Really strange too considering that I never touched the 3x branch before...which seems impossible

also when I view an actual simple queue I get this error if its relevant at all.

Notice: Undefined property: stdClass::$new in nodequeue_edit_queue_form() (line 504 of public_html/sites/all/modules/nodequeue/includes/nodequeue.admin.inc).
Notice: Undefined property: stdClass::$new in nodequeue_edit_queue_form() (line 551 of public_html/sites/all/modules/nodequeue/includes/nodequeue.admin.inc).

Thanks for your help!

faite’s picture

faite commented

Huh now getting this when I try to add a queue.

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 ')' at line 1: SELECT name, use_parents FROM {smartqueue} WHERE name IN (); Array ( ) in smartqueue_nodequeue_alter() (line 168 of public_html/sites/all/modules/nodequeue/smartqueue.module

manos_ws’s picture

manos_ws commented

same error as faite on 7.x.3.x-dev

Any help on this?

shadysamir’s picture

shadysamir commented

I am getting

Notice: Undefined property: stdClass::$new in nodequeue_edit_queue_form() (line 504 of public_html/sites/all/modules/nodequeue/includes/nodequeue.admin.inc).
Notice: Undefined property: stdClass::$new in nodequeue_edit_queue_form() (line 551 of public_html/sites/all/modules/nodequeue/includes/nodequeue.admin.inc).

with 7.x-3.x-dev when I edit any queue settings

fizk’s picture

fizk commented
Version: 7.x-2.x-dev » 7.x-3.x-dev
Issue summary: View changes
fizk’s picture

fizk commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

If this issue still effects anyone, please reopen and describe how to reproduce.