Bug #321

Lock table insert is mysql specific

Details

Submitted	2003-11-27 23:26 UTC
From	mark at mlstuff dot co dot uk
Assigned	datenpunk
Status	Closed
Package	DB_NestedSet
PHP Version	1.3.1
OS	Irrelevant
Roadmaps	(Not assigned)

Comments

[2003-11-27 23:26 UTC] mark at mlstuff dot co dot uk

Description:
------------
Line 2163 of NestedSet.php is a MySQL specific one. It should be more along the lines of:

$sql = sprintf('INSERT INTO %s (%s) VALUES (%s)', $this->lock_table, implode(', ', array('lockID', 'lockTable', 'lockStamp')), implode(', ', array($this->_quote($lockID), $this->_quote($this->node_table), time())));

[2003-11-27 23:28 UTC] mark at mlstuff dot co dot uk

Sorry, forgot to mention this is with NestedSet Version 1.3.1

[2004-07-23 21:45 UTC] dk at webcluster dot at

Don't have a clue where this bug report came from and why I have never seen it bevore. Maybe it's an old report from the php bug system(?)
Anyways - the problem addressed here should have been fixed with the last view versions.

Thank's for reporting and sorry for this delay.