Bukimedia / PrestaSharp

CSharp .Net client library for the PrestaShop API via web service
GNU General Public License v3.0
155 stars 153 forks source link

Error updating product utf-8 support #341

Closed fantonifra closed 5 years ago

fantonifra commented 5 years ago

Hi, using Prestashop after I upgrade MySql from 5.5 to 8.0.11 and Php from 5.6 to 7.0 (7.1 or 7.2) I got an error updating a product with ProductFactory.

I investigated deeply and I found this error in prestahop log: ERROR v1.7.2.4 2019/01/30 - 16:41:18: Link to database cannot be established:SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers at line 102 in file classes/db/DbPDO.php

in DbPdo.php the exception is raised here: public function connect() { try { $this->link = $this->_getPDO($this->server, $this->user, $this->password, $this->database, 5); } catch (PDOException $e) { throw new PrestaShopException('Link to database cannot be established:'.$e->getMessage()); }

It seems this issue is related to the utf8 support; we found several post in internet about this but no one help us to fix it. We tried also to use old versione of php but without result. Do you have a suggestion? Thanks in advance Francesco

mowcixo commented 5 years ago

It seems to be related with your server configuration, since issues are made for reporting problems with PrestaSharp library I would refer you to PrestaShop Issues

Feel free to comment your problem in our Slack group, under the #general topic too: https://join.slack.com/t/prestasharp/shared_invite/enQtNTM2OTI1OTg0NzUyLTY4NDdkZDFmY2EwMGE4MTMzZjk5YzZiMTk3MzUwNzUxNTdhMWEwZjFjNDJiZTIyMjI0MDM0NTcwMzIzNGI0Njc

lock[bot] commented 4 years ago

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.