Skip to content
New issue

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

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

item_table field in revision_tracker table is not long enough for table names #2331

Closed
jubjubinc opened this issue Aug 25, 2022 · 0 comments · Fixed by #2332
Closed

item_table field in revision_tracker table is not long enough for table names #2331

jubjubinc opened this issue Aug 25, 2022 · 0 comments · Fixed by #2332
Labels
Bug: Accepted Bug has been confirmed, is reproducible, and ready to work on.

Comments

@jubjubinc
Copy link

We are using ExpressionEngine 6.3.5. PHP 7.4.30, MySQL 10.4.25-MariaDB

When turning on template revision tracking in template preferences and trying to save a template, we got the attached error. I looked at the database, and the item_table field in the database looks like it's set to 20 characters, but our table name is 31 characters long.

Let me know if you need any more info.
Screen Shot 2022-08-23 at 9 42 43 AM

@intoeetive intoeetive added the Bug: Accepted Bug has been confirmed, is reproducible, and ready to work on. label Aug 25, 2022
intoeetive added a commit that referenced this issue Aug 25, 2022
intoeetive added a commit that referenced this issue Aug 25, 2022
intoeetive added a commit that referenced this issue Sep 1, 2022
bryannielsen added a commit that referenced this issue Oct 24, 2022
…column-size

Resolved #2331 where saving template revision was causing SQL error when using long table prefix
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug: Accepted Bug has been confirmed, is reproducible, and ready to work on.
Projects
None yet
2 participants