CoreCommunity ExtensionsIncubatorDistributionsTYPO3 4.5 ProjectsTYPO3 4.6 ProjectsTYPO3 4.7 ProjectsTYPO3 6.0 ProjectsTYPO3 6.1 ProjectsTYPO3 6.2 Projects (+)

Bug #34987

wrong sql where in chooseBestIndex

Added by Krystian Szymukowicz about 1 year ago. Updated 12 months ago.

Status:Resolved Start date:2012-03-18
Priority:Should have Due date:
Assignee:Stefan Froemken % Done:

100%
Category:-
Target version:-
Votes: 0

Description

hi

I am gettting wrong mysql where in function chooseBestIndex.

The problem is probably missing "1=1" in where.
After applying the patch there is no sql errors.

wrong_sql_where_in_chooseBestIndex.patch (10.1 kB) Krystian Szymukowicz, 2012-03-18 22:04

ke_search__1.png (27.4 kB) Krystian Szymukowicz, 2012-03-28 10:52

ke_search__2.png (24.8 kB) Krystian Szymukowicz, 2012-03-28 10:52

History

#1
Updated by Krystian Szymukowicz about 1 year ago

I forgot to add that this bug is in forge version of the ext and the patch is against forge.

#2
Updated by Christian Buelter about 1 year ago

  • Status changed from New to Needs Feedback

By reading your patch makes sense.

But I wonder why we don't have errors in our installations of ke_search.

Could you provide a test case?

#3
Updated by Krystian Szymukowicz about 1 year ago

I'am getting this error when using checkboxes.

The query builded is:
SELECT COUNT FROM tx_kesearch_index WHERE AND MATCH (tags) AGAINST (' \"#2012#\"' IN BOOLEAN MODE)

#4
Updated by Christian Buelter about 1 year ago

I still can't reproduce the error.

Do you have other filters than the checkbox filter in use?

Do you use it AJAX or static mode?

#5
Updated by Krystian Szymukowicz about 1 year ago

I use static and there is only one filter.
In the attachment the options.

#6
Updated by www.kennziffer.com GmbH about 1 year ago

Hmm, I still cannot reproduce it. On my test environment with a default installation of ke_search I don't get any errors, even with only one filter configured (checkbox filter).

I saw that you are using a custom template. Does the error still appear with the default template?

Did you try the current trunk version? We made some changes during the last days in preparation of version 1.0 which has been released today.

#7
Updated by Krystian Szymukowicz about 1 year ago

I installed 1.0 from TER and still have this error.

#8
Updated by Stefan Froemken 12 months ago

  • Status changed from Needs Feedback to Resolved
  • Assignee set to Stefan Froemken
  • % Done changed from 0 to 100

I have solved this issue just 2 weeks ago, so with current version in SVN it should be fixed.

Stefan

Also available in: Atom PDF