Hi Forum
We host a Version 3.0.2.0 OC site that is being particularly slow quite suddenly. https://www.cricketcap.co.uk/
I have emptied the oc_sessions table which had been a problem in the past but wasn't this time.
Chrome DevTools is reporting that the JS scripts are taking a long time to load - they are being loaded locally (so maybe I should try using the third party repository?).
The site has always been allocated an excessively high (2500M) PHP memory_limit. Its running PHP v 7.3 FPM served by Apache.
Other sites on the server are not running noticeably slower than usual - this is the only complaint we have had.
I'd welcome any links to great troubleshooting slow OC sites guides.
Many Thanks
The TTFB of the main html is high which means the html creation time is high which is before any js or css or images are loaded.
Which could be a database issue, an external dependency or cache images which are recreated continuously, all the components which come into play to create the basic html source.
I would check if anyone made a change first (settings, modifications), then the database (slow queries) and the cache images timestamps.
Which could be a database issue, an external dependency or cache images which are recreated continuously, all the components which come into play to create the basic html source.
I would check if anyone made a change first (settings, modifications), then the database (slow queries) and the cache images timestamps.
Thanks @nonnedelectari - really helpful suggestions.
This error can be seen in the error log:
##
AH01071: Got error 'PHP message: PHP Fatal error: Allowed memory size of 2621440000 bytes exhausted (tried to allocate 268435464 bytes) in /var/www/vhosts/cricketcap.co.uk/httpdocs/vqmod/vqmod.php on line 336'
##
(Attached a screenshot of this part of the VQMod file. )
I guess this script is error is simply reporting what we already know - that 'something' is taking way too long?
FWIW I cleared the error log (703.36MB) and see this PHPNotice.
#
2024-12-03 8:55:31 - PHP Notice: Trying to access array offset on value of type null in /storage3020/vendor/scss.inc.php on line 1753
#
Any suggestions for I learn more about 'the cache images timestamps' and managing 'the cache images' in OC?
Thanks
This error can be seen in the error log:
##
AH01071: Got error 'PHP message: PHP Fatal error: Allowed memory size of 2621440000 bytes exhausted (tried to allocate 268435464 bytes) in /var/www/vhosts/cricketcap.co.uk/httpdocs/vqmod/vqmod.php on line 336'
##
(Attached a screenshot of this part of the VQMod file. )
I guess this script is error is simply reporting what we already know - that 'something' is taking way too long?
FWIW I cleared the error log (703.36MB) and see this PHPNotice.
#
2024-12-03 8:55:31 - PHP Notice: Trying to access array offset on value of type null in /storage3020/vendor/scss.inc.php on line 1753
#
Any suggestions for I learn more about 'the cache images timestamps' and managing 'the cache images' in OC?
Thanks
Attachments
???- Loads already checked files and adds them to _doNotMod array
First of all, when possible use OpenCart 3.0.4.0 OpenCart 3.0.4.0
together with php 8..x (best 8.2.x).
Benefits of using that combination are
1. better security
2. faster site loading
Next is: which version of VQMod are you using?
Older version had a massive problem, see : https://github.com/vqmod/vqmod/issues/166
together with php 8..x (best 8.2.x).
Benefits of using that combination are
1. better security
2. faster site loading
Next is: which version of VQMod are you using?
Older version had a massive problem, see : https://github.com/vqmod/vqmod/issues/166
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Thank you @OSWorX
I've downloaded OpenCart 3.0.4.0 and will update.
VQMod: $_vqversion = '2.6.2'; // Current version number
Looks like I should be using v2.6.8-stand-alone - https://github.com/vqmod/vqmod/releases
Will update this too.
I've downloaded OpenCart 3.0.4.0 and will update.
VQMod: $_vqversion = '2.6.2'; // Current version number
Looks like I should be using v2.6.8-stand-alone - https://github.com/vqmod/vqmod/releases
Will update this too.
When you "update", don't do it via the integrated updater!
Instead deploy a new instance (e.g. in a subdirectory) and install the new version new there.
Then copy the database tables into a new database.
Doing so, you can then install only needed extensions.
If all is okay - after testing, either
1. simple redirect to the new directory (voa server settings)
or
2. copy content of new instalaltion into old directory AND adopt the pathes inside the 2 config files (catalog and admin).
Search this forum - there are several discussions about that and how to do it correct.
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Hi @OSWorX
I've downloaded the following backups:
1/ OpenCart Backup Export
2/ Web Server > Public_HTML Full Download
3/ Web Server > Storage 3020 Full Download
4/ Web Server > OC Database Export
And run a Web Server > Plesk Full Back.
I see you recommend here a fresh install.
viewtopic.php?t=234188
Do you know of a post that sets out the recommended steps for upgrading for upgrading within 3.* to 3.*?
I've downloaded the following backups:
1/ OpenCart Backup Export
2/ Web Server > Public_HTML Full Download
3/ Web Server > Storage 3020 Full Download
4/ Web Server > OC Database Export
And run a Web Server > Plesk Full Back.
I see you recommend here a fresh install.
viewtopic.php?t=234188
Do you know of a post that sets out the recommended steps for upgrading for upgrading within 3.* to 3.*?
Every serious developer (and user) here, will reccomend a fresh and clean installation.oc-hastings wrote: ↑Tue Dec 03, 2024 9:09 pmDo you know of a post that sets out the recommended steps for upgrading for upgrading within 3.* to 3.*?
No matter from which version.
It's easier when doing it from a 2.x to 2.3.0.2, or 3.x to 3.0.4.0.
But the princip should be always the same.
The only thing which must be observed to is, are there any changes in the database tables?
Which can be done also easely by comparing the opencart.sql in the install folder.
Or after the fresh installation comparing the two (old and new) database tables and their structure.
Unfortunetely the integrated updater script is not 100% working - and while this is so, a manual update is the fastest and best way.
And for the backup - before starting, do following:
make a full backup of the old shop > files and database
Database should be backuped with phpMyAdmin - not the integrated backup function, because that stores only the data, not the structure!
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
This is the link you've been looking for:oc-hastings wrote: ↑Tue Dec 03, 2024 5:39 amI'd welcome any links to great troubleshooting slow OC sites guides.
https://www.antropy.co.uk/blog/speed-up ... ed-issues/
If that doesn't do the trick then perhaps you need a website health check:
https://www.antropy.co.uk/opencart-serv ... cal-audit/
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Legendary Member
Thanks @paulfeakins - you nailed it!
We were suffering from the vQmod "checked.cache" Issue. I am super grateful.
I'm going to look at the recommended fix you link to straight away.
I've also set up a staging site running the latest OC v3 and VQMod versions and will plan to troubleshoot upgrading the site.
And I'll discuss purchasing a health check from you with my client and contact you through antropy.co.uk.
Again thanks @nonnedelectari, @OSWorx and @paulfeakins for your kind attention here - you are all superstars.
We were suffering from the vQmod "checked.cache" Issue. I am super grateful.
I'm going to look at the recommended fix you link to straight away.
I've also set up a staging site running the latest OC v3 and VQMod versions and will plan to troubleshoot upgrading the site.
And I'll discuss purchasing a health check from you with my client and contact you through antropy.co.uk.
Again thanks @nonnedelectari, @OSWorx and @paulfeakins for your kind attention here - you are all superstars.
Great stuff, glad to hear it.oc-hastings wrote: ↑Wed Dec 04, 2024 1:10 amThanks @paulfeakins - you nailed it!
We were suffering from the vQmod "checked.cache" Issue. I am super grateful.
I'm going to look at the recommended fix you link to straight away.
I've also set up a staging site running the latest OC v3 and VQMod versions and will plan to troubleshoot upgrading the site.
And I'll discuss purchasing a health check from you with my client and contact you through antropy.co.uk.
Again thanks @nonnedelectari, @OSWorx and @paulfeakins for your kind attention here - you are all superstars.
I'll mark this thread as [SOLVED].
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Legendary Member
Who is online
Users browsing this forum: No registered users and 25 guests
