[Skip to main content](#vessel-content) # When I click on affiliate partner menu ## - **[Goyal](/forum/user/31372-goyal "View Goyal's Profile")** - [![Goyal's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31372-goyal "View Goyal's Profile") Topic Author - [ Offline](/forum/user/31372-goyal) Less More - Posts: 3 - Thank you received: 0 - - 12 years 8 months ago [\#145820](#145820) by [Goyal](/forum/user/31372-goyal "View Goyal's Profile") *[When I click on affiliate partner menu](/forum/39-affilation/866205-when-i-click-on-affiliate-partner-menu#145820 "Hello sir, -- url of the page with the problem -- : montrealsalsaconvention.com/administrator -- HikaShop version -- : HikaShop Business 2.2.2 -- Joomla version -- : Joomla! 3.0.4 -- PHP version -- : 5.3.24 -- Browser(s) name and version -- : google chrome 33.0.1750 -- Error-message(debug-mod must be tuned on) -- : 1347 'salsa123.zxnyw_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW zxnyw_hikashop_sale_view AS SELECT a.user_id, SUM(b.order_partner_price) AS sale_price FROM zxnyw_hikashop_user AS a LEFT JOIN zxnyw_hikashop_order AS b ON a.user_id=b.order_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 5 ELSE a.user_currency_id END)=b.order_partner_currency_id WHERE a.user_partner_activated=1 AND b.order_partner_paid=0 AND b.order_type='sale' AND b.order_status IN ('confirmed','shipped') GROUP BY b.order_partner_id; When i am login in montrealsalsaconvention.com/administrator and open hikashop---> affiliates---> partners It Give me Error Like this Can you Help me plz ???? 1347 'salsa123.zxnyw_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW zxnyw_hikashop_sale_view AS SELECT a.user_id, SUM(b.order_partner_price) AS sale_price FROM zxnyw_hikashop_user AS a LEFT JOIN zxnyw_hikashop_order AS b ON a.user_id=b.order_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 5 ELSE a.user_currency_id END)=b.order_partner_currency_id WHERE a.user_partner_activated=1 AND b.order_partner_paid=0 AND b.order_type='sale' AND b.order_status IN ('confirmed','shipped') GROUP BY b.order_partner_id; Thank You jitendra Goyal")* was created by *[Goyal](/forum/user/31372-goyal "View Goyal's Profile")* Hello sir, -- url of the page with the problem -- : [ montrealsalsaconvention.com/administrator](http://montrealsalsaconvention.com/administrator) -- HikaShop version -- : HikaShop Business 2.2.2 -- Joomla version -- : Joomla! 3.0.4 -- PHP version -- : 5.3.24 -- Browser(s) name and version -- : google chrome 33.0.1750 -- Error-message(debug-mod must be tuned on) -- : 1347 'salsa123.zxnyw_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW zxnyw_hikashop_sale_view AS SELECT a.user_id, SUM(b.order_partner_price) AS sale_price FROM zxnyw_hikashop_user AS a LEFT JOIN zxnyw_hikashop_order AS b ON a.user_id=b.order_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 5 ELSE a.user_currency_id END)=b.order_partner_currency_id WHERE a.user_partner_activated=1 AND b.order_partner_paid=0 AND b.order_type='sale' AND b.order_status IN ('confirmed','shipped') GROUP BY b.order_partner_id; When i am login in [ montrealsalsaconvention.com/administrator](http://montrealsalsaconvention.com/administrator) and open hikashop---> affiliates---> partners It Give me Error Like this Can you Help me plz ???? 1347 'salsa123.zxnyw_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW zxnyw_hikashop_sale_view AS SELECT a.user_id, SUM(b.order_partner_price) AS sale_price FROM zxnyw_hikashop_user AS a LEFT JOIN zxnyw_hikashop_order AS b ON a.user_id=b.order_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 5 ELSE a.user_currency_id END)=b.order_partner_currency_id WHERE a.user_partner_activated=1 AND b.order_partner_paid=0 AND b.order_type='sale' AND b.order_status IN ('confirmed','shipped') GROUP BY b.order_partner_id; Thank You jitendra Goyal Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM5LWFmZmlsYXRpb24vODY2MjA1LXdoZW4taS1jbGljay1vbi1hZmZpbGlhdGUtcGFydG5lci1tZW51P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 12 years 8 months ago [\#146001](#146001) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[When I click on affiliate partner menu](/forum/39-affilation/866205-when-i-click-on-affiliate-partner-menu#146001 "Hello sir, -- url of the page with the problem -- : montrealsalsaconvention.com/administrator -- HikaShop version -- : HikaShop Business 2.2.2 -- Joomla version -- : Joomla! 3.0.4 -- PHP version -- : 5.3.24 -- Browser(s) name and version -- : google chrome 33.0.1750 -- Error-message(debug-mod must be tuned on) -- : 1347 'salsa123.zxnyw_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW zxnyw_hikashop_sale_view AS SELECT a.user_id, SUM(b.order_partner_price) AS sale_price FROM zxnyw_hikashop_user AS a LEFT JOIN zxnyw_hikashop_order AS b ON a.user_id=b.order_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 5 ELSE a.user_currency_id END)=b.order_partner_currency_id WHERE a.user_partner_activated=1 AND b.order_partner_paid=0 AND b.order_type='sale' AND b.order_status IN ('confirmed','shipped') GROUP BY b.order_partner_id; When i am login in montrealsalsaconvention.com/administrator and open hikashop---> affiliates---> partners It Give me Error Like this Can you Help me plz ???? 1347 'salsa123.zxnyw_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW zxnyw_hikashop_sale_view AS SELECT a.user_id, SUM(b.order_partner_price) AS sale_price FROM zxnyw_hikashop_user AS a LEFT JOIN zxnyw_hikashop_order AS b ON a.user_id=b.order_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 5 ELSE a.user_currency_id END)=b.order_partner_currency_id WHERE a.user_partner_activated=1 AND b.order_partner_paid=0 AND b.order_type='sale' AND b.order_status IN ('confirmed','shipped') GROUP BY b.order_partner_id; Thank You jitendra Goyal")* Hi, This is because your MySQL user doesn't have the right to create views in your database. Please contact your hosting company about that and they should be able to add that right. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM5LWFmZmlsYXRpb24vODY2MjA1LXdoZW4taS1jbGljay1vbi1hZmZpbGlhdGUtcGFydG5lci1tZW51P3RtcGw9bWFya2Rvd24=) 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.123 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)