Working together with author of this module https://www.opencart.com/index.php?rout ... n_id=17618 we find out the problem appear in the new release OC3.x.x that sessions data was moved to the database. DB table where sessions are stored has no space to fit all session's data (both lists of terminals and pakomats!) when omniva & lpexpress both enabled. In previous versions of the OC session's data was stored to the file.
there is some ways to solve this issue
1. switch sessions to file engine in system/config/catalog.php
2. change type of column of table where session data stored
or maybe authors of the OC 3.0 can suggest better way?
Thank you in advance...
Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here
Switching back to file mode may greatly help the store's performance. Although, it is a less secured strategy when users visits the store.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
So maybe it is good to move session's data to DB. Only need to do some steps to get it working properly.
Thank's all for help and Good Luck
Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
If is true what you told, it is not good for beginners who starting with now money and use cheap servers for that.. they simply goes away from OC... and not only beginners, all will think about it if OC stops to work without understandable reason... I hope developers of the OC find some better solution for example maybe to have two possibilities to use DB or files for sessions data... And will keep users...straightlight wrote: ↑Fri Sep 29, 2017 3:34 amExtending the field size is only a temporary solution, however.
Cheers
Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here
One of the advantage for all this is especially the fact that Opencart is free!If is true what you told, it is not good for beginners who starting with now money and use cheap servers for that.. they simply goes away from OC... and not only beginners, all will think about it if OC stops to work without understandable reason... I hope developers of the OC find some better solution for example maybe to have two possibilities to use DB or files for sessions data... And will keep users...
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
After activating a social camping the website got slower and slower and could not understand why, cache are enabled and is the same configuration that we had on other project
Just found oc_session with 24k records, running an optimized on DB tables got back speed to the website
Where is set lifetime of oc_session session? How can I increase performance?
There are a couple of other issues that may affect database sessions.
https://github.com/opencart/opencart/pull/6613
https://github.com/opencart/opencart/co ... 2cd378dabc
I'm experiencing the exact same problems. Did you manage to solve this?al404 wrote: ↑Wed Dec 19, 2018 6:57 pmJust found this topic since we developed a new e-commerce with OC3 and journal, already user for other projects
After activating a social camping the website got slower and slower and could not understand why, cache are enabled and is the same configuration that we had on other project
Just found oc_session with 24k records, running an optimized on DB tables got back speed to the website
Where is set lifetime of oc_session session? How can I increase performance?
Users browsing this forum: No registered users and 39 guests