OpenCart Community

OpenCart Community Forum - Discuss shopping cart and e-commerce solutions.
https://forum.opencart.com/

Post any OpenCart 1.4.8/1.4.8b Bugs here!

https://forum.opencart.com/viewtopic.php?t=16053

Page 10 of 16

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Tue Jul 13, 2010 3:44 am
by Qphoria
it was fixed in 1.4.8b

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Tue Jul 13, 2010 10:41 pm
by Xsecrets
Need to add indexes to product_id in product_special, product_review, and product_discount tables. I just had a customer who was having SEVERE slowdown problems and I traced it back to query from the specials box. It was fixed by adding these indexes so that all joins could use an index.

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Thu Jul 15, 2010 6:12 am
by Maaris
I read in previous (1.4.6) bug forums a discussion about need to implement "set time zone" function. Is there something new about this issue? Googleing did not gave me the answer. I tried to add date.timezone to php.ini (both in root and admin folders) however, problem was not solved... :( Any help is much appreciated!

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Thu Jul 15, 2010 1:05 pm
by fido-x
Although you should be able to set your default timezone using the php.ini file, in practice, this does not work. To set a default timezone, you will need to edit "system/startup.php".

At lines 46 to 48, you'll find the following:

Code: Select all

if (!ini_get('date.timezone')) {
    date_default_timezone_set('UTC');
} 
Change 'UTC' to the timezone you wish to use. You can find a list of supported timezones at http://www.php.net/manual/en/timezones.php.

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Thu Jul 15, 2010 6:21 pm
by alimname
Orders to be canceled or refunded but total sales and total orders in the admin panel does not fix

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Fri Jul 16, 2010 2:25 am
by Maaris
fido-x wrote:Although you should be able to set your default timezone using the php.ini file, in practice, this does not work. To set a default timezone, you will need to edit "system/startup.php".

At lines 46 to 48, you'll find the following:

Code: Select all

if (!ini_get('date.timezone')) {
    date_default_timezone_set('UTC');
} 
Change 'UTC' to the timezone you wish to use. You can find a list of supported timezones at http://www.php.net/manual/en/timezones.php.
Thank you fido-x! Unfortunately this did not work. I was thinking, maybe I could edit "mode/checkout/order.php" (and some other files that use date) where it says:

Code: Select all

$this->db->query("INSERT INTO `" . DB_PREFIX . "order` SET 
------------------
.................. ...........
------------------
 date_modified = NOW(), date_added = NOW()");
But I don't know how to edit NOW() function to add some hours to it.

edit: I apologize if this kind of discussion belongs to another thread, as this is not a bug in reality... I'm just having trouble with the fact that my server is in US and shop is in Europe. This makes some troubles with correct invoice dates when someone purchases when I'm already in today, but server is still in yesterday...

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Fri Jul 16, 2010 3:37 am
by OSWorX
Well it is quite a pitty shame that OpenCart does NOT provide a config setting to adjust the server time!
But - maybe - the developers will learn also this lesson.

Here about the date/time functions in MySQL: http://dev.mysql.com/doc/refman/5.1/en/ ... tions.html

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Fri Jul 16, 2010 4:50 am
by Maaris
Thank You, thank You Thank you OSWorX. I figured it out :)

I modified end of that string fom:

Code: Select all

date_modified = NOW(), date_added = NOW()
to

Code: Select all

date_modified = CONVERT_TZ(NOW(),'-06:00','+02:00'), date_added = CONVERT_TZ(NOW(),'-06:00','+02:00')
where "-06:00" - server time zone and "+02:00" - my local time zone

and it works just fine.Will have to manually modify If my time zone will end daylight savings at different time than server zone, but this is a good temp (nothing is so stable as temp)solution for me.

Thank You!

Will have to figure out now other files to modify. Probably when admin edits order or changes status... did I missed something?

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Fri Jul 16, 2010 5:55 am
by Johnathan
Not sure if this is a bug...but I just noticed that the file /admin/view/template/sale/order_invoices.tpl isn't used when selecting multiple invoices. Perhaps this file used to be used but isn't any more? If this is the case, it should be removed from the installation package.

Template & CSS

Posted: Fri Jul 16, 2010 6:43 am
by Maansy
hi to all,
i havent read all the bug report thread and if this had been addressed before then gladly point me to the fix if there is.
anyhow, going through the designing stage of my 1sf template i noticed there are so many files (.tpl and .php) has the control over the bg color or font color or other thing that it should have already been controlled by the .CSS file.
also i noticed that some images are directly calling the origenal template from the .tpl (which it should call the images that are associated with the template since the new template has its own image folder) even if i am using the new template.
maybe this should be sort out in 1.49
thanks :)

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Fri Jul 16, 2010 8:18 am
by Xsecrets
yeah the inline styles have been mentioned a few times. At one point someone even created a theme with all the inline styles removed, but a new version was out with alot of changes before it could be integrated in the core. It would be really nice to get this fixed up.

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Fri Jul 16, 2010 7:51 pm
by JAY6390
in /admin/controller/catalog/review.php the following line is duplicated in the validateForm() method. There should only be one of these really

Code: Select all

        if ((strlen(utf8_decode($this->request->post['text'])) < 25) || (strlen(utf8_decode($this->request->post['text'])) > 1000)) {
            $this->error['text'] = $this->language->get('error_text');
        } 

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Fri Jul 16, 2010 9:17 pm
by Qphoria
JAY6390 wrote:in /admin/controller/catalog/review.php the following line is duplicated in the validateForm() method. There should only be one of these really

Code: Select all

        if ((strlen(utf8_decode($this->request->post['text'])) < 25) || (strlen(utf8_decode($this->request->post['text'])) > 1000)) {
            $this->error['text'] = $this->language->get('error_text');
        } 
Fixed in next version. Thanks!

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Sat Jul 17, 2010 7:29 am
by Johnathan
Is /catalog/language/english/mail/order_update.php used at all? Because editing it doesn't seem to change the order update e-mail that goes out (at least for my store). The settings for the order update e-mail are in /admin/language/english/mail/order.php . What's the difference in these two files?

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Sat Jul 17, 2010 12:59 pm
by Johnathan
I'm not sure if this has been mentioned already: I was trying to edit shipping addresses for orders today, and I noticed everything updated except the postcode. I assume since the order editing is being rewritten for 1.4.9 this will be fixed, but does anyone have a 1.4.8 fix for now?

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Sat Jul 17, 2010 6:59 pm
by JAY6390
Yeah that has been noticed already :)

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Mon Jul 19, 2010 1:08 am
by Qphoria
Johnathan wrote:I'm not sure if this has been mentioned already: I was trying to edit shipping addresses for orders today, and I noticed everything updated except the postcode. I assume since the order editing is being rewritten for 1.4.9 this will be fixed, but does anyone have a 1.4.8 fix for now?
Post code not saving for shipping address

Catalog - Product / Guest Checkout: Subtract not respected

Posted: Mon Jul 19, 2010 3:32 pm
by OSWorX
../catalog/controller/checkout/guest_step3.php around line 170:

In the array $product_data following is missing:

Code: Select all

'subtract'   => $product['subtract'],

Re: Catalog - Product / Guest Checkout: Subtract not respect

Posted: Mon Jul 19, 2010 7:30 pm
by Qphoria
OSWorX wrote:../catalog/controller/checkout/guest_step3.php around line 170:

In the array $product_data following is missing:

Code: Select all

'subtract'   => $product['subtract'],
That is no longer used and was "partially" removed in 1.4.8b and will be completely removed in 1.4.9

Re: Post any OpenCart 1.4.8/1.4.8b Bugs here!

Posted: Mon Jul 19, 2010 11:26 pm
by Johnathan
Qphoria wrote:
Johnathan wrote:I'm not sure if this has been mentioned already: I was trying to edit shipping addresses for orders today, and I noticed everything updated except the postcode. I assume since the order editing is being rewritten for 1.4.9 this will be fixed, but does anyone have a 1.4.8 fix for now?
Post code not saving for shipping address
Thanks! Much appreciated -- I spent a little while trying to see if a fix had been mentioned already, but couldn't find it using the search function. Perhaps this bug and fix should be added to the first post on this thread?
All times are UTC+08:00
Page 10 of 16
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/