Limiting breadcrumbs by path and choosing where to insert

Hmm, I got an error.
- I uninstalled custom breadcrumbs.
- Then I installed the patch, and uploaded patched files.
- Then I enabled the it in /admin/build/modules

I got this 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 '(bid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */' at line 8 query: CREATE TABLE custom_breadcrumb ( bid int unsigned NOT NULL auto_increment, titles varchar(255) NOT NULL default '', paths varchar(255) NOT NULL default '', node_type varchar(64) default '', pages varchar(255) default '', placement varchar(64) default '' PRIMARY KEY (bid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/scott/public_html/njsavings/includes/database.mysql.inc on line 172.

Any thoughts about what I may have done wrong?

Thanks! Cause this would be great functionality

Scott

ugh.

Ok, so I tried to uninstall this patched module (after disabling it), and get the following error:

user warning: Unknown table 'custom_breadcrumb' query: DROP TABLE custom_breadcrumb in /home/scott/public_html/njsavings/includes/database.mysql.inc on line 172.

Now I'm kind of stuck. where do I go from here?

Thanks for any help!
Scott

No suggestions? :(

Hi -
has there been any progress on this?

I'm no longer grappling with the error above (reinstalled site a while ago)...

But this functionality would be very useful on other sites -- especially adding before an existing breadcrumb.

One example illustrates how useful this would be:
Another module - Node hierarchy, automatically shows children of children of children (etc) in order, in the breadcrumb. However, if the content-type were called 'project', and I wanted the url to go something like: http://url.com/projects/parent/child/grandchild/greatgrandchild
then it would make sense for the breadcrumb to also go something like:
Home › Projects › Parent › Child › Grandchild › Greatgrandchild
But AFAIK, there is no way to do this using custom breadcrumbs as it is (each breadcrumb needs to go on it's own line, so a specified number of crumbs is all we can do).

However, adding to the beginning would allow us to take advantage of the NH module's existing functionality, and still customize our breadcrumb.

So, I'm wondering - has anyone had success with this patch? Or deviantintegral - did you get some updated version of this to work for your own use (if so, care to share)?

Thanks in advance for any help, suggestions, leads...
:)
Scott

I manually added this patch and I receive 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 'titles, paths, node_type, pages, placement) VALUES ('Public Policy', 'pub', 'p' at line 1 query: (titles, paths, node_type, pages, placement) VALUES ('Public Policy', 'pub', 'page', 'pub/*', 'begin') in C:\wamp9.22\www\includes\database.mysql.inc on line 174.

Did I mistype or is this an issue? Any help would be appreciated!

Hey, thanks for the alternative to manually patching...I tried Tortise (I believe) but I need to play around with the "how-to" a little more because I don't understand quite how it works..

But I re-did the manual patching, ran update.php and everything works beautifully.

Thanks for your reply!

Closing this issue because 5.x is closed to feature requests at this point. It may be of interest for the 6.x-2.x version, but I think this can now be done on a per breadcrumb basis without having to modify the database by expanding on the special identifiers that were introduced in that version.

If this is of interest, please reopen as a 6.x-2.x feature request.