search

opencats / OpenCATS

Applicant Tracking System (maintained code base)
http://www.opencats.org
Other
472 stars 236 forks source link

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

Closed zoomiest2 closed 10 months ago

zoomiest2 commented 12 months ago

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 commented 12 months ago

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 commented 12 months ago

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