Quote Originally Posted by conor View Post
Hi,
I replied to your e-mail.. did you get my e-mail ok?
Yes thanks, got your email. Will respond to it shortly, probably tomorrow actually.

Quote Originally Posted by conor View Post
Argh, I've tracked this and can see that you've found a bug.. the SQL is missing its closing quote.
I was a database programmer years ago so know a bit about databases. :)

Quote Originally Posted by conor View Post
In your case, you'd actually added an incorrect mapping, by manually adding a mapping for '/'.. a mapping was never required for the root of the site in version 3.8.0.
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.... ie... I have 20+ categories and on the left menu, I dont want them all together, so after 5 categories, I wanted a space and the way I did it was to create a category with a blank name... Having a cateory with a name with just a since space did nto work, it never made that space I wanted, so, I created the category with <ALT>255 - which is a blank character... There are 6 of these categories just the same... and if you remember my reply earier, the manual entry of the update command updated 6 rows... I manually looked into the tabe and see that is exactly the case... ^ records in the table now have the 'uri' field as blank. Not particularly bothered as there are no products in there, and I will manually do something to fix it..

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..!!

Quote Originally Posted by conor View Post
I understand why you needed to do that.. that's the "Admin Profiles" module. To be honest, that's really your responsibility to know how it works when you install it, but I guess it might be worth adding instructions for others who forget when they've got it installed to check its settings. :)
I agree that it is a good idea to put a line in the instructions for those that forget they have admin tools..

Cheers
Gertzy