Thank you all for your input
I can confirm I have used session debloater and it has taken my DB down to about 1gb (the sessions table, so greatly improved)
I can confirm I have used session debloater and it has taken my DB down to about 1gb (the sessions table, so greatly improved)
That's great, if this resolved issue then add word [SOLVED] into the beginning of post title.lukehackett85 wrote: ↑Tue Aug 18, 2020 6:09 pmThank you all for your input
I can confirm I have used session debloater and it has taken my DB down to about 1gb (the sessions table, so greatly improved)
thanks
Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature
Just a quick note dear, if you are providing a solution be kind to other users and point out the file also which need to be edited.
Thanks
Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature
seek and thee shall find
https://www.opencart.com/index.php?rout ... n_id=38580
it was even posted on this topic !
https://www.opencart.com/index.php?rout ... n_id=38580
it was even posted on this topic !
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
I have no idea - but there is little point to complain at us because we are not affiliated with Opencart so you are simply venting your frustrations at the wrong people. What you might consider is that by posting such, we have to spend unpaid time away from our paid work to search for things to help you, just because you want to vent that a free product isn’t perfect.
Its Xmas - say thanks for the free cart that you make money from - and thanks to the wonderful developer who used his free time to provide a fix and to grr for finding that and saving you some time searching and letxobnav and everyone else I have missed out ..
It has not been updated, there is a fix, life is great
Happy Holidays
Its Xmas - say thanks for the free cart that you make money from - and thanks to the wonderful developer who used his free time to provide a fix and to grr for finding that and saving you some time searching and letxobnav and everyone else I have missed out ..
It has not been updated, there is a fix, life is great
Happy Holidays
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
1 Not really complaining is he, just asking a reasonable question.by mona wrote: ↑Fri Dec 17, 2021 3:08 amI have no idea - but there is little point to complain at us because we are not affiliated with Opencart so you are simply venting your frustrations at the wrong people. What you might consider is that by posting such, we have to spend unpaid time away from our paid work to search for things to help you, just because you want to vent that a free product isn’t perfect.
Its Xmas - say thanks for the free cart that you make money from - and thanks to the wonderful developer who used his free time to provide a fix and to grr for finding that and saving you some time searching and letxobnav and everyone else I have missed out ..
It has not been updated, there is a fix, life is great
Happy Holidays
2 No you dont HAVE to do anything, you entirely CHOOSE to do so of your own free will.
Should be fixed in 3.0.3.7. https://github.com/opencart/opencart/co ... 9d1a066ce7
With a small correction in 3.0.3.8. https://github.com/opencart/opencart/co ... 9d1a066ce7
.. you could have at least thanked ADD Creative whilst you were here .. geez .. some people just don’t know how to be happy
Thanks ADD Creative ..
Thanks ADD Creative ..
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
Please all, i am having an issue , when i install the Session Debloater plugin , https://www.opencart.com/index.php?rout ... cmod.space ,
Website stops loading .. and after, error shows ,
Fatal error: Uncaught Exception: Error: Lock wait timeout exceeded; try restarting transaction<br />Error No: 1205<br />DELETE FROM `oc_session` WHERE expire < '2023-01-30 09:57:34' in /home/dummyf5/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/dummyf5/public_html/system/library/db.php(45): DB\MySQLi->query('DELETE FROM `oc...') #1 /home/dummyf5/public_html/storage/modification/system/library/session/db.php(52): DB->query('DELETE FROM `oc...') #2 /home/dummyf5/public_html/storage/modification/system/library/session/db.php(22): Session\DB->gc(90000) #3 /home/dummyf5/public_html/system/library/session.php(29): Session\DB->__construct(Object(Registry)) #4 /home/dummyf5/public_html/system/framework.php(84): Session->__construct('db', Object(Registry)) #5 /home/dummyf5/public_html/system/startup.php(104): require_once('/home/dummyf5/p...') #6 /home/dummyf5/public_html/index.php(20): start('catalog') #7 {main} thrown in /home/dummyf5/public_html/system/library/db/mysqli.php on line 40
Please help, how do i deactivate this, and get my website to work back, it's urgent please
Website stops loading .. and after, error shows ,
Fatal error: Uncaught Exception: Error: Lock wait timeout exceeded; try restarting transaction<br />Error No: 1205<br />DELETE FROM `oc_session` WHERE expire < '2023-01-30 09:57:34' in /home/dummyf5/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/dummyf5/public_html/system/library/db.php(45): DB\MySQLi->query('DELETE FROM `oc...') #1 /home/dummyf5/public_html/storage/modification/system/library/session/db.php(52): DB->query('DELETE FROM `oc...') #2 /home/dummyf5/public_html/storage/modification/system/library/session/db.php(22): Session\DB->gc(90000) #3 /home/dummyf5/public_html/system/library/session.php(29): Session\DB->__construct(Object(Registry)) #4 /home/dummyf5/public_html/system/framework.php(84): Session->__construct('db', Object(Registry)) #5 /home/dummyf5/public_html/system/startup.php(104): require_once('/home/dummyf5/p...') #6 /home/dummyf5/public_html/index.php(20): start('catalog') #7 {main} thrown in /home/dummyf5/public_html/system/library/db/mysqli.php on line 40
Please help, how do i deactivate this, and get my website to work back, it's urgent please
adedayof wrote: ↑Tue Jan 31, 2023 6:19 pmPlease all, i am having an issue , when i install the Session Debloater plugin , https://www.opencart.com/index.php?rout ... cmod.space ,
Website stops loading .. and after, error shows ,
Fatal error: Uncaught Exception: Error: Lock wait timeout exceeded; try restarting transaction<br />Error No: 1205<br />DELETE FROM `oc_session` WHERE expire < '2023-01-30 09:57:34' in /home/dummyf5/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/dummyf5/public_html/system/library/db.php(45): DB\MySQLi->query('DELETE FROM `oc...') #1 /home/dummyf5/public_html/storage/modification/system/library/session/db.php(52): DB->query('DELETE FROM `oc...') #2 /home/dummyf5/public_html/storage/modification/system/library/session/db.php(22): Session\DB->gc(90000) #3 /home/dummyf5/public_html/system/library/session.php(29): Session\DB->__construct(Object(Registry)) #4 /home/dummyf5/public_html/system/framework.php(84): Session->__construct('db', Object(Registry)) #5 /home/dummyf5/public_html/system/startup.php(104): require_once('/home/dummyf5/p...') #6 /home/dummyf5/public_html/index.php(20): start('catalog') #7 {main} thrown in /home/dummyf5/public_html/system/library/db/mysqli.php on line 40
Please help, how do i deactivate this, and get my website to work back, it's urgent please
I have been able to get this solved through the help of the extension developer... thank you so much.
For anyone experiencing this same, download the Session Debloater extension from Mr Andrii , here => https://www.opencart.com/index.php?rout ... cmod.space .
Before installing, empty the oc_session table from the database , then proceed to install the extension . Refresh the modifications, and you will never have a database with huge size anymore.
Thank you , Mr Andrii .. Thank you, you're a life saver!
Before installing, empty the oc_session table from the database , then proceed to install the extension . Refresh the modifications, and you will never have a database with huge size anymore.
Thank you , Mr Andrii .. Thank you, you're a life saver!
Who is online
Users browsing this forum: No registered users and 13 guests