To reproduce

(1) install nodequeue_generate and nodequeue on a new drupal site
(2) create exactly one article node (the problem might occur with several or no nodes, but was tested with exactly one).
(3) create one nodequeue called "test" for "article" types
(4) go to admin/structure/nodequeue/generate_nodequeue
(5) select "test" and click "Generate"
(6) this error occurs:

PDOException: SQLSTATE[HY000]: General error: 1 near "ns": syntax error: 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 129 of /Applications/MAMP/htdocs/_rdc_nodequeue/drupal/sites/all/modules/nodequeue/nodequeue_generate.module).

Comments

alberto56’s picture

alberto56 commented

Same with drush:

drush nodequeue-generate test
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1  [error]
near "ns": syntax error' in
/Applications/MAMP/htdocs/_rdc_nodequeue/drupal/includes/database/sqlite/database.inc:238
Stack trace:
#0
/Applications/MAMP/htdocs/_rdc_nodequeue/drupal/includes/database/sqlite/database.inc(238):
PDO->prepare('DELETE ns FROM ...', Array)
#1
/Applications/MAMP/htdocs/_rdc_nodequeue/drupal/includes/database/sqlite/database.inc(456):
DatabaseConnection_sqlite->PDOPrepare('DELETE ns FROM ...')
#2
/Applications/MAMP/htdocs/_rdc_nodequeue/drupal/includes/database/prefetch.inc(163):
DatabaseStatement_sqlite->getStatement('DELETE ns FROM ...', Array)
#3
/Applications/MAMP/htdocs/_rdc_nodequeue/drupal/includes/database/sqlite/database.inc(461):
DatabaseStatementPrefetch->execute(Array, Array)
#4
/Applications/MAMP/htdocs/_rdc_nodequeue/drupal/includes/database/database.inc(683):
DatabaseStatement_sqlite->execute(Array, Array)
#5
/Applications/MAMP/htdocs/_rdc_nodequeue/drupal/includes/database/database.inc(2350):
DatabaseConnection->query('DELETE ns FROM ...', Array, Array)
#6
/Applications/MAMP/htdocs/_rdc_nodequeue/drupal/sites/all/modules/nodequeue/nodequeue_generate.module(129):
db_query('DELETE ns FROM ...')
#7
/Applications/MAMP/htdocs/_rdc_nodequeue/drupal/sites/all/modules/nodequeue/nodequeue_generate.drush.inc(85):
nodequeue_generate_rehash()
#8 [internal function]: drush_nodequeue_generate('test')
#9 /Users/albert/.composer/vendor/drush/drush/includes/command.inc(359):
call_user_func_array('drush_nodequeue...', Array)
#10 /Users/albert/.composer/vendor/drush/drush/includes/command.inc(210):
_drush_invoke_hooks(Array, Array)
#11 [internal function]: drush_command('test')
#12 /Users/albert/.composer/vendor/drush/drush/includes/command.inc(178):
call_user_func_array('drush_command', Array)
#13
/Users/albert/.composer/vendor/drush/drush/lib/Drush/Boot/DrupalBoot.php(46):
drush_dispatch(Array)
#14 /Users/albert/.composer/vendor/drush/drush/drush.php(76):
Drush\Boot\DrupalBoot->bootstrap_and_dispatch()
#15 /Users/albert/.composer/vendor/drush/drush/drush.php(16): drush_main()
#16 {main}

  • fizk committed b432ff8 on 
    Issue #2417279: Nodequeue Generate causes PDOException in SQLite.
fizk’s picture

fizk commented
Title: Nodequeue Generate causes PDOException » Nodequeue Generate causes PDOException in SQLite
Status: Active » Fixed

It seems SQLite doesn't support multiple-table syntax for the DELETE statement:

https://www.sqlite.org/lang_delete.html

I've committed a fix to dev. Let me know if you still see this error.

Status: Fixed » Closed (fixed)

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