[geeklog-devel] MS SQL Upgrade

Michael Jervis mjervis at gmail.com
Fri May 23 08:07:16 EDT 2008


Just got keys and indicies to sort for the polls plugin upgrade now, plus this:

Warning: mysql_real_escape_string()
[function.mysql-real-escape-string]: Access denied for user
'ODBC'@'localhost' (using password: NO) in
O:\development\geeklog\glsql\sql\updates\mssql_1.4.1_to_1.5.0.php on
line 452

    $move_sql = "SELECT pid, topic FROM {$_TABLES['polltopics']}";
    $move_rst = DB_query ($move_sql);
    $count_move = DB_numRows($move_rst);
    for ($i = 0; $i < $count_move; $i++) {
        $A = DB_fetchArray($move_rst);
        $A[1] = mysql_real_escape_string($A[1]); <- HERE
****************************
        $P_SQL[] = "INSERT INTO {$_TABLES['pollquestions']} (pid,
question) VALUES ('{$A[0]}','{$A[1]}');";
    }

Suggestions?

-- 
Michael Jervis
mjervis at gmail.com
504B03041400000008008F846431E3543A820800000006000000060000007765
62676F642B4F4D4ACF4F0100504B010214001400000008008F846431E3543A82
0800000006000000060000000000000000002000000000000000776562676F64
504B05060000000001000100340000002C0000000000



More information about the geeklog-devel mailing list