scole
11-14-2005, 01:50 AM
I wrote a simple script to bulk add all states (or provinces) to a category. It works perfect. Just select (United States), choose parent directory from pull down, and click submit. All 50 states are added to the database under the category.
Sample sql statement.
Content visible to registered users only.
The states are added without problem. I can modify them, add links within them, and pretty do anything I want...
The problem I'm having is this. Just say I wanted to add another category within the United States category. I go into admin, add category, and save. No errors, but when I go to view it, the first state has been renamed to the new category. This will continue if I keep adding more categories (ie second state will rename, third, and so on).
I don't see any problems with the auto Autoindex of the table the next number in the table is correct. What could be causing the already added states to rename when trying to add a new category?
Any ideas?
S. Cole
Sample sql statement.
Content visible to registered users only.
The states are added without problem. I can modify them, add links within them, and pretty do anything I want...
The problem I'm having is this. Just say I wanted to add another category within the United States category. I go into admin, add category, and save. No errors, but when I go to view it, the first state has been renamed to the new category. This will continue if I keep adding more categories (ie second state will rename, third, and so on).
I don't see any problems with the auto Autoindex of the table the next number in the table is correct. What could be causing the already added states to rename when trying to add a new category?
Any ideas?
S. Cole