First post so bear with me.
Magento 2.3.4
I was trying to figure out how to export products on a csv to alter the prices and import back in. I should have waited on my Developer but I found on Google – System – Data Transfer – Export.
So I went through this and exported a csv, had a look at it and thought no more of it.
Then when I went to save a product I am getting the – SQLSTATE[42000]: Syntax error or access violation: 1142 TRIGGER command denied to user
Full error reads
SQLSTATE[42000]: Syntax error or access violation: 1142 TRIGGER command denied to user ‘dev_newbyhouse’@’localhost’ for table ‘catalog_product_entity’, query was: UPDATE catalog_product_entity SET attribute_set_id = ?, type_id = ?, sku = ?, has_options = ?, required_options = ?, created_at = ?, updated_at = ?, mageworx_is_require = ?, mst_search_weight = ? WHERE (entity_id = ‘2217’)
So seems I have broke something
My hosting company restored a back up to the previous day when all was fine, but the error has stayed making me think it has triggered an issue on the server but the hosting company are saying they do not know and speak to a developer.
Configurable items wont save either, and when I go to cache management, there is just a white page with lots of weird code starting with
1 exception(s):
Exception #0 (MagentoFrameworkExceptionValidatorException): Invalid template file: ‘Magento_Backend::system/cache/additional.phtml’ in module: ‘Magento_Backend’ block’s name: ‘cache.additional’
Presuming all these issues are connected and I am now worried as a restore has not got rid of any of it.
