after that I get an error
Notice: Error: Table 'xxx.product_filter' doesn't exist
Error No: 1146
SELECT * FROM product_filter WHERE product_id = '2403' in /var/www/vhosts/arte-shop.gr/httpdocs/system/database/mysql.php on line 50
Only when I edit a product. If I only insert new product I can do it without any problem
I this is a missing table but I dont know how can I fix it.
Does anyone have a solution?
Thank you very much
Kostas
My Extensions - SuperTheme - Opencart templates - Opencart modules
kriti_kostas wrote:I fix it.
Do you think you could fix it for me also? I am having the same problem on my products page and on my categories page. I also have a script error showing up on my store front top right hand corner of window. I have written several people to get help....I really need help and would appreciate your response. Thanks!
Error No: 1146
SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '60' in E:\HostingSpaces\Marijnis1\golfersweb.nl\wwwroot\system\database\mysql.php on line 50
I can access my admin site, but the store is 'gone'
Please help me, I am trying to solve this already for a week now. Getting pretty desperate.
Code: Select all
CREATE TABLE `category_path` (
`category_id` int(11) NOT NULL,
`path_id` int(11) NOT NULL,
`level` int(11) NOT NULL,
PRIMARY KEY (`category_id`,`path_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
My Extensions - SuperTheme - Opencart templates - Opencart modules
Notice: Error: Table 'marijnisgolf.product_profile' doesn't exist
Error No: 1146
SELECT `pd`.* FROM `product_profile` `pp` JOIN `profile_description` `pd` ON `pd`.`language_id` = 2 AND `pd`.`profile_id` = `pp`.`profile_id` JOIN `profile` `p` ON `p`.`profile_id` = `pd`.`profile_id` WHERE `product_id` = 268 AND `status` = 1 AND `customer_group_id` = 1 ORDER BY `sort_order` ASC in E:\HostingSpaces\Marijnis1\golfersweb.nl\wwwroot\system\database\mysql.php on line 50
Do you have a SQL-query for the product path or can I change "category into product"?
does not contain any table prefixes compared with the inner joins. Each fields needs to be compared with tables in this case.WHERE `product_id` = 268 AND `status` = 1 AND `customer_group_id` = 1 ORDER BY `sort_order` ASC
The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.
Regards,
Straightlight
Programmer / Opencart Tester
replace:
Code: Select all
return $this->db->query("SELECT `pd`.* FROM `" . DB_PREFIX . "product_profile` `pp` JOIN `" . DB_PREFIX . "profile_description` `pd` ON `pd`.`language_id` = " . (int)$this->config->get('config_language_id') . " AND `pd`.`profile_id` = `pp`.`profile_id` JOIN `" . DB_PREFIX . "profile` `p` ON `p`.`profile_id` = `pd`.`profile_id` WHERE `product_id` = " . (int)$product_id . " AND `status` = 1 AND `customer_group_id` = " . (int)$customer_group_id . " ORDER BY `sort_order` ASC")->rows;
Code: Select all
return $this->db->query("SELECT `pd`.* FROM `" . DB_PREFIX . "product_profile` `pp` JOIN `" . DB_PREFIX . "profile_description` `pd` ON `pd`.`language_id` = " . (int)$this->config->get('config_language_id') . " AND `pd`.`profile_id` = `pp`.`profile_id` JOIN `" . DB_PREFIX . "profile` `p` ON `p`.`profile_id` = `pd`.`profile_id` WHERE `pp`.`product_id` = " . (int)$product_id . " AND `p`.`status` = 1 AND `pd`.`customer_group_id` = " . (int)$customer_group_id . " ORDER BY `p`.`sort_order` ASC")->rows;
The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.
Regards,
Straightlight
Programmer / Opencart Tester
Notice: Error: Table 'marijnisgolf.product_profile' doesn't exist
Error No: 1146
SELECT `pd`.* FROM `product_profile` `pp` JOIN `profile_description` `pd` ON `pd`.`language_id` = 2 AND `pd`.`profile_id` = `pp`.`profile_id` JOIN `profile` `p` ON `p`.`profile_id` = `pd`.`profile_id` WHERE `pp`.`product_id` = 279 AND `p`.`status` = 1 AND `pd`.`customer_group_id` = 1 ORDER BY `p`.`sort_order` ASC in E:\HostingSpaces\Marijnis1\golfersweb.nl\wwwroot\system\database\mysql.php on line 50
Somehow something went terrible wrong with updating Opencart to latest version. It would be appreciated if there is a solution to this problem.
Warning: mysql_query(): Unable to save result set in E:\HostingSpaces\Marijnis1\golfersweb.nl\wwwroot\system\database\mysql.php on line 22Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT keyword FROM url_alias WHERE query = 'product_id=192') AS keyword FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '192' AND pd.language_id = '2' in E:\HostingSpaces\Marijnis1\golfersweb.nl\wwwroot\system\database\mysql.php on line 50
I can not get to the products. help, help, help!
The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.
Regards,
Straightlight
Programmer / Opencart Tester
I am getting a error on my opencart website..! Like this " Notice: Error: Table 'niksm74m_opencart.od_' doesn't exist
Error No: 1146
SELECT * FROM od_`order` WHERE order_id='3' in /home/niksm74m/public_html/system/database/mysql.php on line 50 " i am completed with my whole website and now i am getting a error like this.. Please help me .!!! I have read many post..! I know youll are the best ..! Heance i have approached you all with my problem ..! Please help me with this problem with procedure how to do it.. I am using opencart v1.5.6 .! Help me at your earliest
Users browsing this forum: Google [Bot] and 26 guests