Page 1 of 4
Post OpenCart 1.4.3 Bugs Here!
Posted: Sat Mar 13, 2010 1:50 am
by i2Paq
Please post here all bugs (and those you think they are bugs) found in the release 1.4.3 from the 12th of March 2010.
Re: Post OpenCart 1.4.3 Bugs Here!
Posted: Sat Mar 13, 2010 3:49 am
by rph
Looks like a 1.4.2 bug got missed.
Bug: Admin product filtering isn't returning the proper number of pages. The filter function is not case sensitive while calculating the number of products returned is.
/admin/model/catalog/product.php
public function getTotalProducts
Code: Select all
if (isset($data['filter_name']) && !is_null($data['filter_name'])) {
$sql .= " AND pd.name LIKE '%" . $this->db->escape($data['filter_name']) . "%'";
}
if (isset($data['filter_model']) && !is_null($data['filter_model'])) {
$sql .= " AND p.model LIKE '%" . $this->db->escape($data['filter_model']) . "%'";
}
fix
Code: Select all
if (isset($data['filter_name']) && !is_null($data['filter_name'])) {
$sql .= " AND LCASE(pd.name) LIKE '%" . $this->db->escape(strtolower($data['filter_name'])) . "%'";
}
if (isset($data['filter_model']) && !is_null($data['filter_model'])) {
$sql .= " AND LCASE(p.model) LIKE '%" . $this->db->escape(strtolower($data['filter_model'])) . "%'";
}
OpenCart v1.4.3
Posted: Sat Mar 13, 2010 7:51 am
by RonA
I just upgraded from 1.4.2 to 1.4.3 and everything seems OK EXCEPT I still have the issue where the products don't load if I omit the www. from the web address. Did I forget to do something?
( I'm sure I'm running 1.4.3 because it says so at the bottom of the admin page.)
Shipping Options encryption
Posted: Sat Mar 13, 2010 8:05 am
by RonA
Just noticed this in 1.4.3:
If I click on the checkout TAB' at the top of the page, I'm taken to secure 'shipping options' page. BUT If I'm logged in and I click on the 'checkout' BUTTON at the bottom of the 'View Cart' page, I'm taken to a shipping options page that is NOT secure.
Re: OpenCart v1.4.3
Posted: Sat Mar 13, 2010 9:23 am
by Freddo
RonA wrote:I just upgraded from 1.4.2 to 1.4.3 and everything seems OK EXCEPT I still have the issue where the products don't load if I omit the www. from the web address. Did I forget to do something?
( I'm sure I'm running 1.4.3 because it says so at the bottom of the admin page.)
The easiest way to fix this is to use an apache redirect that redirects all
http://www.yourdomain.com to yourdomain.com. That way no surfer uses www. anymore
OpenCart v1.4.3
Posted: Sat Mar 13, 2010 12:25 pm
by MatthewMN
I hope it is OK that I'm posting this here. I just spent half a day upgrading from 1.4.0 to 1.4.3 to find out the same SMTP e-mail issue exists (I can't use the recommended "Mail" option). E-mails get sent from the Windows web server and you can read the subject but the body text doesn't show. If you look at the raw data you can see the text but you can't expect customers to know this. Here is the raw data from a test e-mail:
Return-Path: <
myemail@dontspam.com>
Received: from 216-10-249-50.mysite4now.com [216.10.249.50] by mx251o.mysite4now.com with SMTP;
Fri, 12 Mar 2010 19:57:05 -0800
To:
myemail@dontspam.com
Subject: Enquiry matt
From: matt<
myemail@dontspam.com>
Reply-To: matt<
myemail@dontspam.com>
Return-Path:
myemail@dontspam.com
X-Mailer: PHP/5.2.0
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="----=_NextPart_af29d3ec0ce755c9a401b3fa3bdb4560"
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit
X-SmarterMail-TotalSpamWeight: 0 (Authenticated)
test
test
test
------=_NextPart_af29d3ec0ce755c9a401b3fa3bdb4560--
Missing text vars
Posted: Sat Mar 13, 2010 2:47 pm
by OSWorX
Because of the deletion of some variables, the sales report (dropdown) looks like this:
sales_missing_text.png (2.86 KiB) Viewed 10195 times
Install script: wrong sql command
Posted: Sat Mar 13, 2010 3:00 pm
by OSWorX
install.php line 17:
Code: Select all
mysql_query("SET CHARATER SET utf8", $connection);
opencart.sql - wrong encoding/typo
Posted: Sat Mar 13, 2010 3:40 pm
by OSWorX
Code: Select all
(200, 14, 'KAR', 'Kärnten'),
(201, 14, 'NOS', 'Niederöesterreich'),
(202, 14, 'OOS', 'Oberöesterreich'),
This is an error since many versions - when will this be solved??
Re: Post OpenCart 1.4.3 Bugs Here!
Posted: Sat Mar 13, 2010 4:21 pm
by lillolollo
europe invoice-vat bug an veeeeeeeeery older bug.......
Re: Post OpenCart 1.4.3 Bugs Here!
Posted: Sat Mar 13, 2010 6:17 pm
by Daniel
lillolollo wrote:europe invoice-vat bug an veeeeeeeeery older bug.......
what invoice vat bug?
Re: OpenCart v1.4.3
Posted: Sat Mar 13, 2010 6:20 pm
by Daniel
MatthewMN wrote:I hope it is OK that I'm posting this here. I just spent half a day upgrading from 1.4.0 to 1.4.3 to find out the same SMTP e-mail issue exists (I can't use the recommended "Mail" option). E-mails get sent from the Windows web server and you can read the subject but the body text doesn't show. If you look at the raw data you can see the text but you can't expect customers to know this. Here is the raw data from a test e-mail:
Return-Path: <
myemail@dontspam.com>
Received: from 216-10-249-50.mysite4now.com [216.10.249.50] by mx251o.mysite4now.com with SMTP;
Fri, 12 Mar 2010 19:57:05 -0800
To:
myemail@dontspam.com
Subject: Enquiry matt
From: matt<
myemail@dontspam.com>
Reply-To: matt<
myemail@dontspam.com>
Return-Path:
myemail@dontspam.com
X-Mailer: PHP/5.2.0
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="----=_NextPart_af29d3ec0ce755c9a401b3fa3bdb4560"
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit
X-SmarterMail-TotalSpamWeight: 0 (Authenticated)
test
test
test
------=_NextPart_af29d3ec0ce755c9a401b3fa3bdb4560--
could your problem be that the dontspam.com. is full of spam advertising?
Re: Post OpenCart 1.4.3 Bugs Here!
Posted: Sat Mar 13, 2010 6:24 pm
by Daniel
ok i haver done all fixes execpt for the mail one and invoice one because i'm not sure they are bugs.
Re: OpenCart v1.4.3
Posted: Sat Mar 13, 2010 6:29 pm
by Daniel
RonA wrote:I just upgraded from 1.4.2 to 1.4.3 and everything seems OK EXCEPT I still have the issue where the products don't load if I omit the www. from the web address. Did I forget to do something?
( I'm sure I'm running 1.4.3 because it says so at the bottom of the admin page.)
pelase post a link to your site.
Re: Post OpenCart 1.4.3 Bugs Here!
Posted: Sat Mar 13, 2010 6:33 pm
by i2Paq
Daniel wrote:lillolollo wrote:europe invoice-vat bug an veeeeeeeeery older bug.......
what invoice vat bug?
He talks about that the invoice-numbering is not according to EU-laws.
This is not realy a bug but it is a LARGE issue.
Invoicenumber(s) not correct according to EU law.
Re: Post OpenCart 1.4.3 Bugs Here!
Posted: Sat Mar 13, 2010 6:35 pm
by lillolollo
Re: Post OpenCart 1.4.3 Bugs Here!
Posted: Sat Mar 13, 2010 6:44 pm
by Daniel
this is a feature request. not all EU countries require that a customer uses a VAT number when buying stuff. I will add it though because its quite simple to add.
Re: OpenCart v1.4.3
Posted: Sat Mar 13, 2010 10:44 pm
by MatthewMN
Daniel wrote:could your problem be that the dontspam.com. is full of spam advertising?
I replaced the actually e-mail address with a fake one so I didn't get added to any spam lists. I have tried sending to an address of the domain we own and also to Yahoo addresses. Both have the same problem. If anyone has a simple PHP file they would like me to test the SMTP e-mail with I would be happy to do that. I have experience programming in .net but my PHP knowledge lacks. Thanks for replying Daniel.
Re: Post OpenCart 1.4.3 Bugs Here!
Posted: Sat Mar 13, 2010 11:04 pm
by lillolollo
Daniel in b2b all Eu customers use vat
Re: Post OpenCart 1.4.3 Bugs Here!
Posted: Sat Mar 13, 2010 11:35 pm
by Daniel
its still a feature request and not a bug!