Tygh\Exceptions\AException

Message

View 'dosiin.dsv0201_products_prices_live' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)

SELECT SQL_CALC_FOUND_ROWS products.product_id, live_products.amount, products.product_code, products.product, live_products.price, products.sticker, products.company_id, products.company, products.main_pair, products.list_price, products.category_id, products.percent_discount, products.seo_name, products.verify, products.sold, products.view, products.seo_name_company, products.average_rating, products.posts_count FROM dsv0201_products_tabview as products INNER JOIN dsv0201_products_prices_live as live_products ON live_products.product_id = products.product_id WHERE 1 AND products.category_id IN (64) AND live_products.status = "A" AND live_products.amount > 0 AND products.type_category IS NOT NULL GROUP BY products.product_id ORDER BY products.timestamp desc, products.product_id ASC LIMIT 0, 10

Error at

app/Tygh/Database/Connection.php, line: 1130

Backtrace

File:app/Tygh/Database/Connection.php
Line:491
Function:throwError
File:app/Tygh/Database/Connection.php
Line:224
Function:query
File:app/functions/fn.databaseDS.php
Line:31
Function:getArray
File:app/addons/dosi_in_function_ver_1/func.php
Line:3603
Function:db_get_array
File:app/functions/fn.catalogDS.php
Line:8918
Function:fn_get_products_tabview
File:app/controllers/frontend/categories.php
Line:51
Function:fn_get_products
File:app/functions/fn.controlDS.php
Line:713
Function:include
File:app/functions/fn.controlDS.php
Line:441
Function:fn_run_controller
File:index.php
Line:44
Function:fn_dispatch