*** Nevermind, I resolved the problem by changing the table row from text to longtext
Specials Sort By Price DESC doesnt work ?
[edit] it has been fixed by dev in svn now
daggerman1 wrote:Hi,
Thanks for a quick reply.
I have set both of them values to 1 on all of them. For I have a funny feeling it's something to do with nothing being in the coupon history tab. Surely this should populate when someone orders with that coupon ?
Maybe that's why it's allowing it a number of times.
Dan
I think this is indeed a genuine bug. For some reason the coupon history doesn't always get updated after an order is confirmed. The update of the coupon_history relies on a call to the function confirm in catalog/model/total/coupon.php which in turns calls the redeem function in catalog/model/checkout/coupon.php. The invocation of the function confirm is triggered by the successful payment which relied on payment success messages always being sent to the Opencart server. There may be sucessful payments for which Opencart does not receive the 'payment success' message from the external payment gateway. Hence there will likely be cases of missing coupon redemptions for otherwise successful and paid for orders.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I was doing a vQmod that affects all products modules (featured, best sellers, specials, latest) and noticed that all use $result as array for storing products from query, except featured module, that use $product_info for no known reason.
Because of this, I can't write a vQmod for file name="catalog/controller/module/*.php" and have to create 4 operations, 1 for each module, where 3 of them are exactly THE SAME! Insane...
Before you say I'm crazy for searching all .tpl files, the search string is simple and does not increase load (I search $this->data['products'][] to insert a new key in this array and set error="skip" for skipping modules that do not have this array at all). With this, I can add keys easily, for example, $result['stock'], which can be used for styling the products with/without stock.
I suggest you default it to $result array in all product modules. Will make my vQmodding life easier
The Sage Pay simulator will not show an error, but you can see the result by looking at the end of the decoded Crypt field data from the Sage Pay simulator.
This shows:
Code: Select all
...&DeliveryCity=Malmö&DeliveryPostCode=21222&DeliveryCountry=SE&DeliveryPhone=004612<BR>3456789&AllowGiftAid=0&Apply3DSecure
Code: Select all
...&DeliveryCity=Malmö&DeliveryPostCode=21222&DeliveryCountry=SE&DeliveryPhone=0046123<BR>456789&AllowGiftAid=0&Apply3DSecure=0
This is caused by the simpleXor fuction which gets the length of the data with utf8_strlen but then uses substr($string, $i, 1) to process which is not UTF-8 safe.
To fix in catalog\controller\payment\sagepay.php find:
Code: Select all
$this->data['crypt'] = base64_encode($this->simpleXor(implode('&', $crypt_data), $password));
Code: Select all
$this->data['crypt'] = base64_encode($this->simpleXor(utf8_decode(implode('&', $crypt_data)), $password));
Code: Select all
$output = $this->simpleXor($string, $password);
Code: Select all
$output = utf8_encode($this->simpleXor($string, $password));
Code: Select all
for ($i = 0; $i < utf8_strlen($password); $i++) {
$data[$i] = ord(substr($password, $i, 1));
}
$output = '';
for ($i = 0; $i < utf8_strlen($string); $i++) {
$output .= chr(ord(substr($string, $i, 1)) ^ ($data[$i % utf8_strlen($password)]));
Code: Select all
for ($i = 0; $i < strlen($password); $i++) {
$data[$i] = ord(substr($password, $i, 1));
}
$output = '';
for ($i = 0; $i < strlen($string); $i++) {
$output .= chr(ord(substr($string, $i, 1)) ^ ($data[$i % strlen($password)]));
admin > reports > sales > orders
needs to be optimized for the underlying DB queries. For example, when we tried it on an Opencart database with roughly 10 000 orders, it simply maxes out the the CPU for several minutes and evenatually times out without ever finishing the request.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
A question mark � is shown at the end of the short description of list of products.
Like this: http://www.opencart.com/index.php?route ... order=DESC
How to change this?
Regards
But this is not an OpenCart 1.5.1.3 issue, but an extension store issue.
|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]
Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus
All mods & extensions by me
I have this problem on my OpenCart 1.5.1.3 Store:bull5-i wrote:This is probably an incomplete multibyte character issue. The description string has been truncated at byte level, not at character level, so the last multibyte charater is missing part of it.
But this is not an OpenCart 1.5.1.3 issue, but an extension store issue.
http://shop.cosmos-trade.net/index.php? ... path=59_60
I asket the bulgarian translation, but there were told me that the bug is in OpenCard and not in the extension, and will be fixed with the next update of the OpenCart plattform. So I would aks, where and how can I solve this problem?
|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]
Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus
All mods & extensions by me
Thanks for the answer, but this doesnt solve the problem - OpenCard 1.5.1.3 woks with mb_substr inbull5-i wrote:Use mb_substr in place of the regular substr.
catalog/controller/product/category.php
I found out how to fix this bug:
Find the line with:
Code: Select all
'description' => mb_substr(strip_tags(html_entity_decode($result['description'], ENT_QUOTES, 'UTF-8')), 0, 100) . '..',
Code: Select all
'description' => mb_substr(strip_tags(html_entity_decode($result['description'], ENT_QUOTES, 'UTF-8')), 0, 100 ,"UTF-8") . '..',
you said nothing about my last suggestions. I understand some of them are 'preciosism', but this simple change is something that all those who make large use of customer grouping wants for sure:
in system/library/cart.php replace
Code: Select all
if ($product_special_query->num_rows) {
Code: Select all
if ($product_special_query->num_rows AND ($product_special_query->row['price'] < $price)) {
Version OC 1.5.1.3.1
The error:
2012-02-16 14:42:53 - PHP Notice: Undefined index: bits in /home/hobby/public_html/system/library/image.php on line 16
lv2dr65 wrote:Error in system log. Don't know if it's a bug but worth checking out. This started showing up after our shop exceeded 10K images. if we delete it in comes back.
Version OC 1.5.1.3.1
The error:
2012-02-16 14:42:53 - PHP Notice: Undefined index: bits in /home/hobby/public_html/system/library/image.php on line 16
this is an exectuion time issue. i have updated the image manager in the next version to avoid this.
OpenCart®
Project Owner & Developer.
1) Admin section product searches doesn't fully work. E.g. If you want to find "Nike air max" typing "air max" returns no results.
2) Store front products template - the layout is a bit screwed up see attachment
3) The home page banner doesn't fade in/out properly - hard to demo when shop isn't live
4) If you add more than 2 product option select boxes to a product they get out of line - see screenshot
5) Add a product to cart and the shopping cart total at the top of the page stays at 0.00 unless you refresh the page
Attachments
pic2.jpg (17.01 KiB) Viewed 7290 times
pic1.jpg (20.95 KiB) Viewed 7290 times
The search in OC 1.5 is implemented to start searching from the start of the string not in the middle. So you need to start typing from "Nike...".1) Admin section product searches doesn't fully work. E.g. If you want to find "Nike air max" typing "air max" returns no results.
|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]
Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus
All mods & extensions by me
If that's a feature then i really dont like it. I love OC but i dont like that.bull5-i wrote:The search in OC 1.5 is implemented to start searching from the start of the string not in the middle. So you need to start typing from "Nike...".1) Admin section product searches doesn't fully work. E.g. If you want to find "Nike air max" typing "air max" returns no results.
Many of my products are very similarly named e.g.
Nike Air Max "Diablo" Trainers - blue/red
Nike Air Max "Sprint" Trainers - White/blue
I dont want to have to type all of that when i could just type "diablo".
What is the resoning behind this change - the old search worked perfectly imo?
Then, all you need is to start with a wild card as well:
%air or %diablo will show you the desired results.
actually, % will list ALL products. You don't even need to type a letter.
Check the attached screenshots
"We help each other to grow". That's the opencart community!
All free mods
Home Based Ebay business Opportunity(not ads)
Users browsing this forum: Baidu [Spider] and 130 guests