State Subcategories

tarheit · 01-12-2006

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.

Code:

Content visible to registered users only.

-Tim

anylink · 01-13-2006

very nice thanks a load!

DelMarSurf · 06-02-2006

YEA! This works perfectly. Thanks!!!

anon · 06-02-2006

Code:

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 · 10-29-2006

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

johnbmtl · 05-28-2007

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 · 06-22-2007

#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 · 08-28-2007

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 · 08-28-2007

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

Code:

Content visible to registered users only.

omakad · 08-29-2007

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.

06-02-2006	#3
DelMarSurf Supporter Join Date: May 2006 Posts: 55	YEA! This works perfectly. Thanks!!! __________________ Anchor Text Link Directory :: Online Publishing Directory

06-02-2006	#4
anon Supporter Join Date: Feb 2006 Location: As far from you as humanly possible! Posts: 2,860	Code: 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

10-29-2006	#5
montytx Supporter Join Date: Feb 2006 Posts: 15	Does anyone have a state/ city dump they could share? __________________ Some of my sites.... Dallas Directory roofing contractor

06-22-2007	#7
searchangle Join Date: May 2007 Posts: 63	I get the Following Error - CAN YOU HELP??? #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 __________________ ______________________________________________ My Site: Free SEO Tools Directory - SEO Tool Land

08-28-2007	#9
Mr_Bill Supporter Join Date: May 2007 Posts: 159	If you are trying to use this for v.3.2 you could try this Code: Content visible to registered users only.

01-12-2006	#1
tarheit Supporter Join Date: Jan 2006 Location: Ohio Posts: 26	State Subcategories 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. Code: Content visible to registered users only. -Tim Last edited by David; 03-21-2009 at 10:48 PM.

01-13-2006	#2
anylink Join Date: Dec 2005 Posts: 7	very nice thanks a load!

05-28-2007	#6
johnbmtl Join Date: May 2007 Location: Blainville (Montreal area), QC. Canada Posts: 21	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

08-28-2007	#8
omakad Supporter Join Date: Jul 2007 Posts: 21	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?

08-29-2007	#10
omakad Supporter Join Date: Jul 2007 Posts: 21	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.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)