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

[Randy Kolenko]

Using the patch below for the mssql tables and data, the install works
all the way until the config values ar being saved to the db.  This line
is failing now:

INSERT INTO gl_conf_values (name, value, type, subgroup, group_name,
selectionArray, sort_order, fieldset, default_value) VALUES
("microsummary_short","s:4:"GL: ";","text",0,"Core",-1,80,0, "s:4:"GL:
";")

The above line is generated in config.class.php and is called during the
install_config() call in admin/install/index.php.

Config.class.php on lines 282 and 283 does an str_replace on the
apostrophes to make them quotation marks.  But it would appear that the
result it not quite what was intended :-)

Quotation marks are valid field delimiters, but the problem is the
"s:4:"GL: ";" portion of the line where we've obviously got a string
issue in there.
I just haven't had time to understand why the string replacements were
done quite yet... Anyone more versed in that area of code (Aaron)?




> $_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
";