| ( ! ) Fatal error: Uncaught Exception: Error: Table 'vermontsales_b2c_opencart.oc_event_location' doesn't exist<br />Error No: 1146<br />
SELECT
MAX(a.attribute_id) attribute_id,
MAX(ad.name) attribute_name,
MAX(pa.text) value,
COUNT(*) total
FROM `oc_product` p
LEFT JOIN `oc_product_attribute` pa ON (p.product_id = pa.product_id)
LEFT JOIN `oc_attribute` a ON (a.attribute_id = pa.attribute_id)
LEFT JOIN `oc_attribute_description` ad ON (ad.attribute_id = a.attribute_id)
LEFT JOIN `oc_product_to_category` p2c ON (p2c.product_id = p.product_id) LEFT JOIN `oc_category_path` cp ON (cp.category_id = p2c.category_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
LEFT JOIN `oc_product_event_setting` pes ON (p.product_id = pes.product_id)
LEFT JOIN `oc_event_location` el ON (el.event_location_id = pes.event_location_id)
WHERE
ifnull(p2s.status, in /home/vermontsales-b2c/www/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 201 |
|---|
| ( ! ) Exception: Error: Table 'vermontsales_b2c_opencart.oc_event_location' doesn't exist<br />Error No: 1146<br />
SELECT
MAX(a.attribute_id) attribute_id,
MAX(ad.name) attribute_name,
MAX(pa.text) value,
COUNT(*) total
FROM `oc_product` p
LEFT JOIN `oc_product_attribute` pa ON (p.product_id = pa.product_id)
LEFT JOIN `oc_attribute` a ON (a.attribute_id = pa.attribute_id)
LEFT JOIN `oc_attribute_description` ad ON (ad.attribute_id = a.attribute_id)
LEFT JOIN `oc_product_to_category` p2c ON (p2c.product_id = p.product_id) LEFT JOIN `oc_category_path` cp ON (cp.category_id = p2c.category_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
LEFT JOIN `oc_product_event_setting` pes ON (p.product_id = pes.product_id)
LEFT JOIN `oc_event_location` el ON (el.event_location_id = pes.event_location_id)
WHERE
ifnull(p2s.status, p.status) = '1'
AND ifnull(p2s.date_available, p.date_available) <= NOW()
AND p2s.store_id = '12'
AND pd.language_id = '1'
AND cp.path_id = '30427'AND ((p.is_accessory = 0 and p.is_spare =0)) AND (p.is_event = 0 OR (p.is_event = 1 AND pes.end_datetime >= NOW() ))
AND pa.language_id = '1'
AND ad.language_id = '1'
GROUP BY lower(pa.text), a.attribute_id
HAVING COUNT(*) > 0
in /home/vermontsales-b2c/www/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 201 |
|---|
| Call Stack |
|---|
| # | Time | Memory | Function | Location |
|---|
| 1 | 0.0001 | 399576 | {main}( ) | .../index.php:0 |
| 2 | 0.0483 | 22897408 | start( ) | .../index.php:26 |
| 3 | 0.0483 | 22899832 | require_once( '/home/vermontsales-b2c/www/vqmod/vqcache/vq2-system_framework.php' ) | .../vq2-system_startup.php:107 |
| 4 | 0.0522 | 23042856 | Router->dispatch( ) | .../vq2-system_framework.php:218 |
| 5 | 0.1519 | 25009976 | Router->execute( ) | .../vq2-system_engine_router.php:162 |
| 6 | 0.1519 | 25009976 | Action->execute( ) | .../vq2-system_engine_router.php:173 |
| 7 | 0.1520 | 25010968 | ControllerStartupRouter->index( ) | .../vq2-_home_vermontsales-b2c_env_storage_modification_system_engine_action.php:79 |
| 8 | 0.1522 | 25019408 | Action->execute( ) | .../router.php:25 |
| 9 | 0.1523 | 25020424 | ControllerProductCategory->index( ) | .../vq2-_home_vermontsales-b2c_env_storage_modification_system_engine_action.php:79 |
| 10 | 0.4410 | 27057832 | Loader->controller( ) | .../vq2-catalog_controller_product_category.php:1095 |
| 11 | 0.4413 | 27070736 | Action->execute( ) | .../vq2-_home_vermontsales-b2c_env_storage_modification_system_engine_loader.php:65 |
| 12 | 0.4413 | 27071752 | ControllerCommonColumnLeft->index( ) | .../vq2-_home_vermontsales-b2c_env_storage_modification_system_engine_action.php:79 |
| 13 | 0.4413 | 27071752 | Journal3->loadController( ) | .../vq2-catalog_controller_common_column_left.php:6 |
| 14 | 0.4414 | 27071752 | Loader->controller( ) | .../vq2-system_library_journal3.php:135 |
| 15 | 0.4416 | 27084648 | Action->execute( ) | .../vq2-_home_vermontsales-b2c_env_storage_modification_system_engine_loader.php:65 |
| 16 | 0.4424 | 27085024 | ControllerJournal3Layout->index( ) | .../vq2-_home_vermontsales-b2c_env_storage_modification_system_engine_action.php:79 |
| 17 | 0.4429 | 27086136 | ControllerJournal3Layout->renderGrid( ) | .../layout.php:226 |
| 18 | 0.4451 | 27115616 | Loader->controller( ) | .../controller.php:112 |
| 19 | 0.4453 | 27128528 | Action->execute( ) | .../vq2-_home_vermontsales-b2c_env_storage_modification_system_engine_loader.php:65 |
| 20 | 0.4470 | 27131488 | ControllerJournal3Filter->index( ) | .../vq2-_home_vermontsales-b2c_env_storage_modification_system_engine_action.php:79 |
| 21 | 0.4514 | 27132376 | ControllerJournal3Filter->beforeRender( ) | .../vq2-catalog_controller_journal3_filter.php:119 |
| 22 | 0.4580 | 27137704 | Proxy->getAttributes( ) | .../vq2-catalog_controller_journal3_filter.php:466 |
| 23 | 0.4580 | 27137760 | Proxy->__call( ) | .../vq2-catalog_controller_journal3_filter.php:466 |
| 24 | 0.4580 | 27138536 | Loader->{closure:/home/vermontsales-b2c/www/vqmod/vqcache/vq2-_home_vermontsales-b2c_env_storage_modification_system_engine_loader.php:239-281}( ) | .../proxy.php:47 |
| 25 | 0.4586 | 27139648 | ModelJournal3Filter->getAttributes( ) | .../vq2-_home_vermontsales-b2c_env_storage_modification_system_engine_loader.php:267 |
| 26 | 0.4592 | 27141240 | ModelJournal3Filter->dbQuery( ) | .../vq2-catalog_model_journal3_filter.php:1079 |
| 27 | 0.4593 | 27141912 | ModelJournal3Filter->dbQuery( ) | .../vq2-catalog_model_journal3_filter.php:2983 |