[#9601] - PDO insertid does not return last inserted row id
- Closed
- 26 Mar 2016
- Medium
- Build: staging
- # 9601
- Diff
- chrisdavenport:patch-3
- Failure continuous-integration/travis-ci/pr The Travis CI build failed Details
- Pending JTracker/HumanTestResults Human Test Results: 1 Successful 0 Failed. Details
User tests: Successful: Unsuccessful:
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Labels |
Added:
?
|
||
That works for PDO MySQL, but other PDO connections will fail. The unit tests fail here because the function doesn't exist on SQLite (which is the engine most of the unit tests are running off of).
I had a feeling something like that might be the case. Looks like the problem is in PDO itself and may not be fixable in Joomla without some hacky workarounds.
Can we not just put this in the PDOMySQL driver file then Chris?
| Milestone |
Added: |
||
I didn't know that file even existed! I've never used PDO before. It looks like it will need specific fixes for MSSQL and possibly others too, which surely defeats the object of using PDO in the first place.
| Category | ⇒ | Libraries |
I have tested this item 
successfully on 78c57c9
it also fixes #9572
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/9601.
Are we sure this isn't either a PHP bug or a Joomla implementation bug? Seems odd that a method in a PHP extension would fail so catastrophically.
| Status | Pending | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-03-26 17:14:50 |
| Closed_By | ⇒ | chrisdavenport |
can someone please remove the wrong milestone here? @brianteeman @wilsonge @mbabker
| Milestone |
Removed: |
||
done - thanks :)
Can you write some test instructions please.