Location of subcategory files?

I am trying to find the files that contain my subcategory html pages so I can edit the html directly in the file itself instead of going to the admin to edit it. TIA!

There are no subcategory HTML pages in Zencart. Everything is built from PHP files and database entries. Let us know exactly what you want to change, and we might be able to help.

Thanks stevesh. I am building custom subcategory pages & Zencart is limiting how long the page can be. If it goes over a certain length, the code gets scrambled. Is there a way around this?

hflsales:

Thanks stevesh. I am building custom subcategory pages & Zencart is limiting how long the page can be. If it goes over a certain length, the code gets scrambled. Is there a way around this?

There aren't any "subcategory pages"... "Pages" - in the sense of static HTML pages - do not exist. Content and Information is stored in the DATABASE - not in any "files" - so your hunting for HTML files will lead you nowhere.

All category INFORMATION and CONTENT is contained in the database, and you add your content there (for categories, it is via the category EDIT function.)

There is technically NO LIMIT to the quantity of data you add, so if you wanted a category description to run to the length of Tolstoy's "War And Peace", this is quite possible (though impractical).

"Pages" are built on-the-fly by the PHP code, which gathers up the data and resources (such as images and DEFINE VARIABLES) and ASSEMBLES each page for the user - depending on what the user REQUESTS.

The "page" is delivered to the browser, and when the visitor clicks a link or performs an action, that "page" EVAPORATES FOREVER, and a NEW page is built by the PHP, which is then delivered to the browser.

Along the way, calculations can be made (and data stored), but EACH PAGE is made up for EACH UNIQUE VISITOR. And when they move around in the site, these pages "vanish" and new ones are made in their place.

i believe the length is set in the database, go to your database and edit for the subcategory, and increase the length it would accept. for example, say the sub category is set as VARCHAR(32), change this to VARCHAR(64) or anything longer

denniszc:

i believe the length is set in the database, go to your database and edit for the subcategory, and increase the length it would accept. for example, say the sub category is set as VARCHAR(32), change this to VARCHAR(64) or anything longer

Just wondering how is this relevant to the question?

Cheers
Rod

hflsales:

Thanks stevesh. I am building custom subcategory pages & Zencart is limiting how long the page can be. If it goes over a certain length, the code gets scrambled. Is there a way around this?

It may be i don't know what you mean by 'subcategory pages'. If you mean the product listing, there's an option in Admin - Configuration - Product Listing - Display Product Description that allows you to set the maximum length of the description . The default is 150 characters.

I went into the database and found the html for the category_description. But the html I need to edit is a sub category of a sub category. Does anybody know where I can find that? It is exactly what I need but not sure how to find it.

I found it but it says "Because of its length, this column might not be editable". Does anybody know how to make the text length of a column longer in the database?

hflsales:

I went into the database and found the html for the category_description. But the html I need to edit is a sub category of a sub category. Does anybody know where I can find that? It is exactly what I need but not sure how to find it.

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????

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.> 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????

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??

Here is the page that is being limited on my site.....http://www.p3america.com/shop/index.php?main_page=index&cPath=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. > 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??

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

Thank you so much!!! This fixed my problem!> 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

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.

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

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:

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.

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. > 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