OpenCart Community

Hi,

i am working with opencart 3.0.2 and journal.
I installed vqmod (latest version) and documentation assured there would not be an impact on speed. However my site started slowing down and it is now extremely slow. I found that the problem is most likely in my vqmod/checked.cache.php It keeps adding slowing and slowing down everyting more and more.

I read through some old posts, but haven't found the answer yet. Any help? Tried to reset vqmod as suggested in another post. Did not help. When i delete the checked.cach.php, it just comes right back and fills up right away

I see a lot of vendor/autoload.php

/home/ergospel/ocartdata1/storage/vendor/autoload.php
/home/ergospel/ocartdata1/storage/modification/system/library/response.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/startup/startup.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/startup/maintenance.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/startup/seo_url.php
/home/ergospel/ocartdata1/storage/modification/catalog/model/tool/image.php
/home/ergospel/ocartdata1/storage/modification/system/library/cart/user.php
/home/ergospel/ocartdata1/storage/modification/catalog/model/design/layout.php
/home/ergospel/ocartdata1/storage/modification/catalog/model/catalog/product.php
/home/ergospel/ocartdata1/storage/modification/system/library/template.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/product/product.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/common/column_left.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/common/column_right.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/common/content_top.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/common/content_bottom.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/common/footer.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/common/cart.php
/home/ergospel/ocartdata1/storage/vendor/autoload.php
/home/ergospel/ocartdata1/storage/modification/system/library/response.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/startup/startup.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/startup/maintenance.php
/home/ergospel/ocartdata1/storage/modification/catalog/controller/startup/seo_url.php

do you have a lot of products? you need to disable the product count function that counts the products in the category layout. That helped a lot for me, i also advice you to use the lightning cache plugin, this gave me 100/100 speed score on google sitespeed

Well, it's probably of no use, because many seem to run an OC-Shop on faith and hope,
but near to zero technical understanding. But if one uses 2 Different caching Extensions,
like OcMod + VqMod, to so do exactly the same, is more a double murder attempt, than
a professional Solution.

From OC-2 + Versions on, OcMod has been implemented, to REPLACE VqMod. Not if FULL,
but in MOST parts, by creating Server OUTPUT File Content, out of 'regular' OC Source,
PLUS some Content, inserted by the OcMod File install routine, and placed as regular
OcMod-Content into the Database Modification Table, from where it is called from, in
order to create cached Output Pages.

Contrary to VqMod, placing it's OUTPUT Content into Flat-DB like Final Cache Files,
placed in the vqmod/vqcache/... Directory. (in VqMod Versions up to v.2.61 at least)
Plus 2 indexing cache files in the VqMod Main Section.

In Combined Use, at first, OcMod will check, if new OcModded Content in the Database
exists. And it will change existing OcModded OUTPUT File Content accordingly, by adding
it's DB-placed OcMod Content to the OC Source output File, if required. Then, it saves the
Result in the system / ... /Modification/ Subdirectories, as OcMod OUTPUT File,
named xxx.php / xxx.twig / xxx.tpl, whatever ... exactly like the default File Name.

And then, VqMod will come into the Game. To do the same, again, namely, to build another
VqMod cached Output File. And it consists out of the Content of the OcModded Output File,
if one exists, or then only from OC Source, Plus it's own xxx.xml File Content / Changes, to
so create the final valid OUTPUT PAGE out of this all, combined.

By use of the latest VqMod Version, like JNeuhoff's famous VqMod Extension, as I recall,
if may no longer work exactly this way anymore, but it at least used to be the case with
older VqMod Versions. STILL, it's Nonsense, to have a Shop Software working like this,
total Nonsense, it only costs Servertime, slows down overall performance, and sure add's
to potential problems, as you already found out.

Most VqMod/OcMod Extensions will function with both ways of 'writing/coding' them,
so, there is no good reason, to have 'em both in a System anyway. For Professionals at
least, and for the Rest, who should care about, less Competition only means more sales.

But whatever one decides on, both work well. And if plans to fully to remove OcMod,
one just has to find all those lines, where (modification ........... ) exists, like this
one, in the system/startup file: to make such lines look like: Also remove the modification.xml file out of the system/... Sub,
to finally be able, to clear out the Modification Database Table Content in full,
since it's OcMod DRIVER does no longer exist. And it's easy to then remove the
Admin Header Links to the Modification Section, to so have a VqMod only
System again.

Just make a DB Backup first, to have Copies of OcMod Content, if exist, to be
copied and slightly rewritten to VqMods, to have it all, sorted, to work, as planned.

Good Luck !
Ernie
---

Just to clarify: The Integrated VQmod uses the same caching mechanism as OCmod, with the cache located at 'system/storage/modification'. It does not use 'vqmod/vqcache'.

wrick0 wrote: ↑

Fri Jan 25, 2019 11:42 pm

do you have a lot of products? you need to disable the product count function that counts the products in the category layout. That helped a lot for me, i also advice you to use the lightning cache plugin, this gave me 100/100 speed score on google sitespeed

I had product count disabled already. For now, I removed the vqmod again and it solved the problem. So it realy is related to the vqmod.

Well Ernie, I have never had use for vqmod. My shop ran well for the last year. But i need it to be able to use a shipping extention that I need. There aren't 10 to choose from (shipping Belgium), so i can't be picky ...

I surely am not planning on removing the ocmod. Removed the vqmod again instead for now...

I did not advise you, to remove OcMod, I only explained, how it can be done,
if one wants to remove it, to only use VqMod in a later Version System, to so
avoid potential problems.
Good Luck!
Ernie

I'm having the same problem here.... VQ Cache fills up a 26 MB file (checked.cache), with lines such as:
[site] is my sitename that I replaced.

How do I disable product count in opencart 3? Maybe that will help (if I haven't already done so).

What else could cause this problem? I appreciate any suggestions.

See this solution: viewtopic.php?f=202&t=212346&p=759308#p759308 .

How do I disable product count in opencart 3? Maybe that will help (if I haven't already done so).

Admin - > Systems - > Settings - > Add / Edit Settings page.

straightlight wrote: ↑

Wed Jul 10, 2019 7:42 pm

See this solution: viewtopic.php?f=202&t=212346&p=759308#p759308 .

How do I disable product count in opencart 3? Maybe that will help (if I haven't already done so).

Admin - > Systems - > Settings - > Add / Edit Settings page.

Thank you!
I see this was already set to off.

I can add that I have run OpenCart 3 for 7 months and it started filling up the cache page around 1 month ago so it must have been something I did, but is there some way I can find out?

What I'm doing now is to delete (or rename) the cache file in vqmod/checked.cache but it seems to fill up to its max 26 MB in about 3 weeks and then my web server stops functioning. Is there anything I can do to prevent this?

What I'm doing now is to delete (or rename) the cache file in vqmod/checked.cache but it seems to fill up to its max 26 MB in about 3 weeks and then my web server stops functioning. Is there anything I can do to prevent this?

Yes ... the solution has been posted on the above about it ...

straightlight wrote: ↑

Wed Jul 10, 2019 11:06 pm

What I'm doing now is to delete (or rename) the cache file in vqmod/checked.cache but it seems to fill up to its max 26 MB in about 3 weeks and then my web server stops functioning. Is there anything I can do to prevent this?

Yes ... the solution has been posted on the above about it ...

Do you mean "by IP_CAM » Sat Jan 26, 2019 12:04 pm "
To replace VQMod with OcMod ? If that is what he is saying? I can't understand his post very well.

It seems to me that if there is some problem with VQMod that fills up the cache with garbage, it should be easier to find some way to fix the problem.

What is the purpose of a huge cache file that repeats the same lines over and over?

No ... the solution I have posted right here ... viewtopic.php?f=199&t=209660#p759517

straightlight wrote: ↑

Thu Jul 11, 2019 1:24 am

No ... the solution I have posted right here ... viewtopic.php?f=199&t=209660#p759517

Alright, but I tried that and it didn't work. It was already set to Off.

Seems like this is a known problem: https://github.com/vqmod/vqmod/issues/135
https://github.com/vqmod/vqmod/issues/117

I finally fixed it by putting the storage directory at the same level as the vqmod directory. Mine looks something like this: /home/mysite/public_html/store /home/mysite/public_html/store/vqmod /home/mysite/public_html/store/storage From config.php: define('DIR_STORAGE', '/home/mysite/public_html/store/storage/'); From admin/config.php: define('DIR_STORAGE', '/home/mysite/public_html/store/storage/');

I've done it now so let's see if it works.

Edit: A day later: so far so Good!

Alright, but I tried that and it didn't work. It was already set to Off.

Partial instructions read from the referred post.