Error (object)
D:\home\site\wwwroot\globalinclude\classes\db.php:95
PDOException Object
(
  [message:protected] => SQLSTATE[42000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near ')'.
  [string:Exception:private] => 
  [code:protected] => 42000
  [file:protected] => D:\home\site\wwwroot\globalinclude\classes\db.php
  [line:protected] => 71
  [trace:Exception:private] => Array
    (
      [0] => Array
        (
          [file] => D:\home\site\wwwroot\globalinclude\classes\db.php
          [line] => 71
          [function] => execute
          [class] => PDOStatement
          [type] => ->
          [args] => Array
            (
            )

        )

      [1] => Array
        (
          [file] => D:\home\site\wwwroot\globalinclude\classes\db.php
          [line] => 19
          [function] => Query
          [class] => db
          [type] => ::
          [args] => Array
            (
              [0] => SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject FROM tblSubject WHERE LOWER(strSubject) = '')
              [1] => Array
                (
                )

              [2] => PDO Object
                (
                )

              [3] => 1
            )

        )

      [2] => Array
        (
          [file] => D:\home\site\wwwroot\v4\realtruth\templates\subject.php
          [line] => 41
          [function] => FullQuery
          [class] => db
          [type] => ::
          [args] => Array
            (
              [0] => SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject FROM tblSubject WHERE LOWER(strSubject) = '')
            )

        )

      [3] => Array
        (
          [file] => D:\home\site\wwwroot\globalinclude\content.php
          [line] => 360
          [args] => Array
            (
              [0] => D:\home\site\wwwroot\v4\realtruth\templates\subject.php
            )

          [function] => require
        )

      [4] => Array
        (
          [file] => D:\home\site\wwwroot\v4\realtruth\rtController.php
          [line] => 84
          [args] => Array
            (
              [0] => D:\home\site\wwwroot\globalinclude\content.php
            )

          [function] => include
        )

    )

  [previous:Exception:private] => 
  [errorInfo] => Array
    (
      [0] => 42000
      [1] => 102
      [2] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near ')'.
    )

  [xdebug_message] => ( ! ) PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near ')'. in D:\home\site\wwwroot\globalinclude\classes\db.php on line 71
Call Stack
#TimeMemoryFunctionLocation
10.0004380384{main}(  )...\rtController.php:0
20.1260618000include( 'D:\home\site\wwwroot\globalinclude\content.php' )...\rtController.php:84
30.1770653232require( 'D:\home\site\wwwroot\v4\realtruth\templates\subject.php' )...\content.php:360
40.1771653424db::FullQuery(  )...\subject.php:41
50.1771653424db::Query(  )...\db.php:19
60.1771654992execute
(  )...\db.php:71

)

SQL (string)
D:\home\site\wwwroot\globalinclude\classes\db.php:95
SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject FROM tblSubject WHERE LOWER(strSubject) = '')
Parameters (array)
D:\home\site\wwwroot\globalinclude\classes\db.php:95
Array
(
)

Backtrace (string)
D:\home\site\wwwroot\globalinclude\classes\db.php:95

