[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-bugs] [Bug 283] inability to have more than one person placing ord
From: |
bugzilla-daemon |
Subject: |
[Koha-bugs] [Bug 283] inability to have more than one person placing orders |
Date: |
19 Apr 2006 16:00:18 -0000 |
http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=283
address@hidden changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |address@hidden
Status|NEW |RESOLVED
Resolution| |FIXED
------- Comment #2 from address@hidden 2006-04-20 04:00 -------
I see Paul commited a fix on C4::Acquisitions::newbasket revision 1.2 on July
15, 2004 removing the FIXME warning there was a risk that two librarians would
have the same basket number (because the sub was selecting MAX() FROM aqbasket
without inserting any line). Now, we have a clean sub which insert a line in
aqbasket and a retrieval of the inserted basket number using
$dbh->{mysql_insertid}.
The problem with $dbh->{mysql_insertid} is that it is obviously DBMS dependent.
This is why DBI sub last_insert_id exists. There's a note in the Perl code
saying that $dbh->last_insert_id always returns null. I've tested
$dbh->last_insert_id(undef, undef, undef, undef) and it works fine for me with
DBI 1.48 (March 2005) and DBD::mysql 2.9007 (April 2005).
In my opinion, the only problem that remains is a dependance to MySQL. The bug
described above is fixed in rel_2_2 and current HEAD. I move the bug to
RESOLVED FIXED, and ask Paul to CLOSE the bug if he agrees with my explanation.
------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.