Bug 8141

Summary: Psql error on PHP 5.3.8 running on SLES11-sp2
Product: OJS Reporter: Coelhu <coelhu>
Component: InstallerAssignee: PKP Support <pkp-support>
Status: RESOLVED INVALID    
Severity: major CC: jason.nugent, jeferod83, jmacgreg
Priority: P3    
Version: To be determined   
Hardware: PC   
OS: other   
Version Reported In: Also Affects:

Description Coelhu 2013-03-05 04:39:32 PST
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)
VALUES
( $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.

Thanks
Comment 1 Jason Nugent 2013-03-05 05:34:38 PST
Hi Coelhu,

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:

session.hash_function
session.hash_bits_per_character

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.

Regards,
Jason
Comment 2 James MacGregor 2013-05-29 14:56:35 PDT
Closing for lack of response/lack of replication.