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

[Michael Jervis]

On Tue, Apr 22, 2008 at 12:39 PM, Randy Kolenko
<Randy.Kolenko at nextide.ca> wrote:
> The hostname parameter should allow you to use 'SQLEXPRESS/instancename'

I tried that this morning and it didn't work, I'm sure, but now with
the new driver it did.

So far, there are a number of errors in the script, I've fixed them
and got on to one that is confusing me, and I've run out of lunch
time:
The statement has been terminated. - INSERT INTO gl_vars (name, value)
VALUES ('totalhits','0') ; select SCOPE_IDENTITY()

The identity is on the [name] column. The inserts for the vars table are:

$_SQL[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('totalhits','0')";
$_SQL[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('lastemailedstories','')";
$_SQL[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('last_scheduled_run','')";
$_SQL[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('spamx.counter','0')";

No inserts on that table work. I have the same with trackbackcodes and
dateCommandCrossReference too. If I can resolve them, the install
"appears" to work (subject to testing the app...)

Mike