|
|
Application error happened
| Technical information | |
| Error type | 256 |
| Error description | Unknown column 'productimage' in 'field list' |
| URL | customdataservices.net/classicmodels/orderdetails_search.php?masterkey1=10117&mastertable=orders |
| Error file | /home/customda/public_html/classicmodels/connections/Connection.php |
| Error line | 664 |
| SQL query | SELECT productCode, productName, productLine, productScale, productVendor, productDescription, quantityInStock, buyPrice, MSRP, productimage, productthumbnail FROM `products` |
| Call stack | |||
| File: line | Function | Arguments | |
| #0 | connections/Connection.php:664 | Connection->triggerError | 0. Unknown column 'productimage' in 'field list' |
| #1 | connections/MySQLiConnection.php:154 | MySQLiConnection->query | 0. SELECT productCode, productName, productLine, productScale, productVendor, productDescription, quantityInStock, buyPrice, MSRP, productimage, productthumbnail FROM `products` |
| #2 | connections/dbfunctions/MySQLFunctions.php:130 | MySQLFunctions->limitedQuery | 0. MySQLiConnection 1. SELECT productCode, productName, productLine, productScale, productVendor, productDescription, quantityInStock, buyPrice, MSRP, productimage, productthumbnail FROM `products` 2. 0 3. -1 4. 1 |
| #3 | connections/Connection.php:604 | Connection->limitedQuery | 0. SELECT
productCode, productName, productLine, productScale, productVendor, productDescription, quantityInStock, buyPrice, MSRP, productimage, productthumbnail
FROM `products` 1. 0 2. -1 3. 1 |
| #4 | classes/datasource/table.php:645 | DataSourceTable->getListImpl | 0. DsCommand |
| #5 | classes/datasource/datasource.php:44 | DataSource->getList | 0. DsCommand |
| #6 | classes/controls/LookupField.php:637 | LookupField->buildClassicLookup | 0. Array ( [0] => ) 1. 2. 2 3. Contains |
| #7 | classes/controls/LookupField.php:227 | LookupField->buildControl | 0. 1. 2 2. 0 3. Array ( ) 4. Array ( [hidden] => [option] => Contains ) 5. Array ( ) |
| #8 | include/commonfunctions.php:3229 | xt_buildeditcontrol | 0. Array ( [field] => productCode [mode] => search [ptype] => search [id] => 1 [fieldNum] => 0 [format] => Lookup wizard [pageObj] => AdvancedSearchControl Object [value] => [additionalCtrlParams] => Array ) |
| #9 | include/phpfunctions.php:1282 | xtempl_call_func | 0. xt_buildeditcontrol 1. Array ( [field] => productCode [mode] => search [ptype] => search [id] => 1 [fieldNum] => 0 [format] => Lookup wizard [pageObj] => AdvancedSearchControl Object [value] => [additionalCtrlParams] => Array ) |
| #10 | include/xtempl.php:49 | XTempl->processVar | 0. Array ( [func] => xt_buildeditcontrol [params] => Array ) 1. Array ( ) |
| #11 | classes/xtempl_base.php:858 | XTempl_Base->process_template | 0. <div class="r-integrated-field form-group clearfix {$fielddispclass_productCode} r-horizontal-field form-horizontal" data-signal-error-for="productCode{$id}" data-itemtype="integrated_search_field" data-itemid="integrated_search_field1" {$item_integrated_search_field1}="" data-pageid="{$pageid}" data-field="productCode" data-fieldname="productCode" > <label class="r-search-label control-label" for="{$labelfor_productCode}"> {$label orderdetails productCode } </label> <div class="r-search-option"> {$searchtype_productCode} </div> <div class="r-search-field"> {$productCode_editcontrol} </div> <div class="r-search-field"> {$productCode_editcontrol1} </div> </div> |
| #12 | classes/xtempl_base.php:812 | XTempl_Base->process_template | 0. <td {$cell_grid_c3} class=" r-ori-vert" data-fullwidth data-cellId="grid_c3" data-pageid="{$pageid}" data-v-cell="6" > <div edit-form-cell class="clearfix"> {BEGIN orderNumber_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_orderNumber} r-horizontal-field form-horizontal" data-signal-error-for="orderNumber{$id}" data-itemtype="integrated_search_field" data-itemid="integrated_search_field" {$item_integrated_search_field}="" data-pageid="{$pageid}" data-field="orderNumber" data-fieldname="orderNumber" > <label class="r-search-label control-label" for="{$labelfor_orderNumber}"> {$label orderdetails orderNumber } </label> <div class="r-search-option"> {$searchtype_orderNumber} </div> <div class="r-search-field"> {$orderNumber_editcontrol} </div> <div class="r-search-field"> {$orderNumber_editcontrol1} </div> </div> {END orderNumber_fieldblock} {BEGIN productCode_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_productCode} r-horizontal-field form-horizontal" data-signal-error-for="productCode{$id}" data-itemtype="integrated_search_field" data-itemid="integrated_search_field1" {$item_integrated_search_field1}="" data-pageid="{$pageid}" data-field="productCode" data-fieldname="productCode" > <label class="r-search-label control-label" for="{$labelfor_productCode}"> {$label orderdetails productCode } </label> <div class="r-search-option"> {$searchtype_productCode} </div> <div class="r-search-field"> {$productCode_editcontrol} </div> <div class="r-search-field"> {$productCode_editcontrol1} </div> </div> {END productCode_fieldblock} {BEGIN quantityOrdered_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_quantityOrdered} r-horizontal-field form-horizontal" data-signal-error-for="quantityOrdered{$id}" data-itemtype="integrated_search_field" data-itemid="integrated_search_field2" {$item_integrated_search_field2}="" data-pageid="{$pageid}" data-field="quantityOrdered" data-fieldname="quantityOrdered" > <label class="r-search-label control-label" for="{$labelfor_quantityOrdered}"> {$label orderdetails quantityOrdered } </label> <div class="r-search-option"> {$searchtype_quantityOrdered} </div> <div class="r-search-field"> {$quantityOrdered_editcontrol} </div> <div class="r-search-field"> {$quantityOrdered_editcontrol1} </div> </div> {END quantityOrdered_fieldblock} {BEGIN priceEach_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_priceEach} r-horizontal-field form-horizontal" data-signal-error-for="priceEach{$id}" data-itemtype="integrated_search_field" data-itemid="integrated_search_field3" {$item_integrated_search_field3}="" data-pageid="{$pageid}" data-field="priceEach" data-fieldname="priceEach" > <label class="r-search-label control-label" for="{$labelfor_priceEach}"> {$label orderdetails priceEach } </label> <div class="r-search-option"> {$searchtype_priceEach} </div> <div class="r-search-field"> {$priceEach_editcontrol} </div> <div class="r-search-field"> {$priceEach_editcontrol1} </div> </div> {END priceEach_fieldblock} {BE... |
| #13 | classes/xtempl_base.php:812 | XTempl_Base->process_template | 0. <table data-body-align="center" data-location="grid" id="form_grid_{$pageid}" data-makeup="small" {$form_grid} data-pageid="{$pageid}" data-page="orderdetails_search" class="r-edit-form" cellpadding="0" cellspacing="0" {$grid_hiddenattr} data-form-width="1" data-v-width="6" > <tbody> <tr {$row_grid_0} > {BEGIN cellblock_grid_c3} <td {$cell_grid_c3} class=" r-ori-vert" data-fullwidth data-cellId="grid_c3" data-pageid="{$pageid}" data-v-cell="6" > <div edit-form-cell class="clearfix"> {BEGIN orderNumber_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_orderNumber} r-horizontal-field form-horizontal" data-signal-error-for="orderNumber{$id}" data-itemtype="integrated_search_field" data-itemid="integrated_search_field" {$item_integrated_search_field}="" data-pageid="{$pageid}" data-field="orderNumber" data-fieldname="orderNumber" > <label class="r-search-label control-label" for="{$labelfor_orderNumber}"> {$label orderdetails orderNumber } </label> <div class="r-search-option"> {$searchtype_orderNumber} </div> <div class="r-search-field"> {$orderNumber_editcontrol} </div> <div class="r-search-field"> {$orderNumber_editcontrol1} </div> </div> {END orderNumber_fieldblock} {BEGIN productCode_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_productCode} r-horizontal-field form-horizontal" data-signal-error-for="productCode{$id}" data-itemtype="integrated_search_field" data-itemid="integrated_search_field1" {$item_integrated_search_field1}="" data-pageid="{$pageid}" data-field="productCode" data-fieldname="productCode" > <label class="r-search-label control-label" for="{$labelfor_productCode}"> {$label orderdetails productCode } </label> <div class="r-search-option"> {$searchtype_productCode} </div> <div class="r-search-field"> {$productCode_editcontrol} </div> <div class="r-search-field"> {$productCode_editcontrol1} </div> </div> {END productCode_fieldblock} {BEGIN quantityOrdered_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_quantityOrdered} r-horizontal-field form-horizontal" data-signal-error-for="quantityOrdered{$id}" data-itemtype="integrated_search_field" data-itemid="integrated_search_field2" {$item_integrated_search_field2}="" data-pageid="{$pageid}" data-field="quantityOrdered" data-fieldname="quantityOrdered" > <label class="r-search-label control-label" for="{$labelfor_quantityOrdered}"> {$label orderdetails quantityOrdered } </label> <div class="r-search-option"> {$searchtype_quantityOrdered} </div> <div class="r-search-field"> {$quantityOrdered_editcontrol} </div> <div class="r-search-field"> {$quantityOrdered_editcontrol1} </div> </div> {END quantityOrdered_fieldblock} {BEGIN priceEach_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_priceEach} r-horizontal-field form-horizontal" data-signal-error-for="priceEach{$id}" data-itemtype="integrated_search_field" data-itemid="integrated_search_field3" {$item_integrated_search_field3}="" data-pageid="{$pageid}" data-field="priceEach&... |
| #14 | classes/xtempl_base.php:812 | XTempl_Base->process_template | 0. {$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-page="orderdetails_search" data-v-width="6" 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="search_header" data-itemid="search_header" {$item_search_header}="" data-pageid="{$pageid}" >{$pagetitlelabel orderdetails search}</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-page="orderdetails_search" data-v-width="6" 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 "> </div> </div> </div> {END above-grid_block} {BEGIN grid_block} <table data-body-align="center" data-location="grid" id="form_grid_{$pageid}" data-makeup="small" {$form_grid} data-pageid="{$pageid}" data-page="orderdetails_search" class="r-edit-form" cellpadding="0" cellspacing="0" {$grid_hiddenattr} data-form-width="1" data-v-width="6" > <tbody> <tr {$row_grid_0} > {BEGIN cellblock_grid_c3} <td {$cell_grid_c3} class=" r-ori-vert" data-fullwidth data-cellId="grid_c3" data-pageid="{$pageid}" data-v-cell="6" > <div edit-form-cell class="clearfix"> {BEGIN orderNumber_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_orderNumber} r-horizontal-field form-horizontal" data-signal-error-for="orderNumber{$id}" data-itemtype="integrated_search_field" data-itemid="integrated_search_field" {$item_integrated_search_field}="" data-pageid="{$pageid}" data-field="orderNumber" data-fieldname="orderNumber" > <label class="r-search-label control-label" for="{$labelfor_orderNumber}"> {$label orderdetails orderNumber } </label> <div class="r-search-option"> {$searchtype_orderNumber} </div> <div class="r-search-field"> {$orderNumber_editcontrol} </div> <div class="r-search-field"> {$orderNumber_editcontrol1} </div> </div> {END orderNumber_fieldblock} {BEGIN productCode_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_productCode} r-horizontal-field form-horizontal" data-signal-error-for="productCode{$id}" data-itemtype="integrated_search_field" data-itemid="integrated_search_field1" {$item_integrated_search_field1}="" data-pageid="{$pageid}" data-field="productCode" data-fieldname="productCode" > <label class="r-search-label control-label" for="{$labelfor_productCode}"> {$label orderdetails productCode } </label> <div class="r-search-option"> {$searchtype_productCode} </div> <div class="r-search-field"> ... |
| #15 | classes/xtempl_base.php:812 | XTempl_Base->process_template | 0. <!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}"> {BEGIN styleCSSFiles} <link REL="stylesheet" href="{$stylepath}" type="text/css"> {END styleCSSFiles} </head> <body class="{$stylename} function-search" {$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-page="orderdetails_search" data-v-width="6" 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="search_header" data-itemid="search_header" {$item_search_header}="" data-pageid="{$pageid}" >{$pagetitlelabel orderdetails search}</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-page="orderdetails_search" data-v-width="6" 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 "> </div> </div> </div> {END above-grid_block} {BEGIN grid_block} <table data-body-align="center" data-location="grid" id="form_grid_{$pageid}" data-makeup="small" {$form_grid} data-pageid="{$pageid}" data-page="orderdetails_search" class="r-edit-form" cellpadding="0" cellspacing="0" {$grid_hiddenattr} data-form-width="1" data-v-width="6" > <tbody> <tr {$row_grid_0} > {BEGIN cellblock_grid_c3} <td {$cell_grid_c3} class=" r-ori-vert" data-fullwidth data-cellId="grid_c3" data-pageid="{$pageid}" data-v-cell="6" > <div edit-form-cell class="clearfix"> {BEGIN orderNumber_fieldblock} <div class="r-integrated-field form-group clearfix {$fielddispclass_orderNumber} r-horizontal-field form-horizontal" data-signal-error-for="orderNumber{$id}" data-itemtype="integrated_search_field" data-itemid="integrated_search_field" {$item_integrated_search_field}="" data-pageid="{$pageid}" data-field="orderNumber" data-fieldname="orderNumber" > <label class="r-search-label control-label" for="{$labelfor_orderNumber}"> {$label orderdetails orderNumber } </label> <div class="r-search-option"> {$searchtype_orderNumber} </div> <div class="r-search-field"> {$orderNumber_editcontrol} </div> <div class="r-search-field"> {$orderNumber_editcontrol1} </div> </div> {END orderNumber_fieldblock} {BEGIN productCode_fieldblock} <div class="r-integrated-field form-group clearfix ... |
| #16 | include/xtempl.php:72 | XTempl->display | 0. orderdetails_search.htm |
| #17 | classes/runnerpage.php:5256 | RunnerPage->display | 0. orderdetails_search.htm |
| #18 | classes/searchpage.php:238 | SearchPage->displaySearchPage | N/A |
| #19 | classes/searchpage.php:96 | SearchPage->process | N/A |
| #20 | orderdetails_search.php:92 | Global scope | N/A |