PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'IN/ALL/ANY subquery': DELETE FROM {smartqueue} WHERE `name` NOT IN (SELECT `name` FROM {nodequeue_queue}); Array ( ) in smartqueue_update_7002() (line 97 in /sites/all/modules/nodequeue/smartqueue.install).

Update from beta to dev.

Comments

divined’s picture

divined CreditAttribution: divined commented
Issue summary: View changes
othermachines’s picture

othermachines CreditAttribution: othermachines commented
Title: Update from beta to dev » PDOException in smartqueue_update_7002()

Changing title for clarity

jenlampton’s picture

jenlampton
she / her
CreditAttribution: jenlampton as a volunteer and at Jeneration Web Development for BGP Site Solutions commented
Status: Active » Closed (outdated)

I'm closing this issue as outdated because this is what I see in the update function today:

/**
 * Clean-up leftovers from the {smartqueue} table.
 */
function smartqueue_update_7002() {
  db_query('DELETE FROM {smartqueue} WHERE qid NOT IN (SELECT qid FROM {nodequeue_queue})');

  return t('The {smartqueue} table has been cleaned.');
}