Database error: 145 : Table './admin_allhdd/cscart_product_prices' is marked as crashed and should be repaired
Invalid query: SELECT COUNT(DISTINCT(products.product_id)) FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id=products.product_id AND descr1.lang_code='EN' LEFT JOIN cscart_product_prices as prices ON prices.product_id=products.product_id AND prices.lower_limit='1'INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id=products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id=products_categories.category_id AND cscart_categories.membership_id IN ('0', '0') AND cscart_categories.avail IN ('Y','H') AND products.avail IN ('Y') WHERE 1 AND prices.membership_id IN ('0', '0') AND cscart_categories.category_id='51'
Backtrace:
| File: | /home2/admin/public_html/index.php |
| Line: | 86 |
| Function: | include |
| File: | /home2/admin/public_html/targets/categories.php |
| Line: | 36 |
| Function: | include |
| File: | /home2/admin/public_html/include/customer/categories.php |
| Line: | 139 |
| Function: | include |
| File: | /home2/admin/public_html/include/common/search_products.php |
| Line: | 398 |
| Function: | include |
| File: | /home2/admin/public_html/include/common/search_products_generic.php |
| Line: | 80 |
| Function: | db_get_field |
| File: | /home2/admin/public_html/core/fn_database.php |
| Line: | 92 |
| Function: | db_query |
| File: | /home2/admin/public_html/core/db_mysql.php |
| Line: | 94 |
| Function: | db_debug_error |