State Subcategories

[tarheit]

For those wanting to add states as categories, I found it much easier to run the following query in phpMyAdmin rather than create each manually in the admin area. Just search the following code for 117 and replace it with the id of the category the states should fall under. Then run the code in phpMyAdmin. I found it saved a lot of time when adding sub categories to several different main categories.

Content visible to registered users only.

-Tim

[anylink]

very nice thanks a load!

[DelMarSurf]

YEA! This works perfectly. Thanks!!! :D

[anon]

Content visible to registered users only.
Remember, i never steer anyone wrong, and like i told you, this breaks things in terms of adding more new categories. Step 2 is to now find my post to fix what's been hacked up by the original posters database additions.

Rob

[montytx]

Does anyone have a state/ city dump they could share?

[johnbmtl]

When I try running this on the database (using 3.2), I get the following error:

"#1136 - Column count doesn't match value count at row 1 "

Is this because of something that I am not doing correctly or has the database changed since this was posted?

John

[searchangle]

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT INTO PLD_CATEGORY VALUES ('','Alaska','Alaska',NULL,3,2,NOW(),0,0,0); ' at line 1

[omakad]

I'm getting the same error. I've run this code before for the rest of my cat's but now it's not working any more. Has anyone figured out what is going on?

[Mr_Bill]

If you are trying to use this for v.3.2 you could try this

Content visible to registered users only.

[omakad]

Do we still need to specify the category ID anywhere in this code? and if yes then where? I'm sorry I'm retarded about running mySQL inquires. Thanks.