Search the Community

Hi, i am having an error to connect with database, but the error notification does not give any message just blank. I already checked my XAMPP port everything is default. Thanks in advance

Zdravím vás všetkých, čelým zas a raz nejakej chybe s PrestaShop-om a riešenie som na zahraničných fórach nenašiel, možno ste si tým už niekto prešli: Najprv vypisovalo len Internal Server Error 500, po spustení núdzového režimu v defines.inc.php sa chyba zmenila na nasledovnú: Link to database cannot be established: SQLSTATE[HY000] [2002] No route to host 122. public function connect() 123. { 124. try { 125. $this->link = $this->getPDO($this->server, $this->user, $this->password, $this->database, 5); 126. } catch (PDOException $e) { 127. throw new PrestaShopException('Link to database cannot be established: ' . $e->getMessage()); 128. } 129. 130. $this->link->exec('SET SESSION sql_mode = \'\''); 131. 132. return $this->link; DbPDOCore->connect - [line 330 - classes/db/Db.php] DbCore->__construct - [line 241 - classes/db/Db.php] - [4 Arguments] DbCore::getInstance - [line 47 - config/alias.php] pSQL - [line 340 - classes/shop/Shop.php] - [1 Arguments] ShopCore::initialize - [line 119 - config/config.inc.php] require - [line 27 - index.php] - [1 Arguments] Nastavenie v defines.php by malo byť v poriadku.

Hello, everyone, (I don't know if this is the good section so, I apologize if is not) I've just installed the PayPal payments module, connected the account, made a purchase - everything good till here. The problem is, when I'm trying to see the order details in the backend I get this error: Table 'ps_paypal_order' doesn't exist I assume the module should create some tables in the database but looks like that's not the case here. Can someone give me the dumps or data structure(so I can create them myself) for the module's tables ? (Or a solution/idea, if any) Thank you

Hi everybody, today I moved my prestashop store from the subfolder to the main folder and everything worked. After some time I got this error: Link to database can not be established: SQLSTATE [28000] [1045] Access denied, unknown user 'xxxxx' at line 102 in file classes / db / DbPDO.php However, I did not change anything in the database settings. And even after creating a new database, copying the backup and changing the settings.inc.php file did not change anything. Can you tell me where the problem might be? The Prestashop version is 1.6.1.6 and has been updated from version 1.3 several months ago through a 1-click module. Thank you for your advice and help.

Hi, I get PrestashopDatabaseException when I try to open in administration page with languages or with translations. Does anyone have idea what it could be? Thanks

Hello After upgrading my site I can't access any pages and get the following error message: Table 'prestashop_4.prstshp_smarty_last_flush' doesn't exist I've checked my database and it indeed does not exist, but I don't know what to do about it? Would really appreciate any advice. Scott

Hi, I'm upgrading from 1.4.7.3 to 1.6.0.9 using 1-click autoupgrade. But when start the Database Upgrade stop and show this Ajax error: "[Ajax / Server Error for action upgradeDb] textStatus: "error " errorThrown:" " jqXHR: " " NOTES: I had to change the system image folder because was using the old version (directory p, without subdirectorys). Now the img system is modern and haven't any problem viewing images. I'm using a local exactly copy of the online shop and have not problems upgrading from 1.4.7.3 to 1.4.11, but have the same error at same moment when upgrade from 1.4.11 to 1.6.0.9 or 1.5.0.1. The shop has 13.000 products and needs high resources but I think the parameters of mysql and php are ok. Can you help me?

Hallo Can somebody help me.. Today i open my website and i was presented with this error "The database selection cannot be made." I did not no anything as far as i remember, the symptoms just suddenly occur. I did try to find information, some says edit the "setting,inc.php" i did try that, recheck the db_name, user_name, pswd but nothing seems to work.. I am using hostgator as my hosting.. Any suggestion? Thanks Starch

I have version 1.5.4.1 Whenever I try to create a new customer the debug mode shows this: ======== [PrestaShopDatabaseException] Unknown column 'id_lang' in 'field list' INSERT INTO `ps_customer` (`secure_key`, `lastname`, `firstname`, `email`, `passwd`, `last_passwd_gen`, `id_gender`, `birthday`, `newsletter`, `newsletter_date_add`, `ip_registration_newsletter`, `optin`, `website`, `company`, `siret`, `ape`, `outstanding_allow_amount`, `show_public_prices`, `id_risk`, `max_payment_days`, `active`, `deleted`, `note`, `is_guest`, `id_shop`, `id_shop_group`, `id_default_group`, `id_lang`, `date_add`, `date_upd`) VALUES ('38777867199b6bac9102686dea9769e9', 'XXXX', 'XXXX', '[email protected]', '0a520d50a75bc07ca9c490ef8fba05d1', '2013-05-15 16:26:09', '1', '0000-00-00', '1', '2013-05-15 22:26:09', '90.183.7.182', '0', NULL, NULL, NULL, NULL, '0', '0', '0', '0', '1', '0', NULL, '0', '1', '1', '3', '1', '2013-05-15 22:26:09', '2013-05-15 22:26:09') at line 607 in file classes/db/Db.php 601. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);602. } 603. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 604. { 605. if ($sql) [color=#F20000][b]606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');[/b][/color] 607. throw new PrestaShopDatabaseException($this->getMsgError()); 608. } 609. } 610. 611. /**[/font][/color] ======== So id_lang doesn't exist in the DB... ? And now what ?

I have installed prestashops a couple weeks ago and it was working fine. Everything was working as it was supposed to but suddenly I log in a couple days ago and I saw a message saying the thecoverfaceshop.com was the connected domain and not www.thecoverfaceshop.com. I went in to the SEO & URL page and corrected it, (even though it was funny because it was working fine the way it was), now I can't access and of my other pages such as products or about us. Nothing but the Home page can be viewed. I go to the back end and can still see my products but not of the front side. I've tried to install prestashop on the different site but it's still not working. The website itself is not working correctly. I will try the newer version but not sure if it will work. If anyone could please help me!! I've been stomped for a couple days now. The domain of the first mentioned site is "www.thecoverfaceshop.com" and the new domain I'm trying to install is "www.visionzclothing.com" Thank you!

Hello, my website name is www.bespoketailoredleather.com in this website getting problem of Link to database cannot be established. from last 48 hours i checked thrice database setting on config then also read other forums then also i not get any help can anybody help me in this

Hallo, Ik probeer mijn shop te updaten van 1.2.5 naar de laatste versie. Ik heb deze doc gevolgd, en na afloop kreeg ik de melding dat ik succesvol was geupdate. Echter waren er wel 44 database fouten geconstateerd. Hoe nu verder, want ik heb maar weer een backup terug geplaatst, omdat ik niet zeker weet wat nu wel en niet werkte. Vooralsnog werkte de one-page-checkout nog niet, ik kreeg dan een melding met too-many-redirects in de volgende post staan de foutmeldingen. Wie o wie kan me helpen?