View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 5439 | Composr | core | public | 2023-11-12 20:35 | 2023-11-21 03:10 |
| Reporter | PDStig | Assigned To | PDStig | ||
| Priority | normal | Severity | minor | ||
| Status | resolved | Resolution | fixed | ||
| Product Version | 10.0.43 | ||||
| Fixed in Version | 10.0.44 | ||||
| Summary | 5439: When content translation enabled, wiki+ tries to create fulltext index table multiple times | ||||
| 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& | ||||
| Tags | No tags attached. | ||||
| Attach Tags | |||||
| Attached Files | |||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
|
|
Automated response: Stray tables could cause installer errors 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. |
|
|
Fixed in git commit 91695c712b (https://gitlab.com/composr-foundation/composr/commit/91695c712b - link will become active once code pushed to GitLab) A hotfix (a TAR of files to upload) has been uploaded to this issue. These files are made to the latest intra-version state (i.e. may roll in earlier fixes too if made to the same files) - so only upload files newer than what you have already. If there are files in a hot-fix that you don't have then they probably relate to addons that you don't have installed and should be skipped. Always take backups of files you are replacing or keep a copy of the manual installer for your version, and only apply fixes you need. These hotfixes are not necessarily reliable or well supported. Not sure how to extract TAR files to your Windows computer? Try 7-zip (http://www.7-zip.org/). |
