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

Bug: Troublesome space in contact table index name! Please remove... #625

Closed
zoomiest2 opened this issue Jul 12, 2023 · 2 comments
Closed

Comments

@zoomiest2
Copy link

I installed a fresh copy of OpenCATS, and carefully moved my data over to it.
While I was linking my tables to an Access database for querying, the ODBC connection rejected the Contacts table because of the index on the Title field. Here is the picture (https://vulcanovo.com/IDX-Error.png). Can you see the indent on the 6th row? Someone created a space in the name. How do I fix this on my copy?

I try to rename it, but "it's not found by the same name" because of the space. I can't get my hands on this index to remove or modify it.

@zoomiest2
Copy link
Author

I finally figured it out. You must use back-ticks to represent the space.

MariaDB [opencats]> ALTER TABLE contact DROP INDEX ` IDX_title`;
Query OK, 8634 rows affected (0.149 sec)               
Records: 8634  Duplicates: 0  Warnings: 0

Please remove that space from the source code. Thank you!

`

@zoomiest2 zoomiest2 reopened this Jul 12, 2023
@zoomiest2
Copy link
Author

Sorry. Didn't mean to close this issue, until the source has been fixed.

@zoomiest2 zoomiest2 changed the title Bug: Space in contact table index name! Please remove... (how do I rename my index?) Bug: Troublesome space in contact table index name! Please remove... Jul 13, 2023
Bloafer added a commit that referenced this issue Aug 30, 2023
@RussH RussH closed this as completed in 19f1fcd Aug 30, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant