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,

Your database user you're using does not have right to create a view.
It is a mysql permission problem that you should see with your web hosting or configure in your "phpmyadmin".

Regards,

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,

CREATE VIEW command denied to user 'printopl'@'localhost' for table 'mpw_hikashop_click_view'

That is the error message and the solution.
It is not a table, it is a VIEW
dev.mysql.com/doc/refman/5.0/en/views.html

So, please read my message and my solution.
You don't have all the rights/permissions otherwise you won't have such error message from your mysql server.

Regards,

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,

Once again, the solution is in the error message.

'printopl-2.mpw_hikashop_click_view' is not VIEW

I guess that you have created the table manually ; but you created a table and it requires a view.
So please, delete this table and let the HikaShop affiliate plugin create the correct view.

Regards,

Hi,

Ok, that did work, thanks!