I just moved a site from a test server to a public server and got this error message:

user warning: You have an error in your SQL syntax near '(name, 30) AS vid FROM variable WHERE name LIKE 'taxonomy_hierarchical_select_%'' at line 1 query: SELECT SUBSTR(name, 30) AS vid FROM variable WHERE name LIKE 'taxonomy_hierarchical_select_%' AND value LIKE 'i:1\;'; in C:\Program Files\Apache2\htdocs\bookconnections\includes\database.mysql.inc on line 174.

I am using 5.x-3.0-rc7 and Drupal 5.14.

If you would like to see an example:
http://www.westlakelibrary.org/bookconnections/?q=content/immortal-game

My test server was at Drupal 5.15, same version of the module, and I didn't have this problem.

I did all that stuff before submitting this issue. There was one similar issue, but for an earlier version of the module.

Any ideas?

Thanks

mrweaver

Comments

Wim Leers’s picture

Wim Leers
Location Ghent 🇧🇪🇪🇺
CreditAttribution: Wim Leers commented
Category: support » bug
Status: Active » Closed (won't fix)

This is specific to one particular version of MySQL I think. You're the third to report this, but 98% of the people using the upgrade path don't have this problem. The only sensible thing is that you uninstall HS, reinstall it and reconfigure it. It'd take too much time to pinpoint the exact cause. Sorry and thanks for your understanding.