From: godwizard at hotmail dot com
Operating system: Linux Fedora Core 2
PHP version: 5.0.3
PHP Bug Type: MySQL related
Bug description: mysql_insert_id() return wrong ID
Description:
------------
mysql_insert_id return wrong ID. It will add new line to DB correctly but
when using mysql_insert_id to get auto_increment value, it will return
something odd.
Reproduce code:
---------------
function add_line()
{
global $db_insert;
$aikaleima = time();
if ( (isset($_SESSION['admin']['rekisteriID'])) &&
(strlen($_SESSION['admin']['rekisteriID']) > 0) )
{
$query = sprintf("
insert into rekisteri_rekisteriID (rekisteriID, oletus, lisatty, lisaaja)
values (%s, 1, %u, %u)",
sql_valid($_SESSION['admin']['rekisteriID']),
sql_valid($aikaleima),
sql_valid($_SESSION['user']['userID']));
if ( (isset($db_insert)) && (isset($query)) )
{
$result = $db_insert->query($query);
unset($query);
}
if ( (isset($result)) && (mysql_affected_rows() > 0) )
{
$rekisterinro = mysql_insert_id();
}
....
Expected result:
----------------
Example value should be 29171.
Actual result:
--------------
Value is 7618. And ID 7618 is already reserved in DB.
--
Edit bug report at http://bugs.php.net/?id=31728&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31728&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=31728&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=31728&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=31728&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=31728&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=31728&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=31728&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=31728&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=31728&r=support
Expected behavior: http://bugs.php.net/fix.php?id=31728&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=31728&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=31728&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=31728&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31728&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=31728&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=31728&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=31728&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=31728&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=31728&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=31728&r=mysqlcfg
