Bug 8141 – Psql error on PHP 5.3.8 running on SLES11-sp2

Bug 8141 - Psql error on PHP 5.3.8 running on SLES11-sp2

Summary:

Psql error on PHP 5.3.8 running on SLES11-sp2

Status:	NEW

Product:	OJS
Classification:	Unclassified
Component:	Installer
Version:	To be determined
Platform:	PC other

Importance:	P3 major
Assigned To:	PKP Support

URL:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2013-03-05 04:39 PST by Coelhu
Modified:	2013-03-05 05:34 PST (History)
CC List:	1 user (show)

See Also:
Version Reported In:
Also Affects:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

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