Search found 371 matches

Search found 371 matches

Re: Loading category page takes a lot of time. I really need help...

well, I think it is a great mod, I am sure it work perfect for single byte character sets and surely will speed things up even with few products. (the # of products is rarely the issue, it are the options, filters, categories etc. and the fact that OC indeed executes the same queries over and over w...

Jump to post
  • Fri Apr 26, 2019 5:15 am
  • Replies 10
  • Views 122
Re: Loading category page takes a lot of time. I really need help...

it uses unserialize() which does not go well with multi-byte character sets.
if it were using json_encode/decode then it would be an option.

Jump to post
  • Fri Apr 26, 2019 4:44 am
  • Replies 10
  • Views 122
Re: WTF with all the same queries?

some fragments of the products query: $sql = "SELECT p.product_id, (SELECT AVG(rating) AS total FROM " . DB_PREFIX . "review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM " . DB_PREFIX . "product_discount pd2 WHERE pd2.product_id = p....

Jump to post
  • Thu Apr 25, 2019 11:50 pm
  • Replies 17
  • Views 234
Re: WTF with all the same queries?

sure, everything with "_id" in the name, status, the dates, sort_order, model, price.

Jump to post
  • Thu Apr 25, 2019 11:22 pm
  • Replies 17
  • Views 234
Re: WTF with all the same queries?

right, there are indexes and I think you are using the latest version. But do you see any index on the product table?

Jump to post
  • Thu Apr 25, 2019 10:57 pm
  • Replies 17
  • Views 234
Re: WTF with all the same queries?

true, that script is also valid for V3 but as I mentioned before, it is not enough as that script only considers the columns it can find with "_id" in the name.
There are many more columns without "_id" in the name to consider.

Jump to post
  • Thu Apr 25, 2019 10:06 pm
  • Replies 17
  • Views 234
Re: I need to remove address for shipping

if you are a little handy with php, you could automatically set (pre-fill) the address fields for guest billing and delivery to your store address, hide those fields from the forms, only enable delivery method store-pickup and payment-method cash on delivery for your store address. Then it is just c...

Jump to post
  • Thu Apr 25, 2019 10:02 pm
  • Replies 5
  • Views 67
Re: WTF with all the same queries?

well, I am not privy to previous versions, I started at 3.0.2.0 and will end there. I simply list out all queries which are performed and make a list of all the columns used in the where clauses or on clauses for joins as well as the sorting. Those are the columns I put indexes on if they are not pa...

Jump to post
  • Thu Apr 25, 2019 7:54 pm
  • Replies 17
  • Views 234
Re: WTF with all the same queries?

before you start the cache route, better look at DB indexes first as OC out of the box has no DB optimization whatsoever.
Caching will camouflage the absence of optimization and should always be the last line of defense.

Jump to post
  • Thu Apr 25, 2019 7:32 pm
  • Replies 17
  • Views 234
Re: This is a HTML email and your email client software does not support HTML email!

well, last test would be to send the emails from oc to your gmail account, you have one I expect. If that receives OC html emails fine then it is still your incredimail client that hicks up. Then the only alternative would be to only send plain text emails from OC if you value those customers who us...

Jump to post
  • Thu Apr 25, 2019 7:24 pm
  • Replies 12
  • Views 159
Re: CSS hide links in top grey menu!!!

you also succeeded in hiding the "following css".

Jump to post
  • Thu Apr 25, 2019 6:17 pm
  • Replies 1
  • Views 44
Re: OC3 Setup running very slowly

you are still mixing https://www.titancards.co.uk and https://titancards.co.uk.

that prevents your fonts from loading and certain ajax calls from executing because of x-origin authorization failures (CORS).

Jump to post
  • Thu Apr 25, 2019 6:02 pm
  • Replies 12
  • Views 200
Re: OC3 Setup running very slowly

good, on js/css optimization like consolidation and/or inlining etc, just look at the deliberations and efforts by IP_CAM, he has made website optimization his life's mission.

Jump to post
  • Thu Apr 25, 2019 5:48 pm
  • Replies 12
  • Views 200
Re: Warning: Shipping method required!

well, when I mention the error_log I mean the php error_log, not the webserver error_log.
Still, these are from the oc error log? you are now using the $this->log->write(...) statements?

Jump to post
  • Thu Apr 25, 2019 5:42 pm
  • Replies 18
  • Views 1423
Re: WTF with all the same queries?

You will find that many parts of OC are written with developer (dare I say... yes I do) laziness in mind as opposed to efficiency and effectiveness. Some of it reeks of trail and error development and vital parts are sheer after-thoughts like seo urls and multi-language & mb-character-set support. T...

Jump to post
  • Thu Apr 25, 2019 10:40 am
  • Replies 17
  • Views 234
Re: How to add product image in twitter:image?

in system/library/document.php after: private $keywords; add: private $ogimage; after: public function getTitle() { return $this->title; } add: public function setOgImage($ogimage) { $this->ogimage = $ogimage; } public function getOgImage() { return $this->ogimage; } in catalog/controller/product/pr...

Jump to post
  • Thu Apr 25, 2019 6:08 am
  • Replies 3
  • Views 71
Re: This is a HTML email and your email client software does not support HTML email!

you might try disabling the "extra-email-setting" modification first, not sure what that is for.

Jump to post
  • Thu Apr 25, 2019 5:42 am
  • Replies 12
  • Views 159
Re: URGENT HELP PLEASE

Paul Feak-ed out.

Jump to post
  • Thu Apr 25, 2019 12:11 am
  • Replies 11
  • Views 169
Re: OC3 Setup running very slowly

you can also set the HSTS header which tells the browsers to always access your domain via https, saves you some redirects.

Code: Select all

header always set Strict-Transport-Security "max-age=63072000; includeSubdomains; preload"
I set that in my virtual hosts but I am sure you can do that in htaccess as well.

Jump to post
  • Thu Apr 25, 2019 12:08 am
  • Replies 12
  • Views 200

Search found 371 matches