Problem reindexing OJS 3.3.0-13

Software Support
1

Hi all,

I have a problem trying to reindex (php tools/rebuildSearchIndex.php) in a OJS v. 3.3.0-13 portal, it fails at the second journal with the following error.

PHP Fatal error: Uncaught PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘keyword_text’ at row 1 in /var/www/sitio33/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115
Stack trace:
#0 /var/www/sitio33/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)
#1 /var/www/sitio33/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(489): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/sitio33/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(‘INSERT INTO sub…’, Array)
#3 /var/www/sitio33/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback(‘INSERT INTO sub…’, Array, Object(Closure))
#4 /var/www/sitio33/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(496): Illuminate\Database\ in /var/www/sitio33/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671

What should I look for in order to fix this? what is the length limit? thanks in advance

2

Hi @lcmartinezru,

I’m surprised we’ve never seen this before! I suspect you’re using PostgreSQL? I’ll bet MySQL automatically truncates the column, and PostgreSQL reports an error.

I’ve filed this at Submission keywords not truncated to column length during indexing · Issue #8693 · pkp/pkp-lib · GitHub; watch there for a fix.

Regards,
Alec Smecher
Public Knowledge Project Team