Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 312737 - dev-php/PEAR-MDB2_Driver_mysqli fails INSERTS with php 5.3
Summary: dev-php/PEAR-MDB2_Driver_mysqli fails INSERTS with php 5.3
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: High normal (vote)
Assignee: PHP Bugs
URL: http://pear.php.net/package/MDB2_Driv...
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-04-02 00:17 UTC by Travis Hansen
Modified: 2010-09-11 14:28 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments
makes things work for me (mysqli-parameters-reference.patch,1.01 KB, patch)
2010-04-02 00:18 UTC, Travis Hansen
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Travis Hansen 2010-04-02 00:17:30 UTC
I'm using dev-php/PEAR-MDB2_Driver_mysqli-1.5.0_beta2

Here is an example the error I get...

DBMS/Debug Message: _execute: [Error message: Unable to execute statement] [Last executed query: INSERT INTO logins (failed_password, failed_username, ip, success, user_id, created) VALUES (?, ?, ?, ?, ?, ?)] [Native code: 0] 

This issue is manifest on other platforms (OSX) etc with 5.3 so it's certainly a non gentoo-specific issue.
With the plain mysql driver everything seems ok.

Reproducible: Always
Comment 1 Travis Hansen 2010-04-02 00:18:35 UTC
Created attachment 226203 [details, diff]
makes things work for me

This is the hack I applied to get it to actually work correctly.
Comment 2 Matti Bickel (RETIRED) gentoo-dev 2010-06-13 18:09:10 UTC
Upstream says trunk is php-5.3 compatible. So if you can, please try that one. I've found rumors of a release, but nothing has materialized yet. If current MDB2 SVN fixes the issue, we might roll a SVN snapshot.
Comment 3 Travis Hansen 2010-06-15 05:23:17 UTC
OK, I just tested trunk

http://svn.php.net/repository/pear/packages/MDB2/trunk

So I'm using the full MDB2 stack and not just the driver and it seems to work nicely.  It also gets rid of all those "Unknown: Assigning the return value of new by reference is deprecated" errors.

From http://stackoverflow.com/questions/1530112/replacement-for-pear-mdb2-on-php-5-3

"please check out a copy of MDB2 from SVN, it's fully PHP5.3 compatible, with many performance improvements. I'm currently waiting for some fixes to the new SQL Server driver (Microsoft is working on it this very week), then I'll push a new stable release."

I'm not sure if you want to wait for a full MDB2 release or just apply the above patch for now.  I'd probably be a little leary of including the new driver without the updated stack as well.  I didn't test that however.
Comment 4 Matti Bickel (RETIRED) gentoo-dev 2010-06-18 22:17:37 UTC
That particular stackoverflow url was what i was referring to with "rumors". I'm not sure about the amount of work involved in rolling a complete snapshot. But I'll look into it.
Comment 5 Travis Hansen 2010-08-31 19:50:31 UTC
OK, beta3 is out

http://pear.php.net/package/MDB2/redirected

Let's get MDB2 beta3 with the relevant beta3 drivers into portage and hopefully this will all go away :)
Comment 6 Travis Hansen 2010-08-31 19:52:02 UTC
Oh, and it looks like beta3 depends on 5.3.0.
Comment 7 Matti Bickel (RETIRED) gentoo-dev 2010-09-11 14:28:16 UTC
I've updated MDB2 to 2.5.0_beta3. Be aware that you need pear-1.9.1 and php-5.3 to use it!