Search found 46 matches

Search found 46 matches

Re: Cart table in database is InnoDB WHY

Some Extension Creators use MyISAM, and some InnoDB, but as you wrote, it makes not much sense, to have both Engines doing their Job in one DB. And by use of this file Tool, you can make your entire DB working under InnoDB, and in addition, you can FULL INDEX your DB as well, to get the best possib...

Jump to post
  • Sun May 14, 2017 6:45 am
  • Replies 10
  • Views 3615
Re: how to disable auto-scroll-top after you add item to cart in 2.3.0.2?

a hint for such extension , or name , please ? I was looking around at market , but couldn't really find anything useful How about this one to stop auto-scroll to top: https://www.opencart.com/index.php?route=marketplace/extension/info&extension_id=28148&filter_category_id=20&sort=date_added&page=8...

Jump to post
  • Fri May 12, 2017 5:51 am
  • Replies 8
  • Views 1059
Re: how to disable auto-scroll-top after you add item to cart in 2.3.0.2?

You'd better replace scroll with popup notification, otherwise it'll be a very, very bad in terms of usability. Customer will never know, if he actually added an item. could you please tell me how to ? because I don't know code... You could find an extension that does it. a hint for such extension ...

Jump to post
  • Thu May 11, 2017 8:31 pm
  • Replies 8
  • Views 1059
Re: how to disable auto-scroll-top after you add item to cart in 2.3.0.2?

thekrotek wrote:
Thu May 11, 2017 1:26 pm
You'd better replace scroll with popup notification, otherwise it'll be a very, very bad in terms of usability. Customer will never know, if he actually added an item.
could you please tell me how to ? because I don't know code...

Jump to post
  • Thu May 11, 2017 4:39 pm
  • Replies 8
  • Views 1059
Re: how to disable auto-scroll-top after you add item to cart in 2.3.0.2?

Go to catalog/view/javascript Open the file common.js on Find these lines and either remove or comment them: Line 167 : $('html, body').animate({ scrollTop: 0 }, 'slow'); Line 293 : $('html, body').animate({ scrollTop: 0 }, 'slow'); Line 320 : $('html, body').animate({ scrollTop: 0 }, 'slow'); Save...

Jump to post
  • Thu May 11, 2017 4:38 pm
  • Replies 8
  • Views 1059
how to disable auto-scroll-top after you add item to cart in 2.3.0.2?

Hi, I got a little inconvenience with 2.3.0.2 see , in category page , for example when you scroll down to bottom and want to add 2 or more items from there (in my case with infinity scroll extension, the page will become very very very long) , I click item1 and it scrolls up to top and display mess...

Jump to post
  • Thu May 11, 2017 6:30 am
  • Replies 8
  • Views 1059
Re: order number jump in 10,like 51,61,71,81,91, how to fix ?

I was reading some optimization articles in internet and followed I add a line auto-increment-increment=10 auto-increment-offset=1 Wow, what terrible advice, I guess that could cause havoc with just about any installation out there! Just goes to show that you can't trust everything you read on the ...

Jump to post
  • Mon May 01, 2017 7:24 pm
  • Replies 14
  • Views 1042
Re: order number jump in 10,like 51,61,71,81,91, how to fix ?

Yes well , I figured out , after compared 2 versions of files.

problem is in /etc/my.conf configuration file.

I was reading some optimization articles in internet and followed

I add a line

Code: Select all

auto-increment-increment=10
auto-increment-offset=1
I guess that's causing the order_id jumps in 10.

Jump to post
  • Mon May 01, 2017 7:30 am
  • Replies 14
  • Views 1042
Re: order number jump in 10,like 51,61,71,81,91, how to fix ?

I have actually seen this on an aws azure IIS installation recently - I checked the db information schema and the increment was indeed 10. Should be fixed at the sql settings would you please tell me how to do so ? even though I managed , by lucky , fix it this time , but I can not dump and restore...

Jump to post
  • Mon May 01, 2017 5:58 am
  • Replies 14
  • Views 1042
Re: order number jump in 10,like 51,61,71,81,91, how to fix ?

please enlighten me how to like this ? ALTER TABLE oc_order AUTO_INCREMENT = 0; I actually solved it somehow. I found a snapshot on day 27 , that day I changed domain so I made a backup in case something went wrong. today I restored that backup , and then , overwrite the files and database of today....

Jump to post
  • Mon May 01, 2017 5:55 am
  • Replies 14
  • Views 1042
Re: order number jump in 10,like 51,61,71,81,91, how to fix ?

please take look the screenshots , the right side is filtered with missing order , only 311 makes sense between 301 and 321

order.JPG

order.JPG (65.42 KiB) Viewed 1006 times

Jump to post
  • Mon May 01, 2017 2:42 am
  • Replies 14
  • Views 1042
Re: order number jump in 10,like 51,61,71,81,91, how to fix ?

Thank you for replying , but please , hear me out. 1. I fully understand and comprehend this "incomplete order" thing. I get it , as matter of fact , I have seen it before , it jumps in fewer number like , like 1 ,3 , 4, 6, 8 , 11 and such , NEVER jump always in 10, from 101 , 111, 121,131,141,151. ...

Jump to post
  • Mon May 01, 2017 2:36 am
  • Replies 14
  • Views 1042
Re: order number jump in 10,like 51,61,71,81,91, how to fix ?

There're so called "missing" or unfinished orders, which you won't seem until you select Mission order status in orders list to filer. This is absolutely normal behavior, you may ignore it. I don't think so , like I said , if it's unfinished order , then how come every time it is a "10" , that's he...

Jump to post
  • Sun Apr 30, 2017 11:30 pm
  • Replies 14
  • Views 1042
order number jump in 10,like 51,61,71,81,91, how to fix ?

Hi. today I just noticed a very weird problem. Order number jumps in 10 for exmaple this number is 51, then next is 61, next is 71 , next is 81, and 91 , and then 101 and so on. I google around, says client add item in cart but without checkout also increase order ID , well , i guess that's not real...

Jump to post
  • Sun Apr 30, 2017 9:22 am
  • Replies 14
  • Views 1042
Re: where is "add-wishlist" button triggered the line "item added to wishlist" ?

Never mind , I figured out , I added line in controller/account/wishlist.php and does the trick.

Jump to post
  • Sat Apr 29, 2017 10:19 pm
  • Replies 1
  • Views 247
where is "add-wishlist" button triggered the line "item added to wishlist" ?

Hi, I setup opencart with memcahced , which creates some problem on something that should not be cached , like wish-list. memcached has its own expire time , but it doesn't update itself when client adds item to wishlist. So I thought I manually insert a php line <?php $m = new Memcached(); $m->addS...

Jump to post
  • Sat Apr 29, 2017 9:20 pm
  • Replies 1
  • Views 247
Re: How can search product in admin panel ?

tingwing wrote:
Sat Mar 18, 2017 3:01 pm
at catalog-product
enter the content at Product Name and then click fliter,
it should work,only if you enter wrong info or you have not added any products
Thanks, but that's exactly what I did in my screenshot, and no matter what I search , it always says nothing found...

Jump to post
  • Sat Mar 18, 2017 6:41 pm
  • Replies 2
  • Views 268
How can search product in admin panel ?

Greetings: I just running into a quite stupid problem ... How can search product in admin panel ? I know this sounds stupid, but just please forgive my stupidity. I saw this in admin panel , but it doesn't work I don't know why , even though I typed keyword in there and no matter what I wrote , it a...

Jump to post
  • Sat Mar 18, 2017 9:59 am
  • Replies 2
  • Views 268
Re: Changing url of storefront

just one more thing , if you use SEO URL , don't forget .htaccess

I am not sure if it will create any effect on your image files through...

Jump to post
  • Sat Mar 11, 2017 8:19 am
  • Replies 1
  • Views 458
shipping and payment address form messed up

shipping and payment address form messed up OC 2.3.0.2 , default theme. don't really know what happen'ed , but please look at screenshots the "company" line should be a new line instead of attaching to first line ... https://forum.opencart.com/download/file.php?mode=view&id=31581 I have been digging...

Jump to post
  • Fri Mar 03, 2017 5:25 am
  • Replies 0
  • Views 470

Search found 46 matches