...I tested out with mysql client and standard call, and it worked perfectly:
mysql> create database dropme; Query OK, 1 row affected (0.02 sec) mysql> \u dropme Database changed mysql> CREATE TABLE `care_person` ( `pid` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(60) NOT NULL, PRIMARY KEY (`pid`) ) ENGINE=InnoDB AUTO_INCREMENT=10000001 DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.06 sec) mysql> insert into care_person (name) VALUES ('Donald'); Query OK, 1 row affected (0.00 sec) mysql> SELECT LAST_INSERT_ID(); +------------------+ | LAST_INSERT_ID() | +------------------+ | 10000001 | +------------------+ 1 row in set (0.00 sec) That would mean as logic consequence: MySQL does not have that issue on my ubuntu here. But the behaviour of adodb method Insert_ID() had reproducibly that issue on the same ubuntu. Is there any reason not to try with latest adbodb layer if that strange behaviour could be covered with it? Robert Am Mittwoch, den 29.09.2010, 11:20 +0200 schrieb Gjergj Sheldija: > hi muthu, > > if you read the comments of fucntion Insert_ID() in file > adodb.in.php > > it writes > /** > * @param $table string name of the table, not needed by all > databases (eg. mysql), default '' > * @param $column string name of the column, not needed by all > databases (eg. mysql), default '' > * @return the last inserted ID. Not all databases support this. > */ > > gj. > > > > On 2010-09-29 11:02.PD, Ap.Muthu wrote: > > The current ADOdb library is v5.11 on Care2x SVN trunk. > > It was v5.10 till about 2 to 3 weeks ago. > > > > When a record is inserted into a table, we use ADOdb's method > > $db->Insert_ID() to get us the last inserted ID where $db is the ADOdb > > connection object. > > The definition of the said method is in classes/adodb/adodb.inc.php files > > and is used within ADOdb in two files:- > > adodb-csvlib.inc.php - Line 44: $sql .= ','.$conn->Insert_ID(); > > adodb-perf.inc.php (for logging) - Line 107: $conn->lastInsID = > > @$conn->Insert_ID(); > > > > The specific MySQL driver we are using here is > > /calsses/adodb/drivers/adodb-mysq.inc.php > > The said driver has a class "mysql" that extends the base cass > > "ADOConnection" > > It has the class variable: var $hasInsertID = true; > > It also has a class method: _insertid() > > This method returns the last insert id and may possibly be for private use. > > > > The default class variables values in the base class ADOConnection are: > > var $lastInsID = false; > > var $hasInsertID = false; /// supports autoincrement ID? > > The latter is however overridden by a re-assignment in the mysql class. > > > > The class method ADOConnection::Insert_ID() is: > > > > function Insert_ID($table='',$column='') > > { > > if ($this->_logsql&& $this->lastInsID) return $this->lastInsID; > > if ($this->hasInsertID) return $this->_insertid($table,$column); > > if ($this->debug) { > > ADOConnection::outp( '<p>Insert_ID error</p>'); > > adodb_backtrace(); > > } > > return false; > > } > > > > > From the above it is clear that for the _insertid() to work, it should > > > have the table name and column name provided otherwise we have to check > > > out what defaults it will take. > > > > > > Regards, > > Ap.Muthu > > > > > > > > > > ------------------------------------------------------------------------------ > > Start uncovering the many advantages of virtual appliances > > and start using them to simplify application deployment and > > accelerate your shift to cloud computing. > > http://p.sf.net/sfu/novell-sfdev2dev > > > > > > _______________________________________________ > > Care2002-developers mailing list > > Care2002-developers@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers -- -- -------------------------------------------- CARE2X - free Integ Hospital Info System https://sourceforge.net/projects/care2002/ http://www.care2x.org ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers