Affiliates - Partners gives database error

-- HikaShop version -- : com_hikashop_business_v2.3.2_2014-09-11_14-48-58
-- Joomla version -- : 3.3.3
-- PHP version -- : 5.4.25-1
-- Browser(s) name and version -- : Firefox 31.0
-- Error-message(debug-mod must be tuned on) -- : 1142 CREATE VIEW command denied to user 'printopl'@'localhost' for table 'mpw_hikashop_click_view' SQL=CREATE OR REPLACE VIEW mpw_hikashop_click_view AS SELECT a.user_id, SUM(b.click_partner_price) AS click_price FROM mpw_hikashop_user AS a LEFT JOIN mpw_hikashop_click AS b ON a.user_id=b.click_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 1 ELSE a.user_currency_id END)=b.click_partner_currency_id WHERE a.user_partner_activated=1 AND b.click_partner_paid=0 GROUP BY b.click_partner_id;

If I click on "affiliates" - "Partners" I get this error. Can't find whats causing this error. The databasecheck gives "OK".

BR
Michel Pouli

Hi Jerome,

Sorry for this. My explanation was not complete. I know what the errorcode means. But that's not the issue. I have all the rights. All the other view requests are handled correctly, only this one isn't. I tried to find some error in the database, but couldn't find any.

Michel.

Hi,

Ok, rights are all assigned, now the error is this one:

'printopl-2.mpw_hikashop_click_view' is not VIEW SQL=CREATE OR REPLACE VIEW mpw_hikashop_click_view AS SELECT a.user_id, SUM(b.click_partner_price) AS click_price FROM mpw_hikashop_user AS a LEFT JOIN mpw_hikashop_click AS b ON a.user_id=b.click_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 1 ELSE a.user_currency_id END)=b.click_partner_currency_id WHERE a.user_partner_activated=1 AND b.click_partner_paid=0 GROUP BY b.click_partner_id;

Regards

Hi,

Ok, that did work, thanks!