Jump to content

Database issues on VPS server - newly added things are visible only after server reboot


Recommended Posts

I was working with my PS without any issues on shared server. Recently I've moved to a VPS. Everything seemed to be working, but I encountered issues with adding new content. For instance, if I add new manufacturer, or new category, or attributes, I can see them in corresponding menus. But if I go, let's say, and edit the product, I can't see my new manufacturer and can't assign it. If I go to new category in front office, I get 404 error. If I go to product combinations, I can't assign new attribute since it does not appear. BUT! After I reboot my server, all these things become visible and working (and i even can create new and see them) but in few next hours I will become unable to add and see new things again. I believe this is something related to DB. As far as I understand, new values are saved in DB but Prestashop does not always receive them back. And this happens only after some amount of time after last reboot. Also these issue happen only to certain things. So, for instance, new products and new orders are created and visible without problems. Again, this is not a fresh installation, but my old shared server with PS still runs without such issues. I've never seen them on a shared server.

Edited by Vitazzz (see edit history)
Link to comment
Share on other sites

BTW. APC ist not supported anymore if you are using php 5.5., cause for all servers with this php version they are configured with opcache, which is faster than APC.

 

Take also a look into this: http://forge.prestashop.com/browse/PSCSX-5997

 

and this topic

 

https://www.prestashop.com/forums/topic/448978-prestashop-1610-a-new-level-of-performances/

Link to comment
Share on other sites

×
×
  • Create New...