Hika shop Affiliate Partner error..urgently need t

  • Posts: 2
  • Thank you received: 0
10 years 2 months ago #169416

-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.2.3
-- Error-message(debug-mod must be tuned on) -- : An error has occurred.
1347 'fghjh_fgfh.kb7ao_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW................

An error has occurred.
1347 'fghjh_fgfh.kb7ao_hikashop_sale_view' is not VIEW SQL=CREATE OR REPLACE VIEW................

Last edit: 10 years 2 months ago by nindrakumari99.

Please Log in or Create an account to join the conversation.

  • Posts: 26156
  • Thank you received: 4028
  • MODERATOR
10 years 2 months ago #169437

Hi,

Please delete your table "fghjh_fgfh.kb7ao_hikashop_sale_view" in order to let HikaShop recreate it, as a view and not as a table.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 2
  • Thank you received: 0
10 years 2 months ago #169467

Hi
I have deleted this table fghjh_fgfh.kb7ao_hikashop_sale_view

Now getting this error
fghjh_fgfh.kb7ao_hikashop_lead_view' is not VIEW SQL=CREATE OR REPLACE VIEW kb7ao_hikashop_lead_view AS SELECT a.user_id, SUM(b.user_partner_price) AS lead_price FROM kb7ao_hikashop_user AS a LEFT JOIN kb7ao_hikashop_user AS b ON a.user_id=b.user_partner_id AND (CASE WHEN a.user_currency_id=0 THEN 6 ELSE a.user_currency_id END)=b.user_partner_currency_id WHERE a.user_partner_activated=1 AND b.user_partner_paid=0 GROUP BY b.user_partner_id;

Could you help me out why is this happening?

Please Log in or Create an account to join the conversation.

  • Posts: 82823
  • Thank you received: 13370
  • MODERATOR
10 years 2 months ago #169519

Hi,

Delete also kb7ao_hikashop_lead_view and kb7ao_hikashop_click_view

It should then be ok.

It's happening because you must have transferred/restored the website with a script which didn't handle views correctly and broke them.

Please Log in or Create an account to join the conversation.

Time to create page: 0.059 seconds
Powered by Kunena Forum