[Skip to main content](#vessel-content)
# Profile for Goyal
##
[](/forum/user/31372-goyal "View Goyal's Profile")
**[ Offline](/forum/user/31372-goyal)**
- **User Type:** User
- **Register Date:** 26 Feb 2014
- **Last login:** 12 years 8 months ago
- **Time Zone:** UTC +0:00
- **Local Time:** 17:48
- **Posts:** 3
- **Profile views:** 122
- **Gender:** Unknown
- **Birthdate:** Unknown
- Posts
# Goyal's recent posts (3 messages )
All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year
| [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) |
|---|---|---|---|---|
| [](/forum/25-install-update/866295-affiliate-partner-error#146350) | [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") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 8 months ago, by [Goyal](/forum/user/31372-goyal "View Goyal's Profile") [Last Post](/forum/25-install-update/866295-affiliate-partner-error#146462 "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.") 12 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:748 | [Last Post](/forum/25-install-update/866295-affiliate-partner-error#146462 "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.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 12 years 7 months ago |
| [](/forum/29-payment-methods/866290-when-i-am-redirect-on-paypal-form-then-it-display#146333) | [When I am Redirect on Paypal form then it display](/forum/29-payment-methods/866290-when-i-am-redirect-on-paypal-form-then-it-display#146333 "-- url of the page with the problem -- : www.montrealsalsaconvention.com/ -- HikaShop version -- : HikaShop Business 2.2.2, -- Joomla version -- : 3.0.4 -- PHP version -- : 5.4.22 -- Browser(s) name and version -- : google crome -- Error-message(debug-mod must be tuned on) -- : When I am Redirect on Paypal form then it display Email ID of the marchant I want to display Store name In place of email is it possible ??? plz help me ... Thank You in Advance") Category: [Payment Methods](/forum/29-payment-methods "Discussions about the different payment methods for Hikashop") Topic started 12 years 8 months ago, by [Goyal](/forum/user/31372-goyal "View Goyal's Profile") [Last Post](/forum/29-payment-methods/866290-when-i-am-redirect-on-paypal-form-then-it-display#146346 "Hi, I think that you should directly ask it to PayPal so that they can help you to customize your merchant payment interface.") 12 years 8 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:1 Views:471 | [Last Post](/forum/29-payment-methods/866290-when-i-am-redirect-on-paypal-form-then-it-display#146346 "Hi, I think that you should directly ask it to PayPal so that they can help you to customize your merchant payment interface.") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 12 years 8 months ago |
| [](/forum/39-affilation/866205-when-i-click-on-affiliate-partner-menu#145820) | [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") Category: [Affilation](/forum/39-affilation "Discussions related to the Affiliation system") Topic started 12 years 8 months ago, by [Goyal](/forum/user/31372-goyal "View Goyal's Profile") [Last Post](/forum/39-affilation/866205-when-i-click-on-affiliate-partner-menu#146001 "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.") 12 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1 Views:1719 | [Last Post](/forum/39-affilation/866205-when-i-click-on-affiliate-partner-menu#146001 "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.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 12 years 8 months ago |
[](/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)