Bug #14331
closed
Page ID is always 2147483647
0%
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)
Updated by Michael Stucki about 20 years ago
I cannot reproduce this. Can you please explain the detailed steps you've made?
Updated by old_mseeger about 20 years ago
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
Updated by Michael Stucki about 20 years ago
Could reproduce it finally, yes!
Thanks for reporting this bug.
Updated by Ingmar Schlecht about 20 years ago
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
Updated by Karsten Dambekalns about 19 years ago
This is a bug in MySQL that has been solved in later versions. This has been documented in the manual for the versioning extension.