Jump to content

Unknown column 'a.id_employee' in 'on clause'


blake5995

Recommended Posts

I turned error reporting on and I am getting this. I have been trying to track down why the "contact us" isnt working aswell as proceeding to checkout in the shopping cart. Thanks

 

		SELECT SQL_CALC_FOUND_ROWS
		 a.*
		, CONCAT(LEFT(e.firstname, 1), '. ', e.lastname) employee
		FROM `ps_log` a
		
		 LEFT JOIN ps_employee e ON (a.id_employee = e.id_employee) 
		
		WHERE 1 
		
		
		ORDER BY a.`id_log` ASC LIMIT 0,50

at line 613 in file classes/db/Db.php

 

607. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
608. 		}
609. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
610. 		{
611. 			if ($sql)
612. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
613. 			throw new PrestaShopDatabaseException($this->getMsgError());
614. 		}
615. 	}
616. 
617. 	/**
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...