[Skip to main content](#vessel-content) # Affiliate Partner error ## - **[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 [\#146350](#146350) by [Goyal](/forum/user/31372-goyal "View Goyal's Profile") *[Affiliate Partner error](/forum/25-install-update/866295-affiliate-partner-error#146350 "Hello sir, I am configure whole site on my localhost also i ma getting this error . when i copy this sql query and run in my sql command then give a result to me . can you give me help for that ???????// i ask two question on that but i am not getting better reply. -- 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, I am configure whole site on my localhost also i ma getting this error . when i copy this sql query and run in my sql command then give a result to me . can you give me help for that ???????// i ask two question on that but i am not getting better reply. -- 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NjI5NS1hZmZpbGlhdGUtcGFydG5lci1lcnJvcj90bXBsPW1hcmtkb3du) 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 7 months ago [\#146462](#146462) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Affiliate Partner error](/forum/25-install-update/866295-affiliate-partner-error#146462 "Hello sir, I am configure whole site on my localhost also i ma getting this error . when i copy this sql query and run in my sql command then give a result to me . can you give me help for that ???????// i ask two question on that but i am not getting better reply. -- 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. If you're in local, please open your phpmyadmin with the root account and edit the privileges of the mysql user you're using for your website and make sure that it has the rights to create/alter/delete/select views and you should then not have the error anymore. I checked the two other questions you asked and we replied as best as we could as far as I can see. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NjI5NS1hZmZpbGlhdGUtcGFydG5lci1lcnJvcj90bXBsPW1hcmtkb3du) 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.128 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)