( ! ) Xdebug: user triggered in D:\home\site\wwwroot\globalinclude\functionLibrary\debug.php on line 278
Call Stack
#TimeMemoryFunctionLocation
10.0004380384{main}( )...\rtController.php:0
20.1260618000include( 'D:\home\site\wwwroot\globalinclude\content.php' )...\rtController.php:84
30.1770653232require( 'D:\home\site\wwwroot\v4\realtruth\templates\subject.php' )...\content.php:360
40.1771653424db::FullQuery( )...\subject.php:41
50.1771653424db::Query( )...\db.php:19
60.1792671256getDebugBacktrace( )...\db.php:95
70.1792687688xdebug_print_function_stack ( )...\debug.php:278
Error (object)
D:\home\site\wwwroot\globalinclude\classes\db.php:95
PDOException Object
(
  [message:protected] => SQLSTATE[42S22]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'MyDerivedTable'.
  [string:Exception:private] => 
  [code:protected] => 42S22
  [file:protected] => D:\home\site\wwwroot\globalinclude\classes\db.php
  [line:protected] => 71
  [trace:Exception:private] => Array
    (
      [0] => Array
        (
          [file] => D:\home\site\wwwroot\globalinclude\classes\db.php
          [line] => 71
          [function] => execute
          [class] => PDOStatement
          [type] => ->
          [args] => Array
            (
            )

        )

      [1] => Array
        (
          [file] => D:\home\site\wwwroot\globalinclude\classes\db.php
          [line] => 19
          [function] => Query
          [class] => db
          [type] => ::
          [args] => Array
            (
              [0] => SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject FROM tblSubject WHERE LOWER(strSubject) = '')) AS MyDerivedTable WHERE MyDerivedTable BETWEEN 0 AND 10 ORDER BY strSortableTitle, dtmPublished
              [1] => Array
                (
                )

              [2] => PDO Object
                (
                )

              [3] => 1
            )

        )

      [2] => Array
        (
          [file] => D:\home\site\wwwroot\v4\realtruth\templates\subject.php
          [line] => 56
          [function] => FullQuery
          [class] => db
          [type] => ::
          [args] => Array
            (
              [0] => SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject FROM tblSubject WHERE LOWER(strSubject) = '')) AS MyDerivedTable WHERE MyDerivedTable BETWEEN 0 AND 10 ORDER BY strSortableTitle, dtmPublished
            )

        )

      [3] => Array
        (
          [file] => D:\home\site\wwwroot\globalinclude\content.php
          [line] => 360
          [args] => Array
            (
              [0] => D:\home\site\wwwroot\v4\realtruth\templates\subject.php
            )

          [function] => require
        )

      [4] => Array
        (
          [file] => D:\home\site\wwwroot\v4\realtruth\rtController.php
          [line] => 84
          [args] => Array
            (
              [0] => D:\home\site\wwwroot\globalinclude\content.php
            )

          [function] => include
        )

    )

  [previous:Exception:private] => 
  [errorInfo] => Array
    (
      [0] => 42S22
      [1] => 207
      [2] => [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'MyDerivedTable'.
    )

  [xdebug_message] => ( ! ) PDOException: SQLSTATE[42S22]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'MyDerivedTable'. in D:\home\site\wwwroot\globalinclude\classes\db.php on line 71
Call Stack
#TimeMemoryFunctionLocation
10.0004380384{main}(  )...\rtController.php:0
20.1260618000include( 'D:\home\site\wwwroot\globalinclude\content.php' )...\rtController.php:84
30.1770653232require( 'D:\home\site\wwwroot\v4\realtruth\templates\subject.php' )...\content.php:360
40.1793661744db::FullQuery(  )...\subject.php:56
50.1793661744db::Query(  )...\db.php:19
60.1794663568execute
(  )...\db.php:71

)

SQL (string)
D:\home\site\wwwroot\globalinclude\classes\db.php:95
SELECT lngProduct FROM (SELECT lngProduct, ROW_NUMBER() OVER (ORDER BY strSortableTitle, dtmPublished) AS RowNum FROM tblProduct WHERE bytType IN (SELECT bytType FROM tblType WHERE bytSite = 2) AND strURL LIKE '%.html' AND wrdSubject = (SELECT wrdSubject FROM tblSubject WHERE LOWER(strSubject) = '')) AS MyDerivedTable WHERE MyDerivedTable BETWEEN 0 AND 10 ORDER BY strSortableTitle, dtmPublished
Parameters (array)
D:\home\site\wwwroot\globalinclude\classes\db.php:95
Array
(
)

Backtrace (string)
D:\home\site\wwwroot\globalinclude\classes\db.php:95

( ! ) Xdebug: user triggered in D:\home\site\wwwroot\globalinclude\functionLibrary\debug.php on line 278
Call Stack
#TimeMemoryFunctionLocation
10.0004380384{main}( )...\rtController.php:0
20.1260618000include( 'D:\home\site\wwwroot\globalinclude\content.php' )...\rtController.php:84
30.1770653232require( 'D:\home\site\wwwroot\v4\realtruth\templates\subject.php' )...\content.php:360
40.1793661744db::FullQuery( )...\subject.php:56
50.1793661744db::Query( )...\db.php:19
60.1833679832getDebugBacktrace( )...\db.php:95
70.1833696264xdebug_print_function_stack ( )...\debug.php:278
Subject Search

Subject Search

No results found.