vkaryl
11-16-2005, 04:18 AM
Reporting:
I started out by simply uploading the entire distro (not worrying at this point about the tabled template included). The install went just as smooth as they always do. I was able to access the main page of the directory and the admin, no problems. I created the USA as my only region, with the database ID therefore of 1.
Problems began once I'd imported the USA database (and I'll start another thread with suggestions on that, due to some monkeying around I had to do, and a couple of how-tos I'd like the answer for).
1. The states (contents of the PLD_ZONE table) display just fine, and are clickable. I need to know how to get rid of the underscore where a space should be. For now I've done away with spaces between state "first" and "second" words. This is minor.
2. THIS is major. Clicking through from USA to any state NEVER shows the associated cities. I've fine-tooth-combed the tables; the cities appear to be attached to the appropriate state ("zone") id, but they don't display.
3. In order to double check the whole situation, I emptied the PLD_CITY table, then entered a Utah city through Admin. It showed up just fine. HOWEVER, there was another problem with THAT: I added a couple of links for that city - selecting the city, while it showed the appropriate category etc., refused to show the links when the category was clicked on.
Without fixes, this makes it fairly unusable, obviously.
Hopefully this is simply something odd about the intermesh of the USA database with my server (though I've not had troubles with other programs where I've imported databases wholesale....)
Let me know if y'all come up with anything. I can (and will of course) use phpLD if necessary - and I've returned my site to that while I work on this other thing. I'll have to go back tomorrow and set up a new test server though....
I started out by simply uploading the entire distro (not worrying at this point about the tabled template included). The install went just as smooth as they always do. I was able to access the main page of the directory and the admin, no problems. I created the USA as my only region, with the database ID therefore of 1.
Problems began once I'd imported the USA database (and I'll start another thread with suggestions on that, due to some monkeying around I had to do, and a couple of how-tos I'd like the answer for).
1. The states (contents of the PLD_ZONE table) display just fine, and are clickable. I need to know how to get rid of the underscore where a space should be. For now I've done away with spaces between state "first" and "second" words. This is minor.
2. THIS is major. Clicking through from USA to any state NEVER shows the associated cities. I've fine-tooth-combed the tables; the cities appear to be attached to the appropriate state ("zone") id, but they don't display.
3. In order to double check the whole situation, I emptied the PLD_CITY table, then entered a Utah city through Admin. It showed up just fine. HOWEVER, there was another problem with THAT: I added a couple of links for that city - selecting the city, while it showed the appropriate category etc., refused to show the links when the category was clicked on.
Without fixes, this makes it fairly unusable, obviously.
Hopefully this is simply something odd about the intermesh of the USA database with my server (though I've not had troubles with other programs where I've imported databases wholesale....)
Let me know if y'all come up with anything. I can (and will of course) use phpLD if necessary - and I've returned my site to that while I work on this other thing. I'll have to go back tomorrow and set up a new test server though....