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

Incorrect lengths in emails_text vardefs #10443

Open
ojs87 opened this issue Jun 11, 2024 · 0 comments
Open

Incorrect lengths in emails_text vardefs #10443

ojs87 opened this issue Jun 11, 2024 · 0 comments
Labels
Area: Emails Issues & PRs related to all things regarding emails & email module Priority:Important Issues & PRs that are important; broken functions, errors - there are workarounds Severity: Moderate Key function failed, but no or little impact Status:Fix Proposed A issue that has a PR related to it that provides a possible resolution Type: Bug Bugs within the core SuiteCRM codebase

Comments

@ojs87
Copy link
Contributor

ojs87 commented Jun 11, 2024

Issue

The fromaddr and reply_to_addr fields in emails_text vardefs are set to 250 when they should be 255. This has caused an issue where repair and rebuild keeps trying to recreate the index on the fromaddr field in some situations

Possible Fix

update emails_beansMetaData.php to fix length on these 2 fields

Steps to Reproduce the Issue

Example of repair and rebuild message.

/* Table : emails_text */
/*COLUMNS*/
/* INDEXES */
/*INDEX MISMATCH WITH DATABASE - emails_textfromaddr -  ROW <name> emails_textfromaddr <type> index <fields>[0] => 'from_addr (250)'  */
/* VARDEF - emails_textfromaddr -  ROW<name> emails_textfromaddr <type> index <fields>[0] => 'from_addr'  */
ALTER TABLE emails_text   DROP INDEX emails_textfromaddr,  ADD INDEX emails_textfromaddr (from_addr);

Context

This looks to have been unintentionally changed in a previous MR:
#7798

Version

7.14.3

What browser are you currently using?

Chrome

Browser Version

Firefox v126.0

Environment Information

Mariadb 10.5.6, PHP74

Operating System and Version

Ubuntu 22.04.4 LTS

@ojs87 ojs87 added the Type: Bug Bugs within the core SuiteCRM codebase label Jun 11, 2024
ojs87 added a commit to ojs87/SuiteCRM that referenced this issue Jun 11, 2024
@johnM2401 johnM2401 added Status:Fix Proposed A issue that has a PR related to it that provides a possible resolution Priority:Important Issues & PRs that are important; broken functions, errors - there are workarounds Area: Emails Issues & PRs related to all things regarding emails & email module Severity: Moderate Key function failed, but no or little impact labels Jun 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Area: Emails Issues & PRs related to all things regarding emails & email module Priority:Important Issues & PRs that are important; broken functions, errors - there are workarounds Severity: Moderate Key function failed, but no or little impact Status:Fix Proposed A issue that has a PR related to it that provides a possible resolution Type: Bug Bugs within the core SuiteCRM codebase
Projects
None yet
Development

No branches or pull requests

2 participants