Huge Session Values trying to post

[DrByte]

1. Line 70 of that file in the release-version of v1.5.4 says:

        set expiry = '" . zen_db_input($expiry) . "', value = '" . zen_db_input($val) . "'

2. You said this "huge session value" occurs when "trying to POST".
I'm assuming there's nothing significant about "what" you're trying to POST, and that it happens on "any page" instead of isolated to just a specific page, else you would have mentioned those details.
You also didn't mention PHP or MySQL versions.


I'm guessing that you've modified the cart in such a way that there's a ton of data being saved to $_SESSION variables, and if you wish to continue doing that (not recommended) then you may need to increase both your MySQL configuration for max bytes and your db table definition for the 'value' field ... and perhaps more things caused as side-effects.

[bislewl]

1. Line 70 of that file in the release-version of v1.5.4 says:

        set expiry = '" . zen_db_input($expiry) . "', value = '" . zen_db_input($val) . "'

2. You said this "huge session value" occurs when "trying to POST".
I'm assuming there's nothing significant about "what" you're trying to POST, and that it happens on "any page" instead of isolated to just a specific page, else you would have mentioned those details.
You also didn't mention PHP or MySQL versions.


I'm guessing that you've modified the cart in such a way that there's a ton of data being saved to $_SESSION variables, and if you wish to continue doing that (not recommended) then you may need to increase both your MySQL configuration for max bytes and your db table definition for the 'value' field ... and perhaps more things caused as side-effects.

Boy I made helping me soo difficult...

I incorrectly used the word post I should have said "insert into the database"

PHP Version: 5.5.27
Database: MySQL 5.6.23

It's a 3rd party template. The part about saving a bunch in the session is very interesting...and you were exactly right!

This I think could be the problem...I think saving the categories descriptions down 9 levels to a $_SESSION[] could have been an issue...

<div id="tm_categories" class="clearfix">
            <?php echo $_SESSION['category_tree']->buildCategoryString(
            '<ul class="{class}">{child}</ul>','<li class="{class}"><a class="category-top" href="{link}" title="{name}"><span>{name}</span></a>{child}</li>', 0, 0);?>
        </div>

combined with:

while (!$categories->EOF) {
                $this->category_tree[$categories->fields['categories_id']]['name'] = $categories->fields['categories_name'];
                $this->category_tree[$categories->fields['categories_id']]['image'] = $categories->fields['categories_image'];
                $this->category_tree[$categories->fields['categories_id']]['description'] = $categories->fields['categories_description'];
                $this->category_tree[$categories->fields['categories_id']]['parent_id'] = $categories->fields['parent_id'];
                $this->category_tree[$categories->fields['categories_id']]['path'][] = $categories->fields['categories_id'];
                $this->category_tree[$categories->fields['parent_id']]['sub_cats'][] = $categories->fields['categories_id'];
                $categories->MoveNext();
            } 

I modified the includes/application_bottom.php
to read:

// close session (store variables)
unset($_SESSION['category_tree']);
session_write_close(); 

Thanks for your help as always hopefully this helps someone else too!