Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

cms_page level field grows to 4294967295 and kills site. #1633

Closed
jessenash opened this Issue Feb 8, 2013 · 6 comments

Comments

Projects
None yet
5 participants

This is a bit of a noodle scratcher. Something indirect happens to the cms_page table in the database, loading up the 'level' field to it's highest possible integer, then crashes. I can't seem to find the cause, but I'm able to clear the error by replacing that funny value with something normal like 0, 1 or 2. Here's part of the dump. Any feedback would be appreciated.

Django Version:
1.4.2

Exception Type:
OverflowError

Exception Value:
cannot fit 'long' into an index-sized integer

Exception Location:
/home/ubuntu/.virtualenvs/h4h/lib/python2.6/site-packages/cms/forms/utils.py in update_site_and_page_choices, line 50

Python Executable:
/usr/bin/python

Python Version:
2.6.6

Collaborator

ojii commented Feb 9, 2013

We'll need at the very least a complete traceback.

I assume your page tree isn't 4294967295 levels deep, right?

Ha, nope the tree level is never deeper than 3 or 4 for the entire site. I'll post a complete traceback the next time it comes up.

Contributor

beniwohli commented Feb 12, 2013

could this be some kind of overflow where something is subtracted from an unsigned 32-bit int? What database engine do you use?

hmm we're using mysql 3.23. Is it possible a user action can cause that field to subtract negative of 0? Is there a database contraint of some kind I can set to prevent that? Weird error.

@digi604 digi604 added this to the 3.X milestone Feb 10, 2014

Member

digi604 commented Feb 10, 2014

mptt removal should fix this

Contributor

evildmp commented Jul 21, 2015

Now that we no longer use MPTT, this no longer applies either.

@evildmp evildmp closed this Jul 21, 2015

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment