PKP Bugzilla – Bug 8141
Psql error on PHP 5.3.8 running on SLES11-sp2
Last modified: 2014-08-06 05:57:35 PDT
When I install PHP Version: 5.3.8-0.39.1 on Linux SUSE Enterprise postgre gives this error when accessing the page:
DB Error: ERROR: value too long for type character varying(40)
And psql log adds this entry every time I try to access the page:
2013-02-14 11:20:58 BRST ojs ojs ERROR: value too long for type character varying(40)
2013-02-14 11:20:58 BRST ojs ojs STATEMENT: INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, acting_as)
( $1, $2, $3, $4, $5, $6, $7, $8)
I'm using ojs-2.3.8 with PHP version 5.2.14-0.7.30.46.1 on SUSE Linux Enterprise Server 11 (x86_64) VERSION = 11 PATCHLEVEL = 2 on Linux 3.0.51-0.7.9-default #1 SMP x86_64 GNU/Linux
I need to install >PHP5.3 because security updates.
This sounds like a setting change when you upgraded PHP, not a specific issue with OJS. Can you report on the differences between these two php.ini settings for your two PHP versions:
If your PHP 5.3 settings are different, try setting them to the same ones as your PHP 5.2 settings and see if the problem persists.
Closing for lack of response/lack of replication.