SQL Server error 1934 occurs on INSERT to table with computed column PHP/PDO

by

Turns out the problem had to do with the SET parameters. I used the code below obtained from Here. To determine which options were set in SQL Server Management Studio (where the insert worked). Then placing each of those in an exec prior to my insert statement caused things to work again. I didn’t need to keep all the options, so below I show the ones which were required to get it working.

DECLARE @options INT
SELECT @options = @@OPTIONS

PRINT @options
IF ( (1 & @options) = 1 ) PRINT 'DISABLE_DEF_CNST_CHK' 
IF ( (2 & @options) = 2 ) PRINT 'IMPLICIT_TRANSACTIONS' 
IF ( (4 & @options) = 4 ) PRINT 'CURSOR_CLOSE_ON_COMMIT' 
IF ( (8 & @options) = 8 ) PRINT 'ANSI_WARNINGS' 
IF ( (16 & @options) = 16 ) PRINT 'ANSI_PADDING' 
IF ( (32 & @options) = 32 ) PRINT 'ANSI_NULLS' 
IF ( (64 & @options) = 64 ) PRINT 'ARITHABORT' 
IF ( (128 & @options) = 128 ) PRINT 'ARITHIGNORE'
IF ( (256 & @options) = 256 ) PRINT 'QUOTED_IDENTIFIER' 
IF ( (512 & @options) = 512 ) PRINT 'NOCOUNT' 
IF ( (1024 & @options) = 1024 ) PRINT 'ANSI_NULL_DFLT_ON' 
IF ( (2048 & @options) = 2048 ) PRINT 'ANSI_NULL_DFLT_OFF' 
IF ( (4096 & @options) = 4096 ) PRINT 'CONCAT_NULL_YIELDS_NULL' 
IF ( (8192 & @options) = 8192 ) PRINT 'NUMERIC_ROUNDABORT' 
IF ( (16384 & @options) = 16384 ) PRINT 'XACT_ABORT'

Here are the options I ended up needing:

$dbPDO->exec("SET ANSI_WARNINGS ON");                                                                               
$dbPDO->exec("SET ANSI_PADDING ON");
$dbPDO->exec("SET ANSI_NULLS ON");
$dbPDO->exec("SET QUOTED_IDENTIFIER ON");
$dbPDO->exec("SET CONCAT_NULL_YIELDS_NULL ON");

Update:
It seems FK constraints resulted in the following error. The above fixed this error as well.

SQLSTATE[HY000]: General error: 8624 General SQL Server error: Check
messages from the SQL Server [8624] (severity 16) [(null)]

More Related Contents:

  1. Connect PHP to MSSQL via PDO ODBC
  2. Connect to SQL Server through PDO using SQL Server Driver
  3. How to connect to mssql using pdo through PHP and Linux?
  4. Getting data with UTF-8 charset from MSSQL server using PHP FreeTDS extension
  5. “Adaptive Server is unavailable or does not exist” error connecting to SQL Server from PHP
  6. Can I mix MySQL APIs in PHP?
  7. Can PHP PDO Statements accept the table or column name as parameter?
  8. Can I bind an array to an IN() condition in a PDO query?
  9. PDOException “could not find driver”
  10. Row count with PDO
  11. PDO get the last ID inserted
  12. How to view query error in PDO PHP
  13. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  14. Insert/update helper function using PDO
  15. PHP PDO – Bind table name? [duplicate]
  16. Is the leading colon for parameter names passed to PDOStatement::bindParam() optional?
  17. How to debug PDO database queries?
  18. PDO’s query vs execute
  19. Resetting array pointer in PDO results
  20. Notice: Array to string conversion in
  21. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  22. Parametrized PDO query and `LIMIT` clause – not working [duplicate]
  23. Using htmlspecialchars function with PDO prepare and execute
  24. PDO::PARAM for type decimal?
  25. Update query with PDO and MySQL
  26. Retrieve (or simulate) full query from PDO prepared statement
  27. PDO returning incorrect, but duplicate, data. Key’s not in database.
  28. Set PDO to throw exceptions by default [duplicate]
  29. PDOStatement to JSON [closed]
  30. prepared parameterized query with PDO

Leave a Comment