RE: [PEAR] Problem with PEAR::MDB
| From: | Lukas Smith | Date: | Tue, 17 Jun 2003 10:01:10 +0000 |
| Subject: | RE: [PEAR] Problem with PEAR::MDB | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-6033@lists.php.net to get a copy of this message | ||
> From: Xavier Sosnowska [mailto:xso@ifrance.com]
> Sent: Monday, June 16, 2003 6:16 PM
> To: pear-general@lists.php.net
> Subject: RE: [PEAR] Problem with PEAR::MDB
>
> Hi Lukas,
>
> Thanks for your quick reaction.
>
> > $success->getUserinfo() to get more details on the error.
>
> I tried to use getUserinfo() but the error message looks empty:
> MDB Error: MDB_manager schema parse error
> Parser error: ""
Hmm ..
I have cut and pasted your xml schema and code and added the out put of
getUserinfo() and I got this:
CREATE TABLE glo_session (ses_id CHAR (32) DEFAULT
'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' NOT NULL,ses_expire INT DEFAULT
00000000000 NOT NULL,ses_value TEXT DEFAULT 'xxxxxxx' NOT NULL)
[nativecode = BLOB column 'ses_value' can't have a default value]
So I don't really know where that parse error comes from.
Blindly assuming you are using MySQL ..
It seems like MySQL doesn't like a default value here:
"BLOB and TEXT columns cannot have DEFAULT values."
So if you don't specify a length for the ses_value field you will have
to remove the default value. This will need to be documented.
Thx,
Lukas