|
|
|
|
php error happened
| Technical information | |
| Error type | 256 |
| Error description | 8625 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Warning: The join order has been enforced because a local join hint is used. |
| URL | gis.bgohio.org/rentals/rentals_form_add.php?page=add |
| Error file | C:\inetpub\PhPdata\v10_4_Rental_Registration\Registration Formv104\output\connections\Connection.php |
| Error line | 626 |
| SQL query | SELECT DISTINCT ZONE_FINAL FROM [GIS_Replica].[dbo].[Zoning2014_evw] [zvw] WHERE ( ZONE_FINAL not like ' ' ) ORDER BY ZONE_FINAL ASC |
| Call stack | |||
| File: line | Function | Arguments | |
| #0. | connections\Connection.php:626 | trigger_error | 1. 8625 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Warning: The join order has been enforced because a local join hint is used. ; 2. 256; |
| #1. | connections\Connection.php:626 | Connection->triggerError | 1. 8625 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Warning: The join order has been enforced because a local join hint is used. ; |
| #2. | connections\MSSQLSrvConnection.php:52 | MSSQLSrvConnection->triggerErrorMSSQL | N/A |
| #3. | connections\MSSQLSrvConnection.php:91 | MSSQLSrvConnection->query | 1. SELECT DISTINCT ZONE_FINAL FROM [GIS_Replica].[dbo].[Zoning2014_evw] [zvw] WHERE ( ZONE_FINAL not like ' ' ) ORDER BY ZONE_FINAL ASC; |
| #4. | connections\dbfunctions\MSSQLFunctions.php:129 | MSSQLFunctions->limitedQuery | 1. MSSQLSrvConnection; 2. SELECT DISTINCT ZONE_FINAL FROM [GIS_Replica].[dbo].[Zoning2014_evw] [zvw] WHERE ( ZONE_FINAL not like ' ' ) ORDER BY ZONE_FINAL ASC; 3. 0; 4. -1; 5. 1; |
| #5. | connections\Connection.php:566 | Connection->limitedQuery | 1. SELECT DISTINCT
ZONE_FINAL
FROM [GIS_Replica].[dbo].[Zoning2014_evw] [zvw] WHERE ( ZONE_FINAL not like ' ' ) ORDER BY ZONE_FINAL ASC; 2. 0; 3. -1; 4. 1; |
| #6. | classes\datasource\table.php:515 | DataSourceTable->getList | 1. DsCommand; |
| #7. | classes\controls\LookupField.php:659 | LookupField->buildClassicLookup | 1. Array
(
[0] =>
)
; 2. ; 3. 0; 4. ; |
| #8. | classes\controls\LookupField.php:229 | LookupField->buildControl | 1. ; 2. 0; 3. 0; 4. Array ( [basicValidate] => Array ( ) [customMessages] => Array ( ) ) ; 5. Array ( ) ; 6. Array ( ) ; |
| #9. | include\commonfunctions.php:3710 | xt_buildeditcontrol | 1. Array ( [id] => 1 [ptype] => add [field] => rental_zoning_classification [value] => [pageObj] => AddPage Object [validate] => Array ( [basicValidate] => Array ( ) [customMessages] => Array ( ) ) [mode] => add ) ; |
| #10. | include\phpfunctions.php:1225 | xtempl_call_func | 1. xt_buildeditcontrol; 2. Array ( [id] => 1 [ptype] => add [field] => rental_zoning_classification [value] => [pageObj] => AddPage Object [validate] => Array ( [basicValidate] => Array ( ) [customMessages] => Array ( ) ) [mode] => add ) ; |
| #11. | include\xtempl.php:113 | XTempl->processVar | 1. Array
(
[func] => xt_buildeditcontrol
[params] => Array
(
[id] => 1
[ptype] => add
[field] => rental_zoning_classification
[value] =>
[pageObj] => AddPage Object
[validate] => Array
(
[basicValidate] => Array
(
)
[customMessages] => Array
(
)
)
[mode] => add
)
)
; 2. Array ( ) ; |
| #12. | include\commonfunctions.php:4129 | xt_process_template | 1. XTempl; 2.
{$rental_zoning_classification_editcontrol}
{$tooltip dbo_RENTALS_FORM rental_zoning_classification }
|
| #13. | include\commonfunctions.php:4083 | xt_process_template | 1. XTempl; 2. <td {$cell_step2_c1} class=" r-ori-vert" data-fullwidth data-cellId="step2_c1" data-pageid="{$pageid}" data-v-cell="" > <div edit-form-cell class="clearfix"> {BEGIN rental_address_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_rental_address} r-vertical-field" data-fieldname="rental_address" data-signal-error-for="rental_address{$id}" data-itemtype="integrated_edit_field" data-itemid="integrated_edit_field2" {$item_integrated_edit_field2} data-pageid="{$pageid}" data-field="rental_address" data-before-same-field > <label class="r-edit-label control-label" for="{$labelfor_rental_address}"> {BEGIN rental_address_label}{$label dbo_RENTALS_FORM rental_address }{END rental_address_label} </label> <div class="r-edit-field"> {$rental_address_editcontrol} </div> <div class="r-edit-tooltip" data-helpfor="rental_address"> <div class="text-muted" > {$tooltip dbo_RENTALS_FORM rental_address } </div> </div> </div> {END rental_address_fieldblock} <span data-itemtype="text" data-itemid="text" {$item_text} data-pageid="{$pageid}" data-page="rentals_form_add" data-small > If the street address is not found in the list please contact GIS Division at (419)-354-6236</span> {BEGIN rental_property_type_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_rental_property_type} r-vertical-field" data-fieldname="rental_property_type" data-signal-error-for="rental_property_type{$id}" data-itemtype="integrated_edit_field" data-itemid="integrated_edit_field3" {$item_integrated_edit_field3} data-pageid="{$pageid}" data-field="rental_property_type" > <label class="r-edit-label control-label" for="{$labelfor_rental_property_type}"> {BEGIN rental_property_type_label}{$label dbo_RENTALS_FORM rental_property_type }{END rental_property_type_label} </label> <div class="r-edit-field"> {$rental_property_type_editcontrol} </div> <div class="r-edit-to...; |
| #14. | include\commonfunctions.php:4083 | xt_process_template | 1. XTempl; 2. <table data-body-align="center" data-location="step2" id="form_step2_{$pageid}" data-makeup="small" {$form_step2} data-pageid="{$pageid}" class="r-edit-form" cellpadding="0" cellspacing="0" {$grid_hiddenattr} data-form-width="1" data-v-width="4" > <tbody> <tr> {BEGIN cellblock_step2_c1} <td {$cell_step2_c1} class=" r-ori-vert" data-fullwidth data-cellId="step2_c1" data-pageid="{$pageid}" data-v-cell="" > <div edit-form-cell class="clearfix"> {BEGIN rental_address_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_rental_address} r-vertical-field" data-fieldname="rental_address" data-signal-error-for="rental_address{$id}" data-itemtype="integrated_edit_field" data-itemid="integrated_edit_field2" {$item_integrated_edit_field2} data-pageid="{$pageid}" data-field="rental_address" data-before-same-field > <label class="r-edit-label control-label" for="{$labelfor_rental_address}"> {BEGIN rental_address_label}{$label dbo_RENTALS_FORM rental_address }{END rental_address_label} </label> <div class="r-edit-field"> {$rental_address_editcontrol} </div> <div class="r-edit-tooltip" data-helpfor="rental_address"> <div class="text-muted" > {$tooltip dbo_RENTALS_FORM rental_address } </div> </div> </div> {END rental_address_fieldblock} <span data-itemtype="text" data-itemid="text" {$item_text} data-pageid="{$pageid}" data-page="rentals_form_add" data-small > If the street address is not found in the list please contact GIS Division at (419)-354-6236</span> {BEGIN rental_property_type_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_rental_property_type} r-vertical-field" data-fieldname="rental_property_type" data-signal-error-for="rental_property_type{$id}" data-itemtype="integrated_edit_field" data-itemid="integrated_edit_field3" {$item_integrated_edit_field3} data-pageid="{$pag...; |
| #15. | include\commonfunctions.php:4083 | xt_process_template | 1. XTempl; 2. <div id="step_0_{$id}" class="stepFrame" data-step="0" > {BEGIN grid_block} <table data-body-align="center" data-location="grid" id="form_grid_{$pageid}" data-makeup="small" {$form_grid} data-pageid="{$pageid}" class="r-edit-form" cellpadding="0" cellspacing="0" {$grid_hiddenattr} data-form-width="1" data-v-width="4" > <tbody> <tr> {BEGIN cellblock_grid_c3} <td {$cell_grid_c3} class=" r-ori-vert" data-fullwidth data-cellId="grid_c3" data-pageid="{$pageid}" data-v-cell="4" > <div edit-form-cell class="clearfix"> {BEGIN registration_type_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_registration_type} r-vertical-field" data-fieldname="registration_type" data-signal-error-for="registration_type{$id}" data-itemtype="integrated_edit_field" data-itemid="integrated_edit_field20" {$item_integrated_edit_field20} data-pageid="{$pageid}" data-field="registration_type" > <label class="r-edit-label control-label" for="{$labelfor_registration_type}"> {BEGIN registration_type_label}{$label dbo_RENTALS_FORM registration_type }{END registration_type_label} </label> <div class="r-edit-field"> {$registration_type_editcontrol} </div> <div class="r-edit-tooltip" data-helpfor="registration_type"> <div class="text-muted" > {$tooltip dbo_RENTALS_FORM registration_type } </div> </div> </div> {END registration_type_fieldblock} {BEGIN SHAPE_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_SHAPE} r-vertical-field" data-fieldname="SHAPE" data-signal-error-for="SHAPE{$id}" data-itemtype="integrated_edit_field" data-itemid="integrated_edit_field18" {$item_integrated_edit_field18} data-pageid="{$pageid}" data-field="SHAPE" > <label class="r-edit-label control-label" for="{$labelfor_SHAPE}"> {BEGIN SHAPE_label}{$label dbo_RENTALS_FORM SHAPE }{END SHAPE_label} </label> <div class="r-edit-fiel...; |
| #16. | include\commonfunctions.php:4083 | xt_process_template | 1. XTempl; 2. {$header} <style> {$containerCss} </style> {$locking} <div class="r-small-page" data-body-align="center" data-body-width="standard" > {BEGIN top_block} <div class="r-form" data-location="top" id="form_top_{$pageid}" data-makeup="small" {$form_top} data-pageid="{$pageid}" data-v-width="4" data-v-margin="1" > <div class="row"> <div data-cellId="top_c1" data-pageid="{$pageid}" {$cell_top_c1} class=" r-ori-vert col-md-12 "> <h2 data-itemtype="add_header" data-itemid="add_header" {$item_add_header} data-pageid="{$pageid}" >{$pagetitlelabel dbo_RENTALS_FORM add}</h2> </div> </div> </div> {END top_block} {BEGIN above-grid_block} <div class="r-form" data-location="above-grid" id="form_above-grid_{$pageid}" data-makeup="small" {$form_above-grid} data-pageid="{$pageid}" data-v-width="4" data-v-margin="1" > <div class="row"> <div data-cellId="above-grid_c1" data-pageid="{$pageid}" {$cell_above-grid_c1} class=" r-ori-vert col-md-12 "> {BEGIN message_block} <div data-itemtype="add_message" data-itemid="add_message" {$item_add_message} data-pageid="{$pageid}" class="alert {$message_class}" role="alert"> <h5>{$message}</h5> <div> {BEGIN back_button} <button class="btn btn-sm btn-default" {$backbutton_attrs}>Back to menu</button> {END back_button} {BEGIN view_page_button} <button class="btn btn-sm btn-default" {$view_page_button_attrs}>View</button> {END view_page_button} {BEGIN edit_page_button} <button class="btn btn-sm btn-default" {$edit_page_button_attrs}>Edit</button> {END edit_page_button} </div> </div> {END message_block} </div> </div> <div class="row"> <div data-cellId="above-grid_c2" data-pageid="{$pageid}" {$cell_above-grid_c2} class=" r-ori-vert col-md-12 "> <ul class="nav nav-pills nav-justified" id="stepnav{$id}" data-stepcontrol data-itemtype="step_nav" data-itemid="step_nav" {$item_step_nav} data-pageid="{$pageid}"> <li...; |
| #17. | include\commonfunctions.php:4083 | xt_process_template | 1. XTempl; 2. <!doctype html> <html {$html_attrs}> <head> <meta http-equiv="X-UA-Compatible" content="IE=Edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>{$pagetitle}</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <base href="{$projectPath}"> <link REL="stylesheet" href="styles/default.css?{$wizardBuildKey}" type="text/css"> {BEGIN rtlCSS} <link REL="stylesheet" href="styles/defaultRTL.css?{$wizardBuildKey}" type="text/css"> {END rtlCSS} {BEGIN styleCSSFiles} <link REL="stylesheet" href="{$stylepath}" type="text/css"> {END styleCSSFiles} </head> <body class="{$stylename} function-add" {$bodyattrs}> {BEGIN body} {$header} <style> {$containerCss} </style> {$locking} <div class="r-small-page" data-body-align="center" data-body-width="standard" > {BEGIN top_block} <div class="r-form" data-location="top" id="form_top_{$pageid}" data-makeup="small" {$form_top} data-pageid="{$pageid}" data-v-width="4" data-v-margin="1" > <div class="row"> <div data-cellId="top_c1" data-pageid="{$pageid}" {$cell_top_c1} class=" r-ori-vert col-md-12 "> <h2 data-itemtype="add_header" data-itemid="add_header" {$item_add_header} data-pageid="{$pageid}" >{$pagetitlelabel dbo_RENTALS_FORM add}</h2> </div> </div> </div> {END top_block} {BEGIN above-grid_block} <div class="r-form" data-location="above-grid" id="form_above-grid_{$pageid}" data-makeup="small" {$form_above-grid} data-pageid="{$pageid}" data-v-width="4" data-v-margin="1" > <div class="row"> <div data-cellId="above-grid_c1" data-pageid="{$pageid}" {$cell_above-grid_c1} class=" r-ori-vert col-md-12 "> {BEGIN message_block} <div data-itemtype="add_message" data-itemid="add_message" {$item_add_message} data-pageid="{$pageid}" class="alert {$message_class}" role="alert"> <h5>{$message}</h5> <div> {BEGIN back_button} <button class="btn btn-sm btn-default" {$ba...; |
| #18. | include\xtempl.php:136 | XTempl->display | 1. rentals_form_add.htm; |
| #19. | classes\runnerpage.php:5914 | RunnerPage->display | 1. rentals_form_add.htm; |
| #20. | classes\addpage.php:1482 | AddPage->displayAddPage | N/A |
| #21. | classes\addpage.php:371 | AddPage->process | N/A |
| #22. | rentals_form_add.php:84 | Global scope | N/A |