cancel
Showing results for 
Search instead for 
Did you mean: 

Error on try to view the product

Error on try to view the product

When i try to view the product on the main website i get the following SQL error

 

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'somaaiin_dev_db.Vicomage_blog_post_relatedproduct' doesn't exist, query was: SELECT COUNT(DISTINCT main_table.post_id) FROM `vicomage_blog_post` AS `main_table`
 LEFT JOIN `Vicomage_blog_post_relatedproduct` AS `rl` ON main_table.post_id = rl.post_id
 INNER JOIN `vicomage_blog_post_store` AS `store_table` ON main_table.post_id = store_table.post_id WHERE (`is_active` = '1') AND (`publish_time` <= '2017-07-26 06:26:53') AND (rl.related_id = '14') AND (store_table.store_id IN('1', 0))
Exception #1 (PDOException): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'somaaiin_dev_db.Vicomage_blog_post_relatedproduct' doesn't exist

 

I have used Vicomage theme. I dont know what fields are to be created if the table is missing 

1 REPLY 1

Re: Error on try to view the product

Hi @Faizan_5910,

 

Can you check if table Vicomage_blog_post_relatedproduct exists into your database?