Notice: Error: Can't create table 'oc_af_tax_fixed' (errno: 30) Error No: 1005 CREATE TEMPORARY TABLE IF NOT EXISTS `oc_af_tax_fixed` (PRIMARY KEY (`tax_class_id`)) AS (SELECT tr1.tax_class_id, sum(tr2.rate) as sum_rate
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2
ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg
ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz
ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz
ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr2.type='F'
AND tr2cg.customer_group_id = '1'
AND ( (
`tr1`.`based` = 'store' AND
`z2gz`.`country_id` = 99 AND (
`z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0'
)
) OR (
`tr1`.`based` = 'payment' AND
`z2gz`.`country_id` = 99 AND (
`z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0'
)
) OR (
`tr1`.`based` = 'shipping' AND
`z2gz`.`country_id` = 99 AND (
`z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0'
)
) )
GROUP BY tr1.tax_class_id) in /home/vishalprints/public_html/system/library/db/mysqli.php on line 41Notice: Error: Can't create table 'oc_af_tax_percent' (errno: 30) Error No: 1005 CREATE TEMPORARY TABLE IF NOT EXISTS `oc_af_tax_percent` (PRIMARY KEY (`tax_class_id`)) AS (SELECT tr1.tax_class_id, sum(tr2.rate) as sum_rate
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2
ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg
ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz
ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz
ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr2.type='P'
AND tr2cg.customer_group_id = '1'
AND ( (
`tr1`.`based` = 'store' AND
`z2gz`.`country_id` = 99 AND (
`z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0'
)
) OR (
`tr1`.`based` = 'payment' AND
`z2gz`.`country_id` = 99 AND (
`z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0'
)
) OR (
`tr1`.`based` = 'shipping' AND
`z2gz`.`country_id` = 99 AND (
`z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0'
)
) )
GROUP BY tr1.tax_class_id) in /home/vishalprints/public_html/system/library/db/mysqli.php on line 41Notice: Error: Table 'vishalpr_vp_oc.oc_af_tax_fixed' doesn't exist Error No: 1146 CREATE TEMPORARY TABLE IF NOT EXISTS `oc_af_temporary` (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.manufacturer_id, IF(p.quantity > 0, 6, p.stock_status_id) as stock_status_id, MIN(pd2.price) as discount, MIN(ps.price) as special, tax_p.sum_rate as tax_precent, tax_f.sum_rate as tax_fixed, AVG(rating) AS rating FROM oc_product p LEFT JOIN `oc_af_tax_fixed` tax_f ON p.tax_class_id = tax_f.tax_class_id LEFT JOIN `oc_af_tax_percent` tax_p ON p.tax_class_id = tax_p.tax_class_id INNER JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN oc_product_discount pd2 ON (pd2.product_id = p.product_id AND pd2.quantity = '1' AND (pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()) AND pd2.customer_group_id = '1') LEFT JOIN oc_product_special ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1') LEFT JOIN oc_review r1 ON (r1.product_id = p.product_id AND r1.status = 1) INNER JOIN oc_product_to_store AS p2s ON
p2s.product_id = p.product_id AND p2s.store_id = '0' WHERE p.date_available <= NOW() AND p.status = 1 AND p2c.category_id = '148' GROUP BY p.product_id in /home/vishalprints/public_html/system/library/db/mysqli.php on line 41Notice: Error: Table 'vishalpr_vp_oc.oc_af_temporary' doesn't exist Error No: 1146 SELECT count(p.product_id) as total
FROM (SELECT aft.* , ((IFNULL(aft.special, IFNULL(aft.discount, p2.price)))*(1+IFNULL(aft.tax_precent,0)/100)+IFNULL(aft.tax_fixed, 0)) as af_price FROM `oc_af_temporary` aft
INNER JOIN `oc_product` p2 ON aft.product_id = p2.product_id GROUP BY aft.product_id ) aft
INNER JOIN `oc_product` p ON aft.product_id = p.product_id in /home/vishalprints/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property 'row' of non-object in /home/vishalprints/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 775Notice: Error: Table 'vishalpr_vp_oc.oc_af_temporary' doesn't exist Error No: 1146 SELECT p.product_id, aft.rating, aft.discount, aft.special
FROM (SELECT aft.* , ((IFNULL(aft.special, IFNULL(aft.discount, p2.price)))*(1+IFNULL(aft.tax_precent,0)/100)+IFNULL(aft.tax_fixed, 0)) as af_price FROM `oc_af_temporary` aft
INNER JOIN `oc_product` p2 ON aft.product_id = p2.product_id GROUP BY aft.product_id ) aft
INNER JOIN `oc_product` p ON aft.product_id = p.product_id
INNER JOIN `oc_product_description` pd ON pd.product_id = p.product_id
WHERE pd.language_id = '1' GROUP BY p.product_id ORDER BY p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,30 in /home/vishalprints/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property 'rows' of non-object in /home/vishalprints/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 233Warning: Invalid argument supplied for foreach() in /home/vishalprints/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 233Notice: Error: Table 'vishalpr_vp_oc.oc_af_temporary' doesn't exist Error No: 1146 SELECT count(`product_id`) as total FROM `oc_af_temporary` in /home/vishalprints/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property 'row' of non-object in /home/vishalprints/public_html/catalog/model/extension/d_ajax_filter/search.php on line 19Notice: Error: Table 'vishalpr_vp_oc.oc_af_temporary' doesn't exist Error No: 1146 SELECT min(p.af_price) as min, max(p.af_price) as max
FROM (SELECT aft.* , ((IFNULL(aft.special, IFNULL(aft.discount, p2.price)))*(1+IFNULL(aft.tax_precent,0)/100)+IFNULL(aft.tax_fixed, 0)) as af_price FROM `oc_af_temporary` aft
INNER JOIN `oc_product` p2 ON aft.product_id = p2.product_id GROUP BY aft.product_id ) p in /home/vishalprints/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property 'row' of non-object in /home/vishalprints/public_html/catalog/model/extension/d_ajax_filter/price.php on line 33Notice: Error: Table 'vishalpr_vp_oc.oc_af_temporary' doesn't exist Error No: 1146 SELECT f.filter_id, fd.name as filter_name, aff.image, f.filter_group_id, fgd.name as filter_group_name
FROM `oc_filter` f
LEFT JOIN `oc_af_filter` aff ON aff.filter_id = f.filter_id AND aff.language_id = '1'
INNER JOIN `oc_filter_description` fd ON fd.filter_id = f.filter_id AND fd.language_id = '1'
INNER JOIN `oc_filter_group` fg ON fg.filter_group_id = f.filter_group_id
INNER JOIN `oc_filter_group_description` fgd ON fgd.filter_group_id = f.filter_group_id AND fgd.language_id = '1'
WHERE f.filter_id IN(
SELECT pf.filter_id
FROM `oc_product_filter` pf
INNER JOIN `oc_af_temporary` aft ON aft.product_id = pf.product_id
) GROUP BY f.filter_id ORDER BY fg.sort_order, f.sort_order in /home/vishalprints/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property 'rows' of non-object in /home/vishalprints/public_html/catalog/model/extension/d_ajax_filter/filter.php on line 31Notice: Error: Table 'vishalpr_vp_oc.oc_af_temporary' doesn't exist Error No: 1146 SELECT a.attribute_id, ad.name FROM `oc_product_attribute` pa INNER JOIN `oc_af_temporary` aft ON aft.product_id = pa.product_id LEFT JOIN `oc_attribute` a ON pa.attribute_id = a.attribute_id LEFT JOIN `oc_attribute_description` ad ON a.attribute_id = ad.attribute_id WHERE ad.language_id = '1' GROUP BY pa.attribute_id ORDER BY a.sort_order ASC in /home/vishalprints/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property 'rows' of non-object in /home/vishalprints/public_html/catalog/model/extension/d_ajax_filter/attribute.php on line 20By Style
0
