[geeklog-devel] [geeklog-cvs]Geeklog-1.x/sqlmssql_tableanddata.php, 1.34, 1.35

[Randy Kolenko]

> Ok -- this is the mssql db class trying to be "smart".


Looks like its not the mssql class' fault.  It's an issue with the
inserts that have happened before the particular vars table.
Selecting a scope_identity following an insert on a table that has no
identity column simply produces a NULL.  Which is fine as you'd be
ignoring that as a developer anyways.

The issue is in the users insert around lines 1719-1726.  They should
include the new num_reminders field.  
Lines should look like:

$_SQL[] = "
set identity_insert {$_TABLES['users']} on

INSERT INTO {$_TABLES['users']} (uid, username, fullname, passwd, email,
homepage, sig, regdate, cookietimeout, theme, status,num_reminders)
VALUES (1,'Anonymous','Anonymous','',NULL,NULL,'',getdate(),0,NULL,3,0)
INSERT INTO {$_TABLES['users']} (uid, username, fullname, passwd, email,
homepage, sig, regdate, cookietimeout, theme, status,num_reminders)
VALUES (2,'Admin','Geeklog
SuperUser','5f4dcc3b5aa765d61d8327deb882cf99','root at localhost','http://w
ww.geeklog.net/','',getdate(),28800,NULL,3,0)

set identity_insert {$_TABLES['users']} off
";