Issue with dash in map name

[acet Profile]

In an attempt to help figure this out I have included the error message, my htaccess file and my configuration file.

The url I am having an issue with is http://www.example.com/film-tv/products/lighting/index.asp

Its actually all rewritten urls that start with http://www.example.com/film-tv/

There were 4 different map files used on my site, "lighting", "audio", "rigging" and "video". Each one has its own category map db. This system works, it has been for a couple of years. We have added a new one, "film-tv", and it is this that is causing problems.

Here is an example rule that doesn't work with "film-tv":

Code: Select all

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond ${$1_map_dbd:$2|NOT_FOUND} !NOT_FOUND
RewriteRule ^([^?/]+)/products/([^?/]+)(/)?(index\.asp)?$ cat2.asp?div=${cat_map_dbd:$1}&cat2=${$1_map_dbd:$2} [NC,QSA,L]

As you can see, its dynamically creating the required map file based on the first parameter in the url. It seems that the "-" is making it think it needs to do a subtraction. Is there any way I can stop this? I need to keep "film-tv" in the url.

Hopefully I have provided enough information for you, if not, let me know and I will do what I can.

Cheers,

Steve

[Anton]

Hello,

"As you can see, its dynamically creating the required map file based on the first parameter in the url. It seems that the "-" is making it think it needs to do a subtraction. Is there any way I can stop this? I need to keep "film-tv" in the url."
- Have you tried hardcoding "film-tv" part of mapfile name and testing it with a static rule written specifically for film-tv_map_dbd? Just for testing. Chances are that dash is not a valid character for mapfile name.

[acet Profile]

Hi Anton,
I just tried this:

Code: Select all

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond ${film-tv_map_dbd:$1|NOT_FOUND} !NOT_FOUND
RewriteRule ^film-tv/products/([^?/]+)(/)?(index\.asp)?$ cat2.asp?div=1316&cat2=${film-tv_map_dbd:$1} [NC,QSA,L]

Got the same error message. But when I changed the map name I was getting the same error. I then started to look elsewhere for the dash, and realised it was in my view name in the sql. Renamed my view and its now working correctly, even with the dash in the map name.

So, the lesson here is that no dashes in sql.

Cheers,

Steve