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

Hello Jonny,

On my local (OSX / MAMP / PHP7.4.9) I didn't have the issue.
On my server (Debian10 / mariaDB / Virtualmin / PHP7.4.14 / FCGId) I have the issue.

Both use mySQL search.

In a few days (parents are registering for holidays camps just now ;-) ) I can update again and give you access (same server we played with and you show me many useful things about Virtualmin and Kibana)


Bernard

> On 16 Feb 2021, at 19:09 , Jonny Bradley via TikiWiki-devel <[email protected]> wrote:
> 
> 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



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