We are moving to Git Issues for bug tracking in future releases. During transition, content will be in both tools. If you'd like to file a new bug, please create an issue.

Bug 8141 - Psql error on PHP 5.3.8 running on SLES11-sp2
Psql error on PHP 5.3.8 running on SLES11-sp2
Status: RESOLVED INVALID
Product: OJS
Classification: Unclassified
Component: Installer
To be determined
PC other
: P3 major
Assigned To: PKP Support
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-03-05 04:39 PST by Coelhu
Modified: 2014-08-06 05:57 PDT (History)
3 users (show)

See Also:
Version Reported In:
Also Affects:


Attachments

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
Comment 2 James MacGregor 2013-05-29 14:56:35 PDT
Closing for lack of response/lack of replication.