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

        )

      [1] => Array
        (
          [file] => F:\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) = 'prophecy')
              [1] => Array
                (
                )

              [2] => PDO Object
                (
                )

              [3] => 1
            )

        )

      [2] => Array
        (
          [file] => F:\rcg.org\site\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) = 'prophecy')
            )

        )

      [3] => Array
        (
          [file] => F:\globalinclude\content.php
          [line] => 352
          [args] => Array
            (
              [0] => F:\rcg.org\site\v4\realtruth\templates\subject.php
            )

          [function] => require
        )

      [4] => Array
        (
          [file] => F:\rcg.org\site\v4\realtruth\rtController.php
          [line] => 83
          [args] => Array
            (
              [0] => F:\globalinclude\content.php
            )

          [function] => include
        )

    )

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

  [xdebug_message] => ( ! ) PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near ')'. in F:\globalinclude\classes\db.php on line 71
Call Stack
#TimeMemoryFunctionLocation
10.0010372480{main}(  )...\rtController.php:0
20.14914198800include( 'F:\globalinclude\content.php' )...\rtController.php:83
30.21194385800require( 'F:\rcg.org\site\v4\realtruth\templates\subject.php' )...\content.php:352
40.21194386056db::FullQuery(  )...\subject.php:41
50.21194386104db::Query(  )...\db.php:19
60.21204387624execute
(  )...\db.php:71

)

SQL (string)
F:\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) = 'prophecy')
Parameters (array)
F:\globalinclude\classes\db.php:95
Array
(
)

Backtrace (string)
F:\globalinclude\classes\db.php:95

( ! ) Xdebug: user triggered in F:\globalinclude\functionLibrary\debug.php on line 278
Call Stack
#TimeMemoryFunctionLocation
10.0010372480{main}( )...\rtController.php:0
20.14914198800include( 'F:\globalinclude\content.php' )...\rtController.php:83
30.21194385800require( 'F:\rcg.org\site\v4\realtruth\templates\subject.php' )...\content.php:352
40.21194386056db::FullQuery( )...\subject.php:41
50.21194386104db::Query( )...\db.php:19
60.21354403864getDebugBacktrace( )...\db.php:95
70.21354420296xdebug_print_function_stack ( )...\debug.php:278
Error (object)
F:\globalinclude\classes\db.php:95
PDOException Object
(
  [message:protected] => SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'MyDerivedTable'.
  [string:Exception:private] => 
  [code:protected] => 42S22
  [file:protected] => F:\globalinclude\classes\db.php
  [line:protected] => 71
  [trace:Exception:private] => Array
    (
      [0] => Array
        (
          [file] => F:\globalinclude\classes\db.php
          [line] => 71
          [function] => execute
          [class] => PDOStatement
          [type] => ->
          [args] => Array
            (
            )

        )

      [1] => Array
        (
          [file] => F:\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) = 'prophecy')) AS MyDerivedTable WHERE MyDerivedTable BETWEEN 0 AND 10 ORDER BY strSortableTitle, dtmPublished
              [1] => Array
                (
                )

              [2] => PDO Object
                (
                )

              [3] => 1
            )

        )

      [2] => Array
        (
          [file] => F:\rcg.org\site\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) = 'prophecy')) AS MyDerivedTable WHERE MyDerivedTable BETWEEN 0 AND 10 ORDER BY strSortableTitle, dtmPublished
            )

        )

      [3] => Array
        (
          [file] => F:\globalinclude\content.php
          [line] => 352
          [args] => Array
            (
              [0] => F:\rcg.org\site\v4\realtruth\templates\subject.php
            )

          [function] => require
        )

      [4] => Array
        (
          [file] => F:\rcg.org\site\v4\realtruth\rtController.php
          [line] => 83
          [args] => Array
            (
              [0] => F:\globalinclude\content.php
            )

          [function] => include
        )

    )

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

  [xdebug_message] => ( ! ) PDOException: SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'MyDerivedTable'. in F:\globalinclude\classes\db.php on line 71
Call Stack
#TimeMemoryFunctionLocation
10.0010372480{main}(  )...\rtController.php:0
20.14914198800include( 'F:\globalinclude\content.php' )...\rtController.php:83
30.21194385800require( 'F:\rcg.org\site\v4\realtruth\templates\subject.php' )...\content.php:352
40.21364394312db::FullQuery(  )...\subject.php:56
50.21364394360db::Query(  )...\db.php:19
60.21364396072execute
(  )...\db.php:71

)

SQL (string)
F:\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) = 'prophecy')) AS MyDerivedTable WHERE MyDerivedTable BETWEEN 0 AND 10 ORDER BY strSortableTitle, dtmPublished
Parameters (array)
F:\globalinclude\classes\db.php:95
Array
(
)

Backtrace (string)
F:\globalinclude\classes\db.php:95

( ! ) Xdebug: user triggered in F:\globalinclude\functionLibrary\debug.php on line 278
Call Stack
#TimeMemoryFunctionLocation
10.0010372480{main}( )...\rtController.php:0
20.14914198800include( 'F:\globalinclude\content.php' )...\rtController.php:83
30.21194385800require( 'F:\rcg.org\site\v4\realtruth\templates\subject.php' )...\content.php:352
40.21364394312db::FullQuery( )...\subject.php:56
50.21364394360db::Query( )...\db.php:19
60.21564412312getDebugBacktrace( )...\db.php:95
70.21564428744xdebug_print_function_stack ( )...\debug.php:278
Subject Search

Tools
Text Size
+
-
Print
RSS
Help
Share

The Real Truth - Subject Search

Prophecy

No results found.