By colin_e on

Hi,

I'm trying to use the "Hackable URLs" technique described here- http://drupal.org/node/247205 to create a hierarchy of stories, something like-

//siteurl/story/storyname/episode

However, the in the example, the grouping values in the hierarchy happened to be numbers (/blog/2008/06/blogtitle). In my case the grouping value is a string (the title of the story).

I'm having majot trouble with this. I find that if a numeric parameter is passed to views, everything works ok, but if the parameter is a string it blows up with the error-

    * warning: Invalid argument supplied for foreach() in /u0/drupal.product/product-1.0.0.9/modules/node/node.module on line 521.
    * warning: implode() [function.implode]: Bad arguments. in /u0/drupal.product/product-1.0.0.9/modules/node/node.module on line 525.
    * 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 '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /u0/drupal.product/product-1.0.0.9/includes/database.mysqli.inc on line 151.

I.e. with a view supplying the /story page-

      /story/1               works ok
      /story/a               fails with the above error

Is there any way out of this? Having stories whose titles are number is not really an option.

Thanks in advance for any help-

Regards: colin_e

⋅ Categories: Drupal 5.x