Error: Table 'xxxxxx.product_to_image' doesn't exist
Error No: 1146
DELETE FROM product_to_image WHERE product_id = '40'
http://localhost/admin/index.php?route=catalog/product
When I try to delete the default products I get the 1146 error. I searched for it in the forum and couldn't find anything.
In "admin/model/catalog/product.php", line 148, change from --
to
Code: Select all
$this->db->query("DELETE FROM product_to_image WHERE product_id = '" . (int)$product_id . "'");Code: Select all
$this->db->query("DELETE FROM product_image WHERE product_id = '" . (int)$product_id . "'");
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
hi, im having this error any body help?
Error: Table 'unlocks1_ocart.zone_to_geo_zone' doesn't exist
Error No: 1146
SELECT tr.tax_class_id, tr.rate AS rate, tr.description, tr.priority FROM tax_rate tr LEFT JOIN zone_to_geo_zone z2gz ON (tr.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN geo_zone gz ON (tr.geo_zone_id = gz.geo_zone_id) WHERE (z2gz.country_id = '0' OR z2gz.country_id = '222') AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3563') ORDER BY tr.priority ASC
Error: Table 'unlocks1_ocart.zone_to_geo_zone' doesn't exist
Error No: 1146
SELECT tr.tax_class_id, tr.rate AS rate, tr.description, tr.priority FROM tax_rate tr LEFT JOIN zone_to_geo_zone z2gz ON (tr.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN geo_zone gz ON (tr.geo_zone_id = gz.geo_zone_id) WHERE (z2gz.country_id = '0' OR z2gz.country_id = '222') AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3563') ORDER BY tr.priority ASC
Always mention version of your OpenCart!
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
Who is online
Users browsing this forum: Majestic-12 [Bot] and 80 guests
