#5439 - When content translation enabled, wiki+ tries to create fulltext index table multiple times
-
By PDStig
- Added
- 2 views
| Identifier | #5439 |
|---|---|
| Issue type | Minor issue (breaks specific functionality) |
| Title | When content translation enabled, wiki+ tries to create fulltext index table multiple times |
| Status | Completed |
| Handling member | PDStig |
| Version | 10.0.43 |
| Addon | core |
| Description | Unfortunately a query has failed [CREATE TABLE cmsm_ce_fulltext_index ( i_catalogue_entry_id integer NOT NULL, i_lang varchar(5) NOT NULL, i_ngram integer NOT NULL, i_ac integer NOT NULL, i_occurrence_rate real NOT NULL, i_add_time integer unsigned NOT NULL, i_c_name varchar(80) NOT NULL, i_category_id integer NOT NULL, i_submitter integer NOT NULL, PRIMARY KEY (i_catalogue_entry_id, i_lang, i_ngram, i_ac) ) CHARACTER SET=utf8mb4 engine=MyISAM] [Table 'cmsm_ce_fulltext_index' already exists] (version: 10.0.43, PHP version: 7.4.33, URL: /composr/cms/cms-wiki/_edit_tree/wiki.htm?redirect=http%3A%3Aslash%3A%3Aslash%3Alocalhost%3Aslash%3Acomposr%3Aslash%3Awiki.htm%3Fkeep_devtest%3D1& |
| Steps to reproduce | |
| Funded? | No |
| Commits |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments
Stray tables in an old Composr install could carry over to a new Composr install. Since these stray tables are not in db_meta, table_exists may return false even if the table exists. And when the addon / hook tries to create the table, an error occurs. This fix implements table erasing in the install. When overwriting an existing Composr install, the installer will delete every table indicated in db_meta to reduce stray tables existing.