Thread: Category Help
View Single Post
Old August 19th, 2004, 06:25 AM   #2
Chuck S
Photopost Developer
Verified Customer
Chuck S's Avatar
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,926
Some fancy mysql

You need to create the first block say category 1 with all its subcategories

Then you do a mysql export and in a text editor you need to change the main cat entry to another id value say whichever is the next autoincrement number next to come. You then need to edit the parent value in the export of all the subcats to be that new number. You then need to make the id value in all the subcats blank so it will follow the autoincrement on install.

Then take that tweaked mysql sql and run it.
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote