OpenCart 1.5.6.1 BUG topic - Read first post first!

admin/conroller/sale/voucher.php
Line 249
&sort=v.date_end should be &sort=v.status

There is a bug in the admin order filter for the Date modified.

PHP Notice: Error: Unknown column 'o.date_modified' in 'where clause'<br />Error No: 1054<br />SELECT COUNT(*) AS total FROM `ltc_order` WHERE order_status_id > '0' AND DATE(o.date_modified) = DATE('2014-03-04') in /home/letricor/public_html/system/database/mysql.php on line 50

I fixed by replacing the "o.date_modified" instances with "date_modified" in the admin/model/sale/order.php

I don't know if this will have any unwanted effects on other functionalities.

So, basically 1.5.6.1 is not ready?

I just did a fresh install and really don't feel comfortable having to make all these little changes to get it to work.

I guess install with mysql instead of mysqli?

Can someone give a clear statement on this? Not ready?

Basically 1.5.6.1 is the latest stable verson of the 1.5.x series.
While it can happen that an - until now - not detected bug could be discovered.
Experienced users can have a look at the GitHub project site could help:
https://github.com/opencart/opencart/tree/v1.5.6.1

to check if that bug - if it is - is solved.
If not, opening a new issue can help.

Hello,

when you go to specials page: /index.php?route=product/special on a clean installation and try to Sort By: Price (Low > High) the result is High > Low and when I Sort By: Price (High > Low) the result is Low > High. It give the opposite result.

ddowdall wrote: My server is using php 5.x and mysqli was installed with php.

Front end errors:
Notice: Trying to get property of non-object in /v1561/index.php on line 52
Notice: Trying to get property of non-object in /v1561/index.php on line 61
Warning: Invalid argument supplied for foreach() in /v1561/index.php on line 61
Notice: Trying to get property of non-object in /v1561/index.php on line 69
Fatal error: Call to a member function get() on a non-object in /v1561/index.php on line 103


Back end errors:
Notice: Trying to get property of non-object in /v1561/admin/index.php on line 43
Warning: Invalid argument supplied for foreach() in /v1561/admin/index.php on line 43

Got the same error ad was solved by changing the php version to 5.5

[quote="ddowdall"]Hi,

I did a fresh install of 1.5.6.1 and selected mysqli as the driver. After install was done I see errors in both the front and back end of the website and most content is missing. When I change config.php to use mysql instead of mysqli all of the errors go away and the site is working properly.

My server is using php 5.x and mysqli was installed with php.

Front end errors:
Notice: Trying to get property of non-object in /v1561/index.php on line 52
Notice: Trying to get property of non-object in /v1561/index.php on line 61
Warning: Invalid argument supplied for foreach() in /v1561/index.php on line 61
Notice: Trying to get property of non-object in /v1561/index.php on line 69
Fatal error: Call to a member function get() on a non-object in /v1561/index.php on line 103


Back end errors:
Notice: Trying to get property of non-object in /v1561/admin/index.php on line 43
Warning: Invalid argument supplied for foreach() in /v1561/admin/index.php on line 43[/quote

I had this error, it was solved by changing the default PHP version to 5.2 in .httaccess and using the MYSQL driver instead of the MYSQLi one.