I update the e-shop from version 1.5.4 to 1.5.6
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
Seems like you didnt run the upgrade script or maybe it failed, try rerunning it if the upgrade script allows you by going to yoursite.com/install
It doesnt let me to rerun it and the problem still exist? It would be usefull if I do a downgrade and upagrade again?
Hello. I'm having the exact same issue as you with "Error No: 1146." Can you tell me how you resolved this? I'm tempted to de-install and then re-install but I don't want to loose my previous work done before the upgrade. Thanks in advance for your help!!!
I found another e-shop that I have made with version 1.5.5.1 and I create the table (product_filter) that I have problem exactly the same and worked without doing anything more special. I hope this will help you.
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!
Hi, I get also error no 1146 after an update:Notice: Error: Table 'marijnisgolf.category_path' doesn't exist
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.
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.
Try ading the table yourself then, in phpmyadmin select the database of your store and in the sql tab run the query:
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;
Thanks, this is working, but now I get the same error for the product.
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"?
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
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
In catalog/model/catalog/product.php file,
replace:
with:
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;
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Thanks for the help, but now I get an other error:
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.
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.
Help, my webshop is completely messed up after updating. In the admin side I get the following errror.
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!
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!
If the profile table does not exist, then it means your last upgrade process has failed to complete. Restore backup and try the upgrade again. If issue persists, it means that your browser loads too many data at the time and the processed time period has been exceeded by your server.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Error 1146 table
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
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
Who is online
Users browsing this forum: Semrush [Bot] and 102 guests
