Description: ------------ The SQL Statement generated at NestedSet.php line 2316 is not useable at other SQLSservers that mysql. generated Statement: INSERT INTO tbl_lock SET lockID='lck-4035ed80db9a2', lockTable='tbl_tree', lockStamp=1077276063 The correct Statement should look like this INSERT INTO tbl_lock (lockID, lockTable, lockStamp) VALUES('lck-4035ed80db9a2','tbl_tree', 1077276063); PHP 4.3.4 PEAR::DB_NestedSet 1.3.2 PEAR::DB 1.6.0 Reproduce code: --------------- $NeSe->setAttr(array('node_table'=>'tbl_tree','lock_table'=>'tbl_lock'); $values = array(); $values ['strna'] ="TOP"; $NeSe->createRootnode($values,false,true); Expected result: ---------------- No insert into the table and script-crash Error message Incorrect syntax near the keyword 'SET'. (severty 15) Actual result: -------------- Error message Incorrect syntax near the keyword 'SET'. (severty 15)

This bug has been fixed in CVS. In case this was a documentation problem, the fix will show up at the end of next Sunday (CET) on pear.php.net. In case this was a pear.php.net website problem, the change will show up on the website in short time. Thank you for the report, and for helping us make PEAR better.