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, [url removed, login to view], [url removed, login to view] 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 [url removed, login to view] IS NOT NULL

ORDER BY c.date_add DESC

at line 791 in file classes/db/[url removed, login to view]

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/[url removed, login to view]] - [1 Arguments]

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

DbCore->executeS - [line 122 - classes/[url removed, login to view]] - [1 Arguments]

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

AdminCustomersControllerCore->renderView - [line 2059 - classes/controller/[url removed, login to view]]

AdminControllerCore->initContent - [line 209 - controllers/admin/[url removed, login to view]]

AdminCustomersControllerCore->initContent - [line 189 - classes/controller/[url removed, login to view]]

ControllerCore->run - [line 367 - classes/[url removed, login to view]]

DispatcherCore->dispatch - [line 58 - admin/[url removed, login to view]]

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:
( 0 reviews ) Germany

Project ID: #14428003

12 freelancers are bidding on average €36 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
(122 Reviews)
7.0
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
(66 Reviews)
6.2
nsweb

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

€30 EUR in 1 day
(20 Reviews)
5.3
€23 EUR in 1 day
(29 Reviews)
4.8
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.0
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.5
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
(2 Reviews)
1.3
brownique

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

€28 EUR in 0 days
(0 Reviews)
0.0
munishkmr60

A proposal has not yet been provided

€29 EUR in 1 day
(0 Reviews)
0.0
CR7777

Dear hiring manager, Hope you are doing well!! I have gone through the project description. As per the given brief you are looking for a Web expert cum Designer to build a site Responsive site. I am a professional W More

€20 EUR in 1 day
(0 Reviews)
0.0
poojamishra13

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

€29 EUR in 2 days
(1 Review)
0.0