Tickets :: Comment on [#44] Postgres Session Serialization strips char

* Your Email Address
* Spam protection	Enter the letters below: . ..___.._. __. __ \|\ \| _/ \| (__ / ` \| \\|./__._\|_.__)\__.
Comment	> I will describe symptoms, cause and fix (at least for my system): > > > > Symptoms: > > > > Some links (the Password link for instance) don't work: you are > redirected back to /imp/mailbox.php. (After debugging I found that > Auth::getAuth() didn't work > > after the first time) > > > > > > CAUSE > > > > horde/lib/SQL.php, line 64, strips the first two chars of the value > of the session_data column (horde_sessionhandler table). > > > > This only occurs when you use pgsql as dbsyntax (line 63: case 'pgsql': ). > > This is strange since the store-code does not prepend any characters. > This seems to be a hack circumventing some problem (hard to believe > it is a deliberate bug!). > > > > B.t.w., we use PostgreSQL 7.4.1, and the table looks like: > > > > horde=# \d horde_sessionhandler > > Table "public.horde_sessionhandler" > > Column \| Type \| Modifiers > > ----------------------+-----------------------+----------- > > session_id \| character varying(32) \| not null > > session_lastmodified \| integer \| not null > > session_data \| bytea \| > > > > > > ** FIX: > > > > replace > > $data = substr($result, 2); > > by > > $data = $result; > > > > > > > > Greetings, > > > > Kenney Westerhof
Attachment
Watch this ticket