[Plugin wp-db-abstraction] database error

  • I get the following error message during the install of wordpress on an mssql server

    WordPress database error: [Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.]
    SELECT option_value FROM wp_options WHERE option_name = ‘home’–PREPARE
    WordPress database error: [Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.]
    SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’–PREPARE
    WordPress database error: [The statement has been terminated.]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘home’, ‘https://xxx.co.uk/wordpress’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)–PREPARE

Viewing 2 replies - 1 through 2 (of 2 total)

  • I have the same problem…please, can somebady answer ?

    I have resolved this problems:
    For fix this issues you must edit the file “translations.php” in “sqlsrv” folder:

    For the error “[Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.]” the solution is edit the code

    $query = substr_replace($query, 'NVARCHAR(<strong>MAX</strong>)', $start_pos, strlen($ac_type));

    in

    $query = substr_replace($query, 'NVARCHAR(<strong>900</strong>)', $start_pos, strlen($ac_type));

    For the error “[The statement has been terminated.]” add line code

    return $update;

    after

    $this->following_query = $update; and before of the ‘}’

    in the ‘on_duplicate_key’ function.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Plugin wp-db-abstraction] database error’ is closed to new replies.