Closed

Prestashop Error

[PrestaShopDatabaseException]

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'like'

SELECT DISTINCT c.date_add, [login to view URL], [login to view URL] AS shop_name

FROM ps_guest g

LEFT JOIN ps_connections c ON c.id_guest = g.id_guest

LEFT JOIN ps_connections_source cs ON c.id_connections = cs.id_connections

LEFT JOIN ps_referrer r 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))

LEFT JOIN ps_shop s ON s.id_shop = c.id_shop

WHERE g.id_customer = 3

AND [login to view URL] IS NOT NULL

ORDER BY c.date_add DESC

at line 791 in file classes/db/[login to view URL]

786. if ($webservice_call && $errno) {

787. $dbg = debug_backtrace();

788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {

790. if ($sql) {

791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

792. }

793.

794. throw new PrestaShopDatabaseException($this->getMsgError());

795. }

796. }

DbCore->displayError - [line 425 - classes/db/[login to view URL]] - [1 Arguments]

DbCore->query - [line 643 - classes/db/[login to view URL]] - [1 Arguments]

DbCore->executeS - [line 122 - classes/[login to view URL]] - [1 Arguments]

ReferrerCore::getReferrers - [line 819 - controllers/admin/[login to view URL]] - [1 Arguments]

AdminCustomersControllerCore->renderView - [line 2059 - classes/controller/[login to view URL]]

AdminControllerCore->initContent - [line 209 - controllers/admin/[login to view URL]]

AdminCustomersControllerCore->initContent - [line 189 - classes/controller/[login to view URL]]

ControllerCore->run - [line 367 - classes/[login to view URL]]

DispatcherCore->dispatch - [line 58 - admin/[login to view URL]]

Skills: Prestashop

See more: paypalapi error prestashop 10002, paypal response error prestashop, paypal response paypal returned error prestashop, api error prestashop, authentication error prestashop, parse error prestashop, button error prestashop, bad subdomain sql query error prestashop, fatal error prestashop default language, paypal error prestashop, paypalapi error prestashop, carrier error prestashop, paypal payment error prestashop, ssl error prestashop, payment error prestashop, wordpress enable error log debug, prestashop debug, error 40036 application defined object defined error

About the Employer:
( 1 review ) Meckenheim, Germany

Project ID: #14428003

11 freelancers are bidding on average €37 for this job

jeevanoss

Hi, I am a Prestashop Expert. Last 4 years,most part of my work with Prestashop customization & module creation. Relevant Skills and Experience I have 9 years of experience in PHP,HTML, JavaScript & MySQL programming. More

€34 EUR in 0 days
(145 Reviews)
7.2
gopal1995

I am senior Prestashop & wordpress developer and having more than 8 years of experience.I am working only on prestashop around last 8 years Stay tuned, I'm is still working on this proposal.

€30 EUR in 1 day
(70 Reviews)
6.6
nsweb

Hello. I worked with Prestashop for the latest 4 years. Relevant Skills and Experience [login to view URL] [login to view URL] Proposed Milestones €30 EUR - Total

€30 EUR in 1 day
(28 Reviews)
5.5
€23 EUR in 1 day
(32 Reviews)
4.9
poojamishra13

Hello sir, i am prestashop experienced developer. i would like to fix this error. Thanks

€29 EUR in 2 days
(4 Reviews)
3.4
VnBestSolutions

Dear Sir. I had read your descriptions about project. Kindly give me a chance, i would like to discuss more about project and sure everything clear. Thank you ! Relevant Skills and Experience Skills: + CMS: Wordpress, More

€54 EUR in 1 day
(8 Reviews)
3.6
priortech

Hi there, I am ready to start Work on it Right Now. Kindly check PMB. More

€43 EUR in 0 days
(3 Reviews)
3.2
brownique

FIX SYSTEM PRESTASHOP ERROR Relevant Skills and Experience ERROR RESOLUTION PRESTASHOP Proposed Milestones €28 EUR - FULL

€28 EUR in 0 days
(1 Review)
1.4
ankur1024

Hi, Can i talk to you..? i have checked your requirements regarding to resolve both errors [as you share me on project description ] I'm ready to do it,because i have 7 + years exp. in Prestashop with all php More

€88 EUR in 1 day
(2 Reviews)
1.4
smartworkontime

Hi there I have seen your project requirement and I can surely help in your project, I am ready to start work right ASAP. Relevant Skills and Experience Website Design and Development Experts!!! Proposed Milestones More

€23 EUR in 0 days
(3 Reviews)
1.4
munishkmr60

A proposal has not yet been provided

€29 EUR in 1 day
(0 Reviews)
0.0