1

I've been trying to import thousands upon thousands of entries into a few different channels.

Before I get too far into my current project, I just wanted to clarify that there is no limit as to how high the entry IDs can go in ExpressionEngine.

2 Answers 2

5

Entry IDs are stored as an unsigned integer field in MySQL, meaning the maximum value is 4294967295

1
  • 1
    The caveat is, it is an auto_increment column. So, if you create and delete a lot of test entries again and again (import and delete), and cycle through this procedure enough times, and reach ~ 4 billion then -poof-
    – GDmac
    May 21, 2014 at 8:14
3

More a general MySQL tip: if you need to test the import and re-import a couple of times, keep an eye on the auto_increment value for the entry_id column of exp_channel_titles. Either reset auto_increment after deleting a test import, or set the entry_id value as well on import.

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.