Edit History

esto dice el día 15 cuando active el Debug

On 1/15/2019 at 9:11 AM, Pedro said:

si activo: 

/* Debug only */
define('_PS_MODE_DEV_', true);

sale esto:

[PrestaShopDatabaseException]

Duplicate entry '18274-1' for key 'PRIMARY'
 

INSERT INTO ps_referrer_cache (id_referrer, id_connections_source) (
					SELECT id_referrer, id_connections_source
					FROM ps_referrer r
					LEFT JOIN ps_connections_source cs ON ((r.http_referer_like IS NULL OR r.http_referer_like = '' OR cs.http_referer LIKE r.http_referer_like)
			AND (r.request_uri_like IS NULL OR r.request_uri_like = '' OR cs.request_uri LIKE r.request_uri_like)
			AND (r.http_referer_like_not IS NULL OR r.http_referer_like_not = '' OR cs.http_referer NOT LIKE r.http_referer_like_not)
			AND (r.request_uri_like_not IS NULL OR r.request_uri_like_not = '' OR cs.request_uri NOT LIKE r.request_uri_like_not)
			AND (r.http_referer_regexp IS NULL OR r.http_referer_regexp = '' OR cs.http_referer REGEXP r.http_referer_regexp)
			AND (r.request_uri_regexp IS NULL OR r.request_uri_regexp = '' OR cs.request_uri REGEXP r.request_uri_regexp)
			AND (r.http_referer_regexp_not IS NULL OR r.http_referer_regexp_not = '' OR cs.http_referer NOT REGEXP r.http_referer_regexp_not)
			AND (r.request_uri_regexp_not IS NULL OR r.request_uri_regexp_not = '' OR cs.request_uri NOT REGEXP r.request_uri_regexp_not))
					WHERE id_connections_source = 18274
				)

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. 	/**

• DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 453 - classes/db/Db.php] - [1 Arguments]
• DbCore->execute - [line 101 - classes/Referrer.php] - [1 Arguments]
• ReferrerCore::cacheNewSource - [line 54 - classes/ConnectionsSource.php] - [1 Arguments]
• ConnectionsSourceCore->add - [line 98 - classes/ConnectionsSource.php] - [0 Argument]
• ConnectionsSourceCore::logHttpReferer - [line 138 - modules/statsdata/statsdata.php] - [0 Argument]
• StatsData->hookFooter - [line 459 - classes/Hook.php] - [1 Arguments]
• HookCore::exec - [line 769 - classes/controller/FrontController.php] - [1 Arguments]
• FrontControllerCore->initFooter - [line 172 - classes/controller/Controller.php] - [0 Argument]
• ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
• DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]