So this is my problem.
I have a site which uses WooCommerce plugin for its cart purposes.
Now everything was working perfectly until i decided to otimize the database since it was getting very bulky.
I installed Wp-Optimize plugin and optimized the database.
However after this i have noticed that i am not able to add any new attributes to my products now,ie, the old attributes before otimizing can be added to the products but the attributes that i created after i had optimized the database are not being able to be assigned to the products in the attributes tab.
Please help me anyone if they have faced this situation or any hint to the problem.
I have tried disabling all the plugins but this problem still exists.