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

Hello,

Confirming the issue(s)…

During some works on a new Tiki22 on my local I had some errors that confirm one of the issues.
In case the 2 errors (while related) have not the same cause I split in 2 tickets

https://dev.tiki.org/item7677-Random-index-error-on-tiki-tracker-built-in-fields
https://dev.tiki.org/item7694-Field-lastModif-does-not-exist-in-the-current-index-error

I found  workaround for the second one, more detail on the tickets themselfves.

B

> On 17 Feb 2021, at 09:29 , Bsfez Tiki <[email protected]> wrote:
> 
> 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