Can't reach product populated pages due to error "SQLSTATE[42S02]"

[liam_eagles1]

When trying to look at any of my websites pages that have prices on them I get the following error message: 

SQLSTATE[42S02]: Base table or view not found: 1932 Table 'bms_live.pricing_customer_volume_discount' doesn't exist in engine, query was: SELECT `main_table`.* FROM `pricing_customer_volume_discount` AS `main_table` WHERE (`customer_id` = '') AND (`charge_group` = 'D2') AND (`current_flag` = '1')

Do I just need to add the table it can't find or remove every query that requests that table??

Thanks,

Liam 

[gelanivishal]

Hello @liam_eagles1,

Have you got this error after installed any third party extension?

If yes then please find extension setup name on core_resource table and remove that entry and also disable cache. In case of, if you have upgrade extension then you need to downgrade in core_resource table.

After try to run frontend side. I hope that issue will be resolved.

Thank you.

--
If issue is solved, Click "Kudos" & "Accept as Solution"

[liam_eagles1]

Hi @gelanivishal
No third party software has been installed.
We have however just had the whole database copied and started hosting ourselves instead of a third party company.
Is it possible the table could have fallen off during the copy of the data??

[gelanivishal]

Yes. That might be create an issue.

Thank yo.