installation crashes on unserialize()

mkfl0r

Hi,

I receive following error during first run after installation:

Type: 8

Message: unserialize() [<a href='function.unserialize'>function.unserialize</a>]: Error at offset 0 of 63 bytes

File: /usr/local/www/data/epesi/include/session.php

Line=51

error backtrace:

[PHP core called function]

    function called: handle_epesi_error(8, "unserialize() [function.unserialize]: Error at offset 0 of 63 bytes", "/usr/local/www/data/epesi/include/session.php", 51, Array ("o8ike91a5lii2ohcnq2k7kaeu3", "a3a313a7b733a31343a226e756d5f6f665f636c69656e7473223b693a313b7d"))

File: /usr/local/www/data/epesi/include/session.php

    line 51

    function called: unserialize("a3a313a7b733a31343a226e756d5f6f665f636c69656e7473223b693a313b7d")

[PHP core called function]

    function called: read("o8ike91a5lii2ohcnq2k7kaeu3")

File: /usr/local/www/data/epesi/include/session.php

    line 186

    function called: session_start()

File: /usr/local/www/data/epesi/include.php

    line 24

    function called: require_once("/usr/local/www/data/epesi/include/session.php")

File: /usr/local/www/data/epesi/process.php

    line 21

    function called: require_once("/usr/local/www/data/epesi/include.php")

content of the sessions table is following:

 

select * from session;

            name            |  expires   |                                data

----------------------------+------------+--------------------------------------------------------------------

 o8ike91a5lii2ohcnq2k7kaeu3 | 1308919532 | \x613a313a7b733a31343a226e756d5f6f665f636c69656e7473223b693a313b7d

the system is Freebsd 8.1 with php 5.3.5, apache 1.3.42 + postgresql

extensions.ini is following:

extension=pgsql.so

extension=curl.so

extension=gd.so

extension=zlib.so

extension=xml.so

extension=session.so

any help would be appreciated,

best,
Maciej

mkfl0r

To be more precise:

initial content of session table:



select * from session;

 name | expires | data

------+---------+------

(0 rows)

When I reload index.php error occurs:

Type: 8

Message: unserialize(): Error at offset 0 of 63 bytes

File: /usr/local/www/data/epesi/include/session.php

Line=51

error backtrace:

[PHP core called function]

    function called: handle_epesi_error(8, "unserialize(): Error at offset 0 of 63 bytes", "/usr/local/www/data/epesi/include/session.php", 51, Array ("o8ike91a5lii2ohcnq2k7kaeu3", "a3a313a7b733a31343a226e756d5f6f665f636c69656e7473223b693a313b7d"))

File: /usr/local/www/data/epesi/include/session.php

    line 51

    function called: unserialize("a3a313a7b733a31343a226e756d5f6f665f636c69656e7473223b693a313b7d")

[PHP core called function]

    function called: read("o8ike91a5lii2ohcnq2k7kaeu3")

File: /usr/local/www/data/epesi/include/session.php

    line 186

    function called: session_start()

File: /usr/local/www/data/epesi/include.php

    line 24

    function called: require_once("/usr/local/www/data/epesi/include/session.php")

File: /usr/local/www/data/epesi/process.php

    line 21

    function called: require_once("/usr/local/www/data/epesi/include.php")

and session table looks like that:

select * from session;

            name            |  expires   |                                data

----------------------------+------------+--------------------------------------------------------------------

 o8ike91a5lii2ohcnq2k7kaeu3 | 1308921753 | \x613a313a7b733a31343a226e756d5f6f665f636c69656e7473223b693a313b7d

(1 row)

when I try to reload the page output stays blank. in order to reproduce the error I need to clear the sessions table (or let the session expire).

HTH

shacky

Sorry, but for now, newest version of epesi just doesn't work with postgresql... But we are working on it to make it available again with upgoing release.

Cheers,
Paweł

ethnar

As Pawel wrote - we're working on having epesi working on postgres.

However, the particular problem you've encountered will most likely require change in postgres config anyway. In postgresql.conf find the line

;bytea_output = 'hex'

Un-comment it and change value to escape:

bytea_output = 'escape'

This should solve this particular problem with session in epesi in Postgre 9.x. Please write back if it's working for you.

Hope this helps,
Arek

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge