Re: [Tiki-devel] New (never seen it) error after a fresh Tiki22.x update

I can confirm now a nasty regression introduced in Tiki22.x at some point. (between 2 month ago and now)

It broke filters (item link and item list) and display a lot of messages about fields and index (including Tiki fields like lastmodif)

It may be related of tracker field "real" life as I saw the BLOB/TEXT error on a field that was added at some point and not all the items have been saved with it (math field).
(console.php recalc doesn’t seems to be in Tiki22)



I could catch this on my wife daily used Tiki.

LUCKILY I had my own branches for this project and everything was on Gitlab.
I updated a few days ago this project creating a merge request (from Tiki:22.x to my project).
I could revert the merge and now things are working back to normal.

As I have a living example, I can grant access on the project to experts that want to investigate.

As long as this is not fixed it is clearly an upgrade blocker for me.

Regards,
Bernard

PS: A very good argument to use Git ! 😉




> On 15 Feb 2021, at 13:55 , Bsfez Tiki via TikiWiki-devel <[email protected]> wrote:
> 
> Hello,
> 
> I just update a daily used Tiki22.x and I see a new error (I didn’t have before nor ever seen)
> 
> Malformed search query: Could not perform index modification: BLOB/TEXT column 'tracker_field_productsboughtKindOfProduct_text' used in key specification without a key length
> 
> I have checked the log of the index:rebuilt (I always use —log) and there is no error or warning.
> 
> This is an itemLink field.
> 
> It is used as filter in a plugin List
> {filter field="tracker_field_productsboughtKindOfProduct_text" exact="Holidays"}
> 
> Is it something I should fix on the MYSQL table or a bug that requires a fix ? (and a ticket)
> 
> B
> 
> <Screen Shot 2021-02-15 at 13.48.02 .png>
> _______________________________________________
> TikiWiki-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel



_______________________________________________
TikiWiki-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel