Creecros's Filter Pack troubleshootings

Plugins
1

Hi,

:white_check_mark: WORKS
:x: SQL ERROR
Internal Error: SQL Error: SQLSTATE[HY000]: General error: 1 too many SQL variables

:x: Use subtask:status:DONE or subtask:status:2 to filter for subtasks that are DONE
:white_check_mark: Use subtask:status:TODO or subtask:status:0 to filter for subtasks that are TODO
:x: Use subtask:status:INPROGRESS or subtask:status:1 to filter for subtasks that are INPROGRESS
:x: Use subtask:status:RUNNING to filter for subtasks that are RUNNING, regardless of STATUS

Kanboard 1.2.10

2

Need more info. Like your configuration. Also, try here: https://projects.nachostudio.ml/
admin/admin

Do you get same errors? Sorry, traveling at the moment.

Also, is this related: https://github.com/kanboard/kanboard/issues/3280

3

It doesn’t work at all. No result with any type of search but no SQL error.

4

Probably because you need to install the plugin on that server. You have my permission.

5

I installed the plugin via the UI and yes, everything works perfectly on your test server.

6

So, lets see if we can duplicate your conditions, i.e. how many tasks do you approx. have on your board, closed and opened? Then see if we can get the issue.

Also, what is your Database Version?

Configuration

Application version: v1.2.10
PHP version: 7.3.6
PHP SAPI: fpm-fcgi
HTTP Client: cURL
OS version: Linux 4.9.45-rancher
Database driver: sqlite
Database version: 3.28.0
Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.100 Safari/537.36
7

Around 80 tasks for one board, but the number seems to have no incidence because I have the same issues on other bords that have far less tasks.

57
Capture d’écran 2019-08-24 à 22.04.57.png1099×256 16.8 KB

8

That db version is 4 years old. Could you upgrade that? I bet it would solve your issue.

9

Is there any risk when upgrading a database ?

10

Finaly, I can not do it. I need Private SQL to have the right to do that king of manipulations on my hosting. Which is not the case unfortunately.

11

Upgrading the SQLite is recommended but this error can be “workarounded” at application level by changing the in (?, ?, ?, ?, ?...) queries to in (select ... ) like I did on https://github.com/kanboard/kanboard/pull/4264/files

12

That’s a lot of core files to change. I will need do redo all theses changes with a future release?

13

No, the plugin can be upgraded.
I’ll check this plugin when I have some spare time and if everything works I’ll create a pull request there

1 Like