Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Submission keywords not truncated to column length during indexing #8693

Closed
asmecher opened this issue Feb 24, 2023 · 1 comment
Closed

Submission keywords not truncated to column length during indexing #8693

asmecher opened this issue Feb 24, 2023 · 1 comment
Assignees
Labels
Bug:1:Low A bug that does not have a severe consequence or affects a small number of users.
Milestone

Comments

@asmecher
Copy link
Member

See https://forum.pkp.sfu.ca/t/problem-reindexing-ojs-3-3-0-13/76274:

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

@asmecher asmecher added the Bug:1:Low A bug that does not have a severe consequence or affects a small number of users. label Feb 24, 2023
@asmecher asmecher added this to the 3.3.0-15 milestone Feb 24, 2023
@asmecher
Copy link
Member Author

OJS/OMP/OPS 3.3.0-14 and prior can apply 1824f2d in lib/pkp to resolve this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug:1:Low A bug that does not have a severe consequence or affects a small number of users.
Projects
None yet
Development

No branches or pull requests

2 participants