Notice: Trying to get property of non-object in C:\inetpub\wwwroot\wolf\plugins\flexual\FlexualController.php on line 556

Wolf CMS - Uncaught RedBean_Exception_SQL

Description

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (STR_TO_DATE(`date`,'%Y-%m-%d %h:%i:%s %p') OR `expiration_date` = '0000-00-' at line 1

Location

Exception thrown on line 105 in C:\inetpub\wwwroot\wolf\plugins\flexual\rb.php

Stack trace

require('C:\inetpub\wwwroot\wolf\app\main.php')  on line 187 in C:\inetpub\wwwroot\index.php
   main()  on line 175 in C:\inetpub\wwwroot\wolf\app\main.php
      Dispatcher→dispatch('/divisions/communications/grants/grant_categories/schools')  on line 133 in C:\inetpub\wwwroot\wolf\app\main.php
         Dispatcher→executeAction('plugin', 'flexual', array[4])  on line 237 in C:\inetpub\wwwroot\wolf\Framework.php
            PluginController→execute('flexual', array[4])  on line 323 in C:\inetpub\wwwroot\wolf\Framework.php
               call_user_func_array(array[2], array[3])  on line 179 in C:\inetpub\wwwroot\wolf\app\controllers\PluginController.php
                  FlexualController→front_related_index('schools', 'grants', 'grant_categories')  on line unknown in unknown
                     RedBean_Facade→getAll('SELECT x.* FROM `grants` x inner join `grant_categories` y on y....')  on line 564 in C:\inetpub\wwwroot\wolf\plugins\flexual\FlexualController.php
                        RedBean_Facade→query('get', 'SELECT x.* FROM `grants` x inner join `grant_categories` y on y....', array[0])  on line 2195 in C:\inetpub\wwwroot\wolf\plugins\flexual\rb.php
                           RedBean_Adapter_DBAdapter→get('SELECT x.* FROM `grants` x inner join `grant_categories` y on y....', array[0])  on line 2209 in C:\inetpub\wwwroot\wolf\plugins\flexual\rb.php
                              RedBean_Driver_PDO→GetAll('SELECT x.* FROM `grants` x inner join `grant_categories` y on y....', array[0])  on line 432 in C:\inetpub\wwwroot\wolf\plugins\flexual\rb.php
                                 RedBean_Driver_PDO→runQuery('SELECT x.* FROM `grants` x inner join `grant_categories` y on y....', array[0])  on line 111 in C:\inetpub\wwwroot\wolf\plugins\flexual\rb.php

Dispatcher status
Variable	Value
`requested_url`	`/divisions/communications/grants/grant_categories/schools`
`controller`	`plugin`
`action`	`flexual`
`params`	`front_related_index, schools, grants, grant_categories`
`request method`	`GET`

SERVER
Variable	Value
`PROCESSOR_ARCHITEW6432`	`AMD64`
`_FCGI_X_PIPE_`	`\\.\pipe\IISFCGI-2bf047ac-c838-4a14-8c0c-3f2391b0b5e0`
`PHP_FCGI_MAX_REQUESTS`	`10000`
`PHPRC`	`C:\Program Files (x86)\PHP\v5.3`
`ALLUSERSPROFILE`	`C:\ProgramData`
`APPDATA`	`C:\Windows\system32\config\systemprofile\AppData\Roaming`
`APP_POOL_CONFIG`	`C:\inetpub\temp\apppools\DefaultAppPool\DefaultAppPool.config`
`APP_POOL_ID`	`DefaultAppPool`
`CommonProgramFiles`	`C:\Program Files (x86)\Common Files`
`CommonProgramFiles(x86)`	`C:\Program Files (x86)\Common Files`
`CommonProgramW6432`	`C:\Program Files\Common Files`
`COMPUTERNAME`	`CM-ADE-ADEWEB1`
`ComSpec`	`C:\Windows\system32\cmd.exe`
`FP_NO_HOST_CHECK`	`NO`
`LOCALAPPDATA`	`C:\Windows\system32\config\systemprofile\AppData\Local`
`NUMBER_OF_PROCESSORS`	`1`
`OS`	`Windows_NT`
`Path`	`C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windo …`
`PATHEXT`	`.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC`
`PROCESSOR_ARCHITECTURE`	`x86`
`PROCESSOR_IDENTIFIER`	`Intel64 Family 6 Model 45 Stepping 2, GenuineIntel`
`PROCESSOR_LEVEL`	`6`
`PROCESSOR_REVISION`	`2d02`
`ProgramData`	`C:\ProgramData`
`ProgramFiles`	`C:\Program Files (x86)`
`ProgramFiles(x86)`	`C:\Program Files (x86)`
`ProgramW6432`	`C:\Program Files`
`PSModulePath`	`C:\Windows\system32\WindowsPowerShell\v1.0\Modules\`
`PUBLIC`	`C:\Users\Public`
`SystemDrive`	`C:`
`SystemRoot`	`C:\Windows`
`TEMP`	`C:\Windows\TEMP`
`TMP`	`C:\Windows\TEMP`
`USERDOMAIN`	`ADE`
`USERNAME`	`CM-ADE-ADEWEB1$`
`USERPROFILE`	`C:\Windows\system32\config\systemprofile`
`windir`	`C:\Windows`
`FCGI_ROLE`	`RESPONDER`
`HTTP_CONTENT_LENGTH`	`0`
`HTTP_ACCEPT`	`text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8`
`HTTP_ACCEPT_ENCODING`	`x-gzip, gzip, deflate`
`HTTP_HOST`	`www.arkansased.gov`
`HTTP_IF_MODIFIED_SINCE`	`Fri, 23 Feb 2018 00:27:46 GMT`
`HTTP_USER_AGENT`	`CCBot/2.0 (http://commoncrawl.org/faq/)`
`HTTP_X_ORIGINAL_URL`	`/divisions/communications/grants/grant_categories/schools`
`IIS_WasUrlRewritten`	`1`
`UNENCODED_URL`	`/divisions/communications/grants/grant_categories/schools`
`IIS_UrlRewriteModule`	`7.1.0871.0`
`APPL_MD_PATH`	`/LM/W3SVC/1/ROOT`
`APPL_PHYSICAL_PATH`	`C:\inetpub\wwwroot\`
`AUTH_TYPE`
`AUTH_PASSWORD`
`AUTH_USER`
`CERT_COOKIE`
`CERT_FLAGS`
`CERT_ISSUER`
`CERT_SERIALNUMBER`
`CERT_SUBJECT`
`CONTENT_LENGTH`	`0`
`CONTENT_TYPE`
`DOCUMENT_ROOT`	`C:\inetpub\wwwroot`
`GATEWAY_INTERFACE`	`CGI/1.1`
`HTTPS`	`off`
`HTTPS_KEYSIZE`
`HTTPS_SECRETKEYSIZE`
`HTTPS_SERVER_ISSUER`
`HTTPS_SERVER_SUBJECT`
`INSTANCE_ID`	`1`
`INSTANCE_NAME`	`DEFAULT WEB SITE`
`INSTANCE_META_PATH`	`/LM/W3SVC/1`
`LOCAL_ADDR`	`165.29.23.153`
`LOGON_USER`
`PATH_TRANSLATED`	`C:\inetpub\wwwroot\index.php`
`QUERY_STRING`	`WOLFPAGE=divisions/communications/grants/grant_categories/school …`
`REMOTE_ADDR`	`54.161.45.156`
`REMOTE_HOST`	`54.161.45.156`
`REMOTE_PORT`	`51442`
`REMOTE_USER`
`REQUEST_METHOD`	`GET`
`REQUEST_URI`	`/divisions/communications/grants/grant_categories/schools`
`SCRIPT_FILENAME`	`C:\inetpub\wwwroot\index.php`
`SCRIPT_NAME`	`/index.php`
`SERVER_NAME`	`www.arkansased.gov`
`SERVER_PORT`	`80`
`SERVER_PORT_SECURE`	`0`
`SERVER_PROTOCOL`	`HTTP/1.0`
`SERVER_SOFTWARE`	`Microsoft-IIS/7.5`
`URL`	`/index.php`
`ORIG_PATH_INFO`	`/index.php`
`PHP_SELF`	`/index.php`
`REQUEST_TIME`	`1524303688`