Bug #14331
closed
Page ID is always 2147483647
Added by old_mseeger almost 20 years ago.
Updated almost 18 years ago.
Description
After creating 2 pages while using extension "versioning", the third page has page ID 2147483647. Following new pages causes following error:
2: SQL error: 'Duplicate entry '2147483647' for key 1' (pages:NEW414fe336940a9)
(issue imported from #M378)
I cannot reproduce this. Can you please explain the detailed steps you've made?
The extension "version" seems to be the problem. You can reproduce it like this in a new imported dump:
1) create a new page (ID = 1)
2) make a version of this page (ID = 2)
3) publish this new version
4) create another new version -> (ID = 2147483647 !!!)
Because the ID of the second new version is 2147483647, is isn't possible to create any new page
Could reproduce it finally, yes!
Thanks for reporting this bug.
Kasper writes:
- DO NOT use the new "version" extension if you are running a MySQL version below 4.0.18! If you do a bug in MySQL will mess up the "Next Autoindex" of tables in the database meaning that unique IDs are raised to nearly 2 billion and you will get a lot of trouble. This is NOT a bug in TYPO3, but a problem with MySQL which seemingly is fixed in versions above 4.0.18
This is a bug in MySQL that has been solved in later versions. This has been documented in the manual for the versioning extension.
Also available in: Atom
PDF