[Skip to main content](#vessel-content) # Affiliates - Partners gives database error ## - **[jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")** - [![jouwnaambord.nl's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile") Topic Author - [ Offline](/forum/user/1188-jouwnaambord-nl) Less More - Posts: 515 - Thank you received: 22 - - 12 years 1 month ago - 12 years 1 month ago [\#170942](#170942) by [jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile") *[Affiliates - Partners gives database error](/forum/39-affilation/871014-affiliates-partners-gives-database-error#170942 "-- 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")* was created by *[jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")* -- 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 Last edit: 12 years 1 month ago by [jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM5LWFmZmlsYXRpb24vODcxMDE0LWFmZmlsaWF0ZXMtcGFydG5lcnMtZ2l2ZXMtZGF0YWJhc2UtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 12 years 1 month ago [\#170946](#170946) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Affiliates - Partners gives database error](/forum/39-affilation/871014-affiliates-partners-gives-database-error#170946 "-- 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, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM5LWFmZmlsYXRpb24vODcxMDE0LWFmZmlsaWF0ZXMtcGFydG5lcnMtZ2l2ZXMtZGF0YWJhc2UtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")** - [![jouwnaambord.nl's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile") Topic Author - [ Offline](/forum/user/1188-jouwnaambord-nl) Less More - Posts: 515 - Thank you received: 22 - - 12 years 1 month ago [\#170996](#170996) by [jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile") Replied by *[jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")* on topic *[Affiliates - Partners gives database error](/forum/39-affilation/871014-affiliates-partners-gives-database-error#170996 "-- 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM5LWFmZmlsYXRpb24vODcxMDE0LWFmZmlsaWF0ZXMtcGFydG5lcnMtZ2l2ZXMtZGF0YWJhc2UtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 12 years 1 month ago [\#170997](#170997) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Affiliates - Partners gives database error](/forum/39-affilation/871014-affiliates-partners-gives-database-error#170997 "-- 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, > 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](http://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, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM5LWFmZmlsYXRpb24vODcxMDE0LWFmZmlsaWF0ZXMtcGFydG5lcnMtZ2l2ZXMtZGF0YWJhc2UtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")** - [![jouwnaambord.nl's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile") Topic Author - [ Offline](/forum/user/1188-jouwnaambord-nl) Less More - Posts: 515 - Thank you received: 22 - - 12 years 1 month ago [\#171961](#171961) by [jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile") Replied by *[jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")* on topic *[Affiliates - Partners gives database error](/forum/39-affilation/871014-affiliates-partners-gives-database-error#171961 "-- 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, 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM5LWFmZmlsYXRpb24vODcxMDE0LWFmZmlsaWF0ZXMtcGFydG5lcnMtZ2l2ZXMtZGF0YWJhc2UtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 12 years 1 month ago [\#171967](#171967) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Affiliates - Partners gives database error](/forum/39-affilation/871014-affiliates-partners-gives-database-error#171967 "-- 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, 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, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM5LWFmZmlsYXRpb24vODcxMDE0LWFmZmlsaWF0ZXMtcGFydG5lcnMtZ2l2ZXMtZGF0YWJhc2UtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")** - [![jouwnaambord.nl's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile") Topic Author - [ Offline](/forum/user/1188-jouwnaambord-nl) Less More - Posts: 515 - Thank you received: 22 - - 12 years 1 month ago [\#172046](#172046) by [jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile") Replied by *[jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")* on topic *[Affiliates - Partners gives database error](/forum/39-affilation/871014-affiliates-partners-gives-database-error#172046 "-- 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, Ok, that did work, thanks! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM5LWFmZmlsYXRpb24vODcxMDE0LWFmZmlsaWF0ZXMtcGFydG5lcnMtZ2l2ZXMtZGF0YWJhc2UtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.092 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)