DB column "oc_queuedtasks.parameters" is too short

[butonic]

Issue by noldor from Friday Nov 08, 2013 at 13:38 GMT
Originally opened as owncloud-archive/apps#1468

---

DB column "oc_queuedtasks.parameters" is too short.

this column is VERCHAR(256) on mysql. OCA\Search_Lucene\Hook::indexFile() save file path to this column with json_encode(),
but json string is shorten when file path is too long.

probably, cannot insert on other DB.

owncloud.log

 {"app":"search_lucene","message":"missing path parameter","level":2,"time":"2013-11-05T01:47:46+00:00"}

I can't find where "oc_queuedtasks.parameters" defined. so I use SQL like this

ALTER TABLE oc_queuedtasks MODIFY COLUMN parameters longtext NOT NULL

Steps to reproduce

1. make file, path length over 256 chars.

Server configuration

Operating system: CentOS 6.4

Web server: apache 2.2.15

Database: MySQL 5.1.69

PHP version: 5.3.3

ownCloud version: 5.0.12

Logs

ownCloud log (data/owncloud.log)

 {"app":"search_lucene","message":"missing path parameter","level":2,"time":"2013-11-05T01:47:46+00:00"}

[butonic]

Comment by karlitschek from Friday Nov 08, 2013 at 15:57 GMT

---

@butonic

[butonic]

@noldor Beware, this is bleeding edge code! Could you try replacing the contents of your search_lucene folder with this zip: https://github.com/owncloud/search_lucene/archive/search_lucene_refactoring.zip

It changes the way background jobs are used. Let me know if that solves the error and still works as expected.