Several items in a relation field may lead to problem with indexing
- Status
- Closed
- Subject
- Several items in a relation field may lead to problem with indexing
- Version
- 22.x
- Category
- Conflict of two features (each works well independently)
- Error
- Feature
- Search
Trackers - Resolution status
- Fixed or Solved
- Submitted by
- Bernard Sfez / Tiki Specialist
- Lastmod by
- Bernard Sfez / Tiki Specialist
- Rating
- Description
In a Tiki22 I have 2 trackers (orders, payments) with relation fields.
They may be one order with several payments (recurrent, monthly payment).
I have actually 4 payments per orders and that’s work ok but on a specific case I have more payment and Tiki throw errors.Copy to clipboard× Error Indexing failed while processing "1268" (type trackeritem) with the error "Could not perform index modification: Data too long for column 'tracker_field_productsboughtPaymentId_text' at row 1" × Error Malformed search query: Could not perform index modification: Data too long for column 'tracker_field_productsboughtPaymentId_text' at row 1 × Error The search index could not be updated. The site is misconfigured. Contact an administrator. Could not perform index modification: Data too long for column 'tracker_field_productsboughtPaymentId_text' at row 1
By nature relation shouldn’t be limited and able to handle many items.
UPDATE
It is plaguing and changing behaviour of other components.
In the screenshot below you can see many counter (plugin list count template) displaying a 0 instead of the real value even if the list plugin is set with a different tracker. There is a big chance the index become corrupted or not completed so I escalated.The fields should be protected in a first place (avoiding using longer data than possible to use) and finally this field specific should be set to a relative high amount of data.
- Importance
- 9
- Easy to solve?
- 5
- Priority
- 45
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is currently unavailableUnable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
- Ticket ID
- 7644
- Created
- Tuesday 12 January, 2021 11:11:07 UTC
by Bernard Sfez / Tiki Specialist - LastModif
- Tuesday 06 December, 2022 13:28:19 UTC