Hi all,
I have tried to update the version 5.2.4 to 5.2.9 but it stopped with the follwoing error, before I was able to check/update the database. The database needs an upgrade from version 478 to 479.
Error:
CDbCommand failed to execute the SQL statement: SQLSTATE[07002]: [Microsoft][ODBC Driver 17 for SQL Server]Das COUNT-Feld ist nicht korrekt, oder es besteht ein Syntaxfehler.
File: ...\application\helpers\update\updatedb_helper.php, line 5047.
Information about the system:
- OS: Windows Server 2019
- Webserver: IIS
- PHP: 7.4.27
- DB: MS SQL Server Express (14.0.3381.3)
I have found the following information on a Microsoft website (
docs.microsoft.com/en-us/sql/odbc/refere...iew=sql-server-ver15
):
07002 COUNT field incorrect
The number of parameters specified in
SQLBindParameter was less than the number of parameters in the SQL statement contained in *
StatementText.
SQLBindParameter was called with
ParameterValuePtr set to a null pointer,
StrLen_or_IndPtr not set to SQL_NULL_DATA or SQL_DATA_AT_EXEC, and
InputOutputType not set to SQL_PARAM_OUTPUT, so that the number of parameters specified in
SQLBindParameter was greater than the number of parameters in the SQL statement contained in *
StatementText.
Does anyone have any idea how to fix this problem?
