I received this error when bulk updating some url aliases.

I deleted all aliases then bulk updated them, 34 aliases were created:

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 term_data LEFT JOIN url_alias ON CONCAT('taxonomy/term/', CAST(tid AS CHAR)) = src WHERE src IS NULL AND vid <> 0 ) LIMIT 0, 50 in /drupal/sites/all/modules/pathauto/pathauto_taxonomy.inc on line 84.

It looks like a taxonomy issue, I do not have any vocabs setup, but did select the box. Just thought you might like to know the error.

Thanks!

Comments

Freso’s picture

Freso commented

Looks like there's a parentheses-end too much. Whether it's in Pathauto or Taxonomy or somewhere else, I can't tell from this... and I don't have time to investigate. But now I posted my immediate observation in case someone else goes to dig into this. :)

bsherwood’s picture

bsherwood commented

I am not sure were the error came from but I figured I would add it to see if anyone else was getting it and if there is a fix.

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Title: MySQL Error? » MySQL Error during bulk generate of taxonomy terms

If you run bulk generate again does the error happen again?

bsherwood’s picture

bsherwood commented

Ok I tried it again. Here are the steps that I took:

1. Deleted ALL aliases (no errors)
2. Bulk updated node path urls (no errors)
3. Bulk updated user path urls (no errors)
4. Bulk updated taxonomy term path setting (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 term_data LEFT JOIN url_alias ON CONCAT('taxonomy/term/', CAST(tid AS CHAR)) = src WHERE src IS NULL AND vid <> 0 ) LIMIT 0, 50 in /drupal/sites/all/modules/pathauto/pathauto_taxonomy.inc on line 84.

Granted, I don't have any vocabs setup, but should this return an error? Maybe a "No vocabularies set up" message would be more appropriate.

I hope this helps.

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Active » Closed (duplicate)

Aha. In the original report you said 34 aliases were created which made me think that those were 34 taxonomy aliases that were created...

I think this is a duplicate of #286845: Bulk Update of Category Path with no existing categories AND/OR remove bulk generate checkbox?

hankinstrio’s picture

hankinstrio commented

I am new to drupal and I got the exact same error message. I just downloaded and enabled pathauto and checked all the bulk generate aliases boxes and this error came up. I comment because bsherwood's comment seems to indicate that there is not really any error to worry about. Is there any more help on this?