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

Hi Bernard

I think it was probably the result of a commit similar to this by Victor a week or three ago maybe?

    https://gitlab.com/tikiwiki/tiki/-/commit/88155f2e

I just tried my local trunk on mysql and out rebuilt fine and seems to work ok, and search seems to work fine... anyone else seeing this?

jonny



> On 16 Feb 2021, at 08:50, Bsfez Tiki via TikiWiki-devel <[email protected]> wrote:
> 
> 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



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