• Priority: 0
  • Status: Closed
  • Theme: Alysum
  • Assigned To: Marek
  • Private: No
  • Open Date: 10.07.17, 16:13
  • Opened by: cwms
  • Closed by: Marek
  • Closed on: 29.08.17, 23:14
  • Reason: Closed
  • Comment: Glad to help!

Ticket #10557 - Error on ps_testimonials

Hi,

We run Prestashop 1.7 multi-store and when we switch from the Classic theme to Alysum theme, we get this error message :

[PrestaShopDatabaseException]

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near at line 1 SELECT * FROM `ps_testimonials` where status = “enabled” ORDER BY date_added DESC LIMIT at line 744 in file classes/db/Db.php
739. if ($webservice_call && $errno) {
740. $dbg = debug_backtrace();
741. WebserviceRequest::getInstance()→setError(500, ‘[SQL Error] ‘.$this→getMsgError().’. From ‘.(isset($dbg[3][’class’]) ? $dbg[3][’class’] : ).’→‘.$dbg[3][’function’].’() Query was : ‘.$sql, 97);
742. } elseif (_PS_DEBUG_SQL_ && $errno && !defined(’PS_INSTALLATION_IN_PROGRESS’)) {
743. if ($sql) {
744. throw new PrestaShopDatabaseException($this→getMsgError().’<br /><br /><pre>’.$sql.’</pre>’);
745. }
746.
747. throw new PrestaShopDatabaseException($this→getMsgError());
748. }
749. }

If we switch back to classic, everything is fine.

CM/.

Comments

Marek 10 Jul 2017, 16:49

Hi. Please fill out all necessary fields in your profile https://support.promokit.eu/index.php?do=myprofile to access to your server through FTP and I’ll try to fix the issue

cwms 10 Jul 2017, 17:16

Done.

Marek 10 Jul 2017, 17:25

I just reset your testimonials module and front page works fine now. But could you please tell me how did you install the theme, because I see the difference between our demo and your shop

cwms 10 Jul 2017, 18:40

I have uploaded the folder in theme and i activated the theme in the Appearence » add a theme.

What shall i do ?

Marek 10 Jul 2017, 19:18

Ok, if you will have any problems just write here