When doing bulk updates for Taxonomy's I get the following error:

user warning: 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 ') LIMIT 0, 50' at line 1 query: SELECT tid, vid, name, src, dst FROM wigs_term_data LEFT JOIN wigs_url_alias ON CONCAT('taxonomy/term/', CAST(tid AS CHAR)) = src WHERE src IS NULL AND vid <> 0 ) LIMIT 0, 50 in /home/ronnie/public_html/drupal/sites/all/modules/pathauto/pathauto_taxonomy.inc on line 84.

Comments

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Active » Postponed (maintainer needs more info)

That's certainly a mal-formed query, but I can't repeat it on my sites. I believe this caused by some pattern/vocab settings which are not anticipated by the module.

How many vocabularies do you have on this site and what are your pattern settings for those vocabularies? It might be useful if you take a screenshot of the "Taxonomy term path settings" section of the Pathauto admin screen.

Thanks.

jose.guevara’s picture

jose.guevara commented

I had the same issue on the 5 version. I patched mine, I hope the right way :-) Or, if you don't want to patch, create at least one Taxonomy category.

My patch

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Postponed (maintainer needs more info) » Closed (duplicate)

Yes, we should make this a duplicate of your issue, Jose.

Thanks! #286845: Bulk Update of Category Path with no existing categories AND/OR remove bulk generate checkbox?