Hello Mirko,
Thanks a lot for your reply.
I have been in touch with hosting provider who found out that somehow there was a table was removed and now it was added and issue was solved.
Still checking why this happened only with woocommerce.
Issue is solved now. I appreciate your help
regards
Soufiane