Bug #808

use of other DB as mysql (MSSQL)

Details

Submitted	2004-02-20 12:12 UTC
From	j dot forstner at a1 dot net
Assigned	datenpunk
Status	Closed
Package	DB_NestedSet
PHP Version	4.3.4
OS	WIN
Roadmaps	(Not assigned)

Comments

[2004-02-20 12:12 UTC] j dot forstner at a1 dot net

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)

[2004-02-20 12:17 UTC] datenpunk at php dot net

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.