-
Notifications
You must be signed in to change notification settings - Fork 790
Closed
Milestone
Description
Describe the bug
After creating a link with a hyphen in the middle table name, EspoCRM can no longer rebuild the database
The App log contains the messages:
Error while rebuilding database. See log file for details.
and
Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-_mytablename (id BIGINT AUTO_INCREMENT NOT NULL, account_id VARCHAR(17) CHARACTE' at line 1
The error can be fixed by removing the relation.
To Reproduce (MANDATORY, DO NOT REMOVE)
Explicit steps to reproduce the behavior:
- Create a many-to-many link.
- Overwrite the "Middle Table Name" with a string containing a hyphen
Expected behavior
The table name gets rejected or actually works.
EspoCRM version
9.1.8
o-data
Metadata
Metadata
Assignees
Labels
No labels