Location of subcategory files?

**hflsales** · 24 Apr 2013, 04:32 PM

Because when I try to edit in the admin area in zencart, I am being limited on the length. Now I see that the length is limited in the database so would like to know how to make the max length in a column longer in the database.

Originally Posted by DivaVocals

ALL categories are stored in the CATEGORIES table.. (this includes SUB-categories)

The BIGGER question is WHY are you editing the category description in the categories TABLE when there is an entire admin section that allows you to CREATE and EDIT categories where you can do this????

**DivaVocals** · 24 Apr 2013, 04:35 PM

Originally Posted by hflsales

Because when I try to edit in the admin area in zencart, I am being limited on the length. Now I see that the length is limited in the database so would like to know how to make the max length in a column longer in the database.

The length of what exactly.. the description??, the category title?? Where are you being limited and what is average length of what you are attempting to put in this column/field??

**hflsales** · 24 Apr 2013, 05:09 PM

Here is the page that is being limited on my site.....http://www.p3america.com/shop/index....ath=38_104_105 When I try to add more, the page becomes garbled, the footer goes on top, and the tables get completely messed up. Thank you for your help.

Originally Posted by DivaVocals

The length of what exactly.. the description??, the category title?? Where are you being limited and what is average length of what you are attempting to put in this column/field??

**simon1066** · 24 Apr 2013, 05:26 PM

The table type for categories_description in your database is TEXT, as mysql says:

"A TEXT column can hold 64K (65,535 bytes) worth of data; LONGTEXT can hold 4GB (4,294,977,295 bytes). "

there is a MEDIUMTEXT (who's capacity I don't know but would be between the two), change this under the 'structure' tab for this table

**hflsales** · 24 Apr 2013, 05:47 PM

Thank you so much!!! This fixed my problem!

Originally Posted by simon1066

The table type for categories_description in your database is TEXT, as mysql says:

"A TEXT column can hold 64K (65,535 bytes) worth of data; LONGTEXT can hold 4GB (4,294,977,295 bytes). "

there is a MEDIUMTEXT (who's capacity I don't know but would be between the two), change this under the 'structure' tab for this table

**simon1066** · 25 Apr 2013, 07:58 AM

No problem.

BTW, I couldn't help but notice, when viewing your page source code that you have an erroneous </head> tag and a non-closed <body ...> tag at the start of your category description.

**RodG** · 25 Apr 2013, 10:47 AM

Originally Posted by simon1066

there is a MEDIUMTEXT (who's capacity I don't know but would be between the two)

~16Mb.

Note to OP.

Changing from TEXT to MEDIUMTEXT can increase your database requirements/usage by about 250 times.
Changing it to LONGTEXT can increase the requirement by about 65,000 times.

This may or may not cause performance issues.

If this were a field length that *I* needed to increase, I'd be inclined to use the VARCHAR field type, and define it to be a little over the maximum length that I think I'll ever need. 128K (double that of a 'standard' TEXT field) would probably suffice.

Now having said that, I can't help wondering what kind of product_descriptions you are using that exceeds the original 64k limit. Are you embeding graphics into your descriptions or something?

Cheers
Rod

**simon1066** · 25 Apr 2013, 11:46 AM

Originally Posted by RodG

Now having said that, I can't help wondering what kind of product_descriptions you are using that exceeds the original 64k limit. Are you embeding graphics into your descriptions or something?

It looked as though they were adding products to the categories description's html. i.e wanting to have products and sub-categories in the same category. As that wasn't part of the question I thought I would wait, perhaps until they attempted to activate the cart buttons that have been added to the description. Probably had a reason for it doing it so.

**simon1066** · 25 Apr 2013, 01:07 PM

Originally Posted by simon1066

I thought I would wait, perhaps until they attempted to activate the cart buttons that have been added to the description

That wasn't particularly helpful, apologies for that. If this is what you intend then I think you will have problems, better to list products within categories rather than try to code them into a categories description.

**hflsales** · 25 Apr 2013, 04:13 PM

If I use VARCHAR field type, how do I define it to be 28k? I have never had to edit the database before & wouldn't want to screw anything up. There are a few graphics embedded in the html. That is probably why it is so long but it needs to be the way it is. The cart buttons will eventually point to the items product page. We just haven't gotten that far yet.

Originally Posted by RodG

~16Mb.

Note to OP.

Changing from TEXT to MEDIUMTEXT can increase your database requirements/usage by about 250 times.
Changing it to LONGTEXT can increase the requirement by about 65,000 times.

This may or may not cause performance issues.

If this were a field length that *I* needed to increase, I'd be inclined to use the VARCHAR field type, and define it to be a little over the maximum length that I think I'll ever need. 128K (double that of a 'standard' TEXT field) would probably suffice.

Now having said that, I can't help wondering what kind of product_descriptions you are using that exceeds the original 64k limit. Are you embeding graphics into your descriptions or something?

Cheers
Rod

Thread: Location of subcategory files?

Thread Tools

Search Thread

Display

Re: Location of subcategory files

Re: Location of subcategory files

Re: Location of subcategory files

Re: Location of subcategory files

Re: Location of subcategory files

Re: Location of subcategory files

Re: Location of subcategory files

Re: Location of subcategory files

Re: Location of subcategory files

Re: Location of subcategory files

Similar Threads

Parent category page display subcategory and 4 procust of that subcategory

Skip subcategory link and list all subcategory products as product listing

Location of main files

Bookmarks

Bookmarks

Posting Permissions