Search found 31 matches

Search found 31 matches

Re: Gift voucher deduction lost once in PayPal

What happens if the price of the product is like $0.05 or something?
Maybe its a paypal thing that it requires you to pay atleast 1 cent?

Jump to post
  • Thu Aug 11, 2011 10:33 pm
  • Replies 8
  • Views 3817
Re: Model field in the database.

Yea, and it is really easy to do. So it would be nice to have these settings by default.
Lets hope Daniel has some spare time soon, to improve a few database related things :)

Jump to post
  • Thu Aug 04, 2011 8:40 pm
  • Replies 4
  • Views 390
Re: Model field in the database.

I am not quite sure if we are talking about the same index? I meant these:
Image
(I made this index myself)

Jump to post
  • Thu Aug 04, 2011 5:31 pm
  • Replies 4
  • Views 390
Model field in the database.

I've noticed the modelfield in the database, but what are the exact means of this field?
I am using it to store articlenumbers and I think that allot of people do.

But that makes me think, why doesn't it have an Index by default? (Im talking about OC 1.5.1.1)

Jump to post
  • Thu Aug 04, 2011 5:06 pm
  • Replies 4
  • Views 390
Re: OGONE

@Avvici

I totally agree, it is nothing fancy. But my client doesn't want me to share it, and technically it is his script.

Jump to post
  • Thu Jul 28, 2011 2:53 pm
  • Replies 8
  • Views 2155
Re: [1.5] External image-links.[Fixed]

Hey DirkZz, Thank you for all your help. I did have a question about the admin side. Any work on the product list and product edit in the admin. Would be great if pics could show up for that area as well. Yes this is possible, make the same change to admin/model/tool/image.php as you did to catalog...

Jump to post
  • Thu Jul 21, 2011 2:49 pm
  • Replies 20
  • Views 6937
Re: OGONE

I am currently working on one, I might release it for free when im done.
edit: I finished it, but I am not allowed to upload it .. Iam sorry.

Jump to post
  • Wed Jul 20, 2011 6:25 pm
  • Replies 8
  • Views 2155
Re: 1.5.0.5 very slow

@Xsecrets .. im also breaking my balls on this ..
its so god darn hard lol, just like you said.

But there has to be something.. the must be an answer on the big world wide web.

Jump to post
  • Mon Jul 11, 2011 10:20 pm
  • Replies 74
  • Views 17656
Re: 1.5.0.5 very slow

Will certainly give it a try.

Jump to post
  • Fri Jul 08, 2011 11:26 pm
  • Replies 74
  • Views 17656
Re: 1.5.0.5 very slow

Xsecrets wrote:yeah I'm 99.999% sure it cannot be done with group by alone. You will have to have some sort of looping or something. I just don't believe it's possible to get it in one query.
In 1 query is really almost impossible.
I will let PHP figure that out :P

Jump to post
  • Fri Jul 08, 2011 11:12 pm
  • Replies 74
  • Views 17656
Re: 1.5.0.5 very slow

Its really hard I have to admit.. started working on the function today.
currently i have this:
Image

Not quite ok yet.

Jump to post
  • Fri Jul 08, 2011 11:09 pm
  • Replies 74
  • Views 17656
Re: 1.5.0.5 very slow

:P Currenctly working on it .. ill show you what i ment.. almost done.. prob after the weekend.

Jump to post
  • Fri Jul 08, 2011 11:00 pm
  • Replies 74
  • Views 17656
Re: 1.5.0.5 very slow

Not exactly, if it was recursive then i could just count the products with an extra variable in the loop.

Jump to post
  • Fri Jul 08, 2011 2:51 pm
  • Replies 74
  • Views 17656
Re: 1.5.0.5 very slow

The product count is ok, but the menu doesn't add an extra sub item.
I didn't understand you at first, thanks for pointing me to this problem, ill see if I can think of something otherwise, too bad :(

EDIT:
Oc doesnt see the level-3 category as a subcategory of the level-2. Thats the problem.

Jump to post
  • Thu Jul 07, 2011 10:44 pm
  • Replies 74
  • Views 17656
Re: 1.5.0.5 very slow

I see your point.
But 1.5.0.5 has the same problem? Im not using the latest svn releases, because they are f-ed up.

http://imgur.com/zfD5Q

Jump to post
  • Thu Jul 07, 2011 10:21 pm
  • Replies 74
  • Views 17656
Re: OpenCart 1.5.0.5 Bug Thread

Daniel wouldnt this be a better query for counting the category totals?: SELECT COUNT( p.product_id ) AS total, p2c.category_id FROM product p LEFT JOIN product_description pd ON ( p.product_id = pd.product_id ) LEFT JOIN product_to_store p2s ON ( p.product_id = p2s.product_id ) LEFT JOIN product_t...

Jump to post
  • Thu Jul 07, 2011 9:30 pm
  • Replies 344
  • Views 83550
Re: 1.5.0.5 very slow

If the count product query would be like this: SELECT COUNT(p.product_id) AS total,p2c.category_id FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p2c.product_id...

Jump to post
  • Thu Jul 07, 2011 9:21 pm
  • Replies 74
  • Views 17656
Re: OpenCart 1.5.0.5 Bug Thread

Daniel wouldnt this be a better query for counting the category totals?: SELECT COUNT( p.product_id ) AS total, p2c.category_id FROM product p LEFT JOIN product_description pd ON ( p.product_id = pd.product_id ) LEFT JOIN product_to_store p2s ON ( p.product_id = p2s.product_id ) LEFT JOIN product_to...

Jump to post
  • Thu Jul 07, 2011 7:58 pm
  • Replies 344
  • Views 83550
Re: 1.5.0.5 very slow

I've added this to my code and it seems to have improved the speed.

Jump to post
  • Thu Jul 07, 2011 7:38 pm
  • Replies 74
  • Views 17656
Re: 1.5.0.5 very slow

If the count product query would be like this: SELECT COUNT(p.product_id) AS total,p2c.category_id FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p2c.product_id=...

Jump to post
  • Thu Jul 07, 2011 5:09 pm
  • Replies 74
  • Views 17656

Search found 31 matches