Ceon URI Mapping v4

[conor]

Hi,

I was a database programmer years ago so know a bit about databases. :)

lol it's wasn't the SQL I was referring to per say, but the fact that I was outputting the SQL without an end quote in the PHP code.. it was the PHP that was messed up. Anyway... :)

Actually, I have not added any manual database entries into the 3.8.0 table. I have looked at it and see this... I have created 6 x categories in Zen that act as spacers.... the way I did it was to create a category with a blank name...

One thing I will say about that is, I dont know how those 6 blank categories got into your mappings table because I KNOW, that I have never edited those 6 categories to manually get them into the URI database like I did with the 400 or so other categories... So a little confused with that..!!

Ceon URI Mapping will have automatically generated a URI whenever you edited these categories in the admin. So although you didn't manually modiofy the Ceon URI Mapping database, these "rogue" mappings still got in. The software simply wasn't built to cope with nameless categories, which is how we found ourselves in the situation that we did. :)

Not a big deal, just delete those mappings manually from your database and stop using "fake categories" for layout! :)

If you want to add a space you should actually just reprogram the categories sidebox so that it modifies the output HTML.

Having a category with no name will break auto-generation of all categories below that level.

So...

Move all your categories back to the parent level, delete the six fake ones and adjust the categories sidebox to preceed the categories' names with   after the first five.

I agree that it is a good idea to put a line in the instructions for those that forget they have admin tools..

I'll add this reminder into a future version.

All the best...

Conor
ceon