Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.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 'custom menu added by XML Sitemap: Menu module, which can optionally be ' at line 1 query: UPDATE db_menu_custom SET description =A custom menu added by XML Sitemap: Menu module, which can optionally be used as a source for menu links in the sitemap for more fine-grained control. WHERE menu_name = 'menu-xmlsitemap' in ./xmlsitemap/xmlsitemap_menu/xmlsitemap_menu.install on line 126.
The following queries were executed
xmlsitemap_menu module
Update #6108
* Failed: UPDATE {menu_custom} SET description =A custom menu added by XML Sitemap: Menu module, which can optionally be used as a source for menu links in the sitemap for more fine-grained control. WHERE menu_name = 'menu-xmlsitemap'
| Comment | File | Size | Author |
|---|---|---|---|
| #4 | xmlsitemap-issue-442062.patch | 1.19 KB | Anonymous (not verified) |
Comments
Comment #1
Elan Hasson commentedI have same issue.
It seems that 's were missing around the value to set the description column's value.
"drup_menu_custom" below was what i substituted the {menu_custom} variable for.
I believe the correct query to be executed should be:
UPDATE drup_menu_custom SET description ='A custom menu added by XML Sitemap: Menu module, which can optionally be used as a source for menu links in the sitemap for more fine-grained control.' WHERE menu_name = 'menu-xmlsitemap'
Comment #2
Elan Hasson commentedComment #3
strikehawkecomm commentedMySQL 4.1.x also throws this issue with Apache 2.x
Comment #4
Anonymous (not verified) commentedTry this patch.
Comment #5
dave reidupdate_sql does not support placeholders
Comment #6
avpadernoThe SQL query clearly misses the delimiters for the string, and that is the only thing that needs to be corrected. I will do it, later.
Comment #7
Anonymous (not verified) commentedI love consistency. A flaw of the API.
Comment #8
avpadernoThis has been fixed in CVS.
Thanks for the report.