OpenCart Community

jan_00 wrote:hi
i use opencart 1.5.5.1 and i have a problem in filter of order in admin with date modified when i use it i get this error

Notice: Error: Unknown column 'o.date_modified' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM `oc_order` WHERE order_status_id > '0' AND DATE(o.date_modified) = DATE('2013-02-02') in **********************system\database\mysql.php on line 50

how can i fix it?
thanks

Cosmological wrote:I'm having a problem with maintenance mode. Vanilla install, no templates or mods installed.
Issue is that I'm still able to browse categories and products whilst the site is in maintenance mode - when it's set to use SEO URLs. Only the products and/or categories that have SEO links assigned are affected - other products, categories and pages - including the home page - cannot be accessed; the maintenance mode text is displayed, as it should be.
I've replicated this issue over two entirely different installs. It is not caused by my being logged in - I can access the products that have SEO URLs assigned from an entirely different machine (so not a session / cache issue either).
Apologies if I'm being a total dunce here and overlooking something obvious.

Dan

Then I upload a themeforest theme (OXY), everything fine, except for this error

ADD Creative wrote:Do you have any examples that always cause the problem? If you give me the product prices, quantities and totals that cause the error, I'll try to recreate it.

order9.jpg (104.96 KiB) Viewed 10224 times

order10.jpg (98.19 KiB) Viewed 10224 times

ADD Creative wrote:Thanks for the information. I've tracked down the issue.

Try changing the following in catalog/controller/payment/pp_standard.php (or your vQmod)

Code: Select all

$total = $this->currency->format($order_info['total'], $order_info['currency_code'], false, false) - $subtotal;

to

Code: Select all

$total = $this->currency->format($this->currency->format($order_info['total'], $order_info['currency_code'], false, false) - $subtotal, $order_info['currency_code'], 1.0, false);

or even to this

Code: Select all

$total = $this->currency->format($this->currency->convert($order_info['total'], $this->config->get('config_currency'), $order_info['currency_code']) - $subtotal, $order_info['currency_code'], 1.0, false);

rupaknepali wrote:After adding the product when we click on checkout and then instantly click some link then a popup with error message is shown.

I have clicked the Checkout and instantly click the shopping cart link

PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' AND date_start <= NOW() AND date_end >= NOW() ORDER BY priority LIMIT 0,1' at line 2<br />Error No: 1064<br />SELECT date_end FROM oc_product_special
WHERE product_id ='60'"' AND date_start <= NOW() AND date_end >= NOW() ORDER BY priority LIMIT 0,1 in /vqmod/vqcache/vq2-system_database_mysql.php on line 71

ADD Creative wrote:The problem looks to be:

Code: Select all

product_id ='60'"'

However I can find no SQL queries in the 1.5.5 code matching your error, so look like it's a problem with a modification.

frankleng wrote:

ADD Creative wrote:The problem looks to be:

Code: Select all

product_id ='60'"'

However I can find no SQL queries in the 1.5.5 code matching your error, so look like it's a problem with a modification.

Thanks. Do you mean a vqmod caused this problem?
It will be hard for me to find the solution. I don't know when this error would come out.
So, I don't know how to reproduce this error. I have many vqmods installed.

SELECT date_end FROM

Simply search with a qualified editor for:

Code: Select all

SELECT date_end FROM

in all files you have on your server / shop.
May need a few seconds, but you will find that phrase.

<?php
class ModelModuleSpecialPriceCountDown extends Model {
	
	public function getSpecialPriceEndData($product_id) {
		if ($this->customer->isLogged()){
			$customer_group_id = $this->customer->getCustomerGroupId();
		} else {
			$customer_group_id = 0;
		}
		
		$sql = "SELECT date_end FROM " . DB_PREFIX . "product_special 
				WHERE product_id ='" . $product_id . "' AND date_start <= NOW() AND date_end >= NOW() ORDER BY priority ";
		if ($customer_group_id){
			$sql .= " AND customer_group_id ='" . $customer_group_id . "'";
		}
		
		$sql .= "LIMIT 0,1";
		
		$query = $this->db->query($sql);
		
		if ($query->num_rows){
			return $query->row['date_end'];
		} else {
			return 0;
		}		
			
	}	
}
?>