Post by i2Paq » Sat Mar 13, 2010 1:50 am

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.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by rph » Sat Mar 13, 2010 3:49 am

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'])) . "%'";
      }

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by RonA » Sat Mar 13, 2010 7:51 am

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.)
Last edited by i2Paq on Sat Mar 13, 2010 3:10 pm, edited 1 time in total.
Reason: Split from OpenCart v1.4.3

New member

Posts

Joined
Tue Mar 09, 2010 4:11 pm

Post by RonA » Sat Mar 13, 2010 8:05 am

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.

New member

Posts

Joined
Tue Mar 09, 2010 4:11 pm

Post by Freddo » Sat Mar 13, 2010 9:23 am

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
Last edited by i2Paq on Sat Mar 13, 2010 3:10 pm, edited 1 time in total.
Reason: Split from OpenCart v1.4.3

Newbie

Posts

Joined
Thu Mar 11, 2010 12:17 pm

Post by MatthewMN » Sat Mar 13, 2010 12:25 pm

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--
Last edited by i2Paq on Sat Mar 13, 2010 3:07 pm, edited 1 time in total.
Reason: Split from OpenCart v1.4.3

Newbie

Posts

Joined
Sun Dec 06, 2009 10:55 am

Post by OSWorX » Sat Mar 13, 2010 2:47 pm

Because of the deletion of some variables, the sales report (dropdown) looks like this:
sales_missing_text.png

sales_missing_text.png (2.86 KiB) Viewed 7311 times


Forum Rules [en]: viewtopic.php?f=176&t=200480
Commercial Request: viewforum.php?f=88
Dedicated Support: https://dedicated.opencart.com/
Marketplace Support: https://www.opencart.com/index.php?rout ... rt/support
Documentation: http://docs.opencart.com/en-gb/extension/theme/

Image Image Image


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by OSWorX » Sat Mar 13, 2010 3:00 pm

install.php line 17:

Code: Select all

mysql_query("SET CHARATER SET utf8", $connection);

Forum Rules [en]: viewtopic.php?f=176&t=200480
Commercial Request: viewforum.php?f=88
Dedicated Support: https://dedicated.opencart.com/
Marketplace Support: https://www.opencart.com/index.php?rout ... rt/support
Documentation: http://docs.opencart.com/en-gb/extension/theme/

Image Image Image


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by OSWorX » Sat Mar 13, 2010 3:40 pm

Code: Select all

(200, 14, 'KAR', 'Kärnten'),
(201, 14, 'NOS', 'Nieder&ouml;esterreich'),
(202, 14, 'OOS', 'Ober&ouml;esterreich'),
This is an error since many versions - when will this be solved??

Forum Rules [en]: viewtopic.php?f=176&t=200480
Commercial Request: viewforum.php?f=88
Dedicated Support: https://dedicated.opencart.com/
Marketplace Support: https://www.opencart.com/index.php?rout ... rt/support
Documentation: http://docs.opencart.com/en-gb/extension/theme/

Image Image Image


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by lillolollo » Sat Mar 13, 2010 4:21 pm

europe invoice-vat bug an veeeeeeeeery older bug.......

New member

Posts

Joined
Wed May 13, 2009 11:12 am

Post by Daniel » Sat Mar 13, 2010 6:17 pm

lillolollo wrote:europe invoice-vat bug an veeeeeeeeery older bug.......
what invoice vat bug?

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by Daniel » Sat Mar 13, 2010 6:20 pm

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?

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by Daniel » Sat Mar 13, 2010 6:24 pm

ok i haver done all fixes execpt for the mail one and invoice one because i'm not sure they are bugs.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by Daniel » Sat Mar 13, 2010 6:29 pm

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.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by i2Paq » Sat Mar 13, 2010 6:33 pm

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.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by lillolollo » Sat Mar 13, 2010 6:35 pm


New member

Posts

Joined
Wed May 13, 2009 11:12 am

Post by Daniel » Sat Mar 13, 2010 6:44 pm

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.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by MatthewMN » Sat Mar 13, 2010 10:44 pm

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.

Newbie

Posts

Joined
Sun Dec 06, 2009 10:55 am

Post by lillolollo » Sat Mar 13, 2010 11:04 pm

Daniel in b2b all Eu customers use vat

New member

Posts

Joined
Wed May 13, 2009 11:12 am

Post by Daniel » Sat Mar 13, 2010 11:35 pm

its still a feature request and not a bug!

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm
Who is online

Users browsing this forum: No registered users and 2 guests