|
| Technical information |
| Error type | 256 |
| Error description | Unknown column 'category_id' in 'field list' |
| URL | tamisglassart.com/shopinventory_list.php? |
| Error file | /var/www/localhost/tamisartglasscompany.com/connections/Connection.php |
| Error line | 668 |
| SQL query | select count(*) from (select
`item`, `item_description`, `extended_description`, `picture`, `th_picture`, `category_id`, `available_from`, `available_to`, `istatus`, `weight`, `freight_amt`, `vendor_id`, `vendor_item_id`, `list_price`, `price1_qty`, `price1`, `price2_qty`, `price2`, `price3_qty`, `price3`, `item_cost`, `taxable`, `on_hand_qty`-`openorder_qty`-`placedbutnotshipped_qty` as `available`, `update_by`, `update_date`, "" as `addtocart`, `Depth`, `Depth_UOM`, `Gallery`, `length`, `length_UOM`, `Location`, `on_hand_qty`, `minimalqty`, `openorder_qty`, `placedbutnotshipped_qty`, `Technique`, `Show_In_Gallery`, `Show_For_Sale`, `weight_UOM`, `width`, `Width_UOM`, `Artist`, `Artist_Name`, `Availability`, `ID`
FROM `shopinventory` WHERE ( ( ( ( `item` is null or `item` = '' ) or ( `item` > '' ) or ( `item`='' ) or ( `item` < '' ) ) ) ) and ( `istatus` ='A' ) ) a |
| #0 |
connections/Connection.php:668 |
Connection->triggerError |
0. Unknown column 'category_id' in 'field list' |
| #1 |
connections/MySQLiConnection.php:173 |
MySQLiConnection->query |
0. select count(*) from (select
`item`, `item_description`, `extended_description`, `picture`, `th_picture`, `category_id`, `available_from`, `available_to`, `istatus`, `weight`, `freight_amt`, `vendor_id`, `vendor_item_id`, `list_price`, `price1_qty`, `price1`, `price2_qty`, `price2`, `price3_qty`, `price3`, `item_cost`, `taxable`, `on_hand_qty`-`openorder_qty`-`placedbutnotshipped_qty` as `available`, `update_by`, `update_date`, "" as `addtocart`, `Depth`, `Depth_UOM`, `Gallery`, `length`, `length_UOM`, `Location`, `on_hand_qty`, `minimalqty`, `openorder_qty`, `placedbutnotshipped_qty`, `Technique`, `Show_In_Gallery`, `Show_For_Sale`, `weight_UOM`, `width`, `Width_UOM`, `Artist`, `Artist_Name`, `Availability`, `ID`
FROM `shopinventory` WHERE ( ( ( ( `item` is null or `item` = '' ) or ( `item` > '' ) or ( `item`='' ) or ( `item` < '' ) ) ) ) and ( `istatus` ='A' ) ) a |
| #2 |
connections/Connection.php:635 |
Connection->getFetchedRowsNumber |
0. select
`item`, `item_description`, `extended_description`, `picture`, `th_picture`, `category_id`, `available_from`, `available_to`, `istatus`, `weight`, `freight_amt`, `vendor_id`, `vendor_item_id`, `list_price`, `price1_qty`, `price1`, `price2_qty`, `price2`, `price3_qty`, `price3`, `item_cost`, `taxable`, `on_hand_qty`-`openorder_qty`-`placedbutnotshipped_qty` as `available`, `update_by`, `update_date`, "" as `addtocart`, `Depth`, `Depth_UOM`, `Gallery`, `length`, `length_UOM`, `Location`, `on_hand_qty`, `minimalqty`, `openorder_qty`, `placedbutnotshipped_qty`, `Technique`, `Show_In_Gallery`, `Show_For_Sale`, `weight_UOM`, `width`, `Width_UOM`, `Artist`, `Artist_Name`, `Availability`, `ID`
FROM `shopinventory` WHERE ( ( ( ( `item` is null or `item` = '' ) or ( `item` > '' ) or ( `item`='' ) or ( `item` < '' ) ) ) ) and ( `istatus` ='A' ) |
| #3 |
classes/datasource/table.php:621 |
DataSourceTable->getCount |
0. DsCommand |
| #4 |
classes/listpage.php:2799 |
ListPage->calculateRecordCount |
N/A |
| #5 |
classes/listpage.php:2204 |
ListPage->prepareForBuildPage |
N/A |
| #6 |
shopinventory_list.php:158 |
Global scope |
N/A |