joannaleng Posted August 5, 2013 Share Posted August 5, 2013 [PrestaShopDatabaseException] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\''), '\"', '"'), '\\', '\'), `description` = replace(replace(replace(`descrip' at line 2 UPDATE pre1_homeslider_slides_lang SET `title` = replace(replace(replace(`title`, '\\'', '\''), '\"', '"'), '\\', '\'), `description` = replace(replace(replace(`description`, '\\'', '\''), '\"', '"'), '\\', '\'), `legend` = replace(replace(replace(`legend`, '\\'', '\''), '\"', '"'), '\\', '\'), `url` = replace(replace(replace(`url`, '\\'', '\''), '\"', '"'), '\\', '\') 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][b]DbCore->displayError[/b] - [line 307 - classes/db/Db.php] - [1 Arguments] [b]DbCore->query[/b] - [line 447 - classes/db/Db.php] - [1 Arguments] [b]DbCore->execute[/b] - [line 14 - modules/homeslider/upgrade/install-1.2.1.php] - [1 Arguments] [b]upgrade_module_1_2_1[/b] - [line 348 - classes/module/Module.php] - [1 Arguments] [b]ModuleCore->runUpgradeModule[/b] - [line 1030 - controllers/admin/AdminModulesController.php] - [size=3][0 Argument][/size] [b]AdminModulesControllerCore->initContent[/b] - [line 167 - classes/controller/Controller.php] - [size=3][0 Argument][/size] [b]ControllerCore->run[/b] - [line 349 - classes/Dispatcher.php] - [size=3][0 Argument][/size] [b]DispatcherCore->dispatch[/b] - [line 50 - administrator/index.php] - [size=3][0 Argument][/size] Link to comment Share on other sites More sharing options...
joannaleng Posted August 5, 2013 Author Share Posted August 5, 2013 it seems my whole site: www.francescascloset.com is affected with errors on both front end and back end. Link to comment Share on other sites More sharing options...
vekia Posted August 5, 2013 Share Posted August 5, 2013 you've got there errors ? i checked FO and everything looks fine there Link to comment Share on other sites More sharing options...
joannaleng Posted August 5, 2013 Author Share Posted August 5, 2013 Only first page is fine... Not back office not when u click the categories Link to comment Share on other sites More sharing options...
vekia Posted August 5, 2013 Share Posted August 5, 2013 oh dear you've got right it looks like issue with homeslider can you for test purposes turn it off / uninstall ? Link to comment Share on other sites More sharing options...
joannaleng Posted August 5, 2013 Author Share Posted August 5, 2013 home slider is off. due to the theme I have. but te categories part..not working at all...even in backend Link to comment Share on other sites More sharing options...
joannaleng Posted August 5, 2013 Author Share Posted August 5, 2013 mine is already turned off coz of the theme i am using Link to comment Share on other sites More sharing options...
vekia Posted August 5, 2013 Share Posted August 5, 2013 i think that you should turn error reporting on once again the problem is a bit different Link to comment Share on other sites More sharing options...
joannaleng Posted August 5, 2013 Author Share Posted August 5, 2013 Done!!! And the entire site seems to be getting from bad to worst =< Link to comment Share on other sites More sharing options...
Dh42 Posted August 5, 2013 Share Posted August 5, 2013 Have you made any changes to your pagination.tpl file? that seems to be where the error is. Link to comment Share on other sites More sharing options...
vekia Posted August 5, 2013 Share Posted August 5, 2013 Fatal error: Uncaught exception 'SmartyCompilerException' with message 'Syntax Error in template "/home8/singapz7/public_html/francescascloset/themes/uhu077v15/pagination.tpl" on line 72 "{section name=pagination start=$start loop=$stop 1 step=1}" too many shorthand attributes' in /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php:665 Stack trace: #0 /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_compilebase.php(71): Smarty_Internal_TemplateCompilerBase->trigger_template_error('too many shorth...', 72) #1 /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_compile_section.php(52): Smarty_Internal_CompileBase->getAttributes(Object(Smarty_Internal_SmartyTemplateCompiler), Array) #2 /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php(483): Smarty_Internal_Compile_Section->compile(Array, Object(Smarty_Internal_SmartyTemp in /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php on line 665 that's right it looks like issue with pagination Link to comment Share on other sites More sharing options...
joannaleng Posted August 5, 2013 Author Share Posted August 5, 2013 Hello both! No I haven. In fact I even replace it with an original file from presta Link to comment Share on other sites More sharing options...
joannaleng Posted August 6, 2013 Author Share Posted August 6, 2013 Or can I reinstall presta but stil keeping my theme and data? Link to comment Share on other sites More sharing options...
vekia Posted August 6, 2013 Share Posted August 6, 2013 another question: have you got any backup of the store? your hosting account options should have option for that Link to comment Share on other sites More sharing options...
connectcase Posted August 13, 2013 Share Posted August 13, 2013 I've had the exact same problem. If you are sure that you do NOT need the homeslider, just ftp to your website and remove the folder "/modules/homeslider". That did the trick for me..... I am guessing it has something to do with the automatic update of modules.... Link to comment Share on other sites More sharing options...
vekia Posted August 13, 2013 Share Posted August 13, 2013 i thinkt that you've got right, i've noticed several threads with similar problem with homeslider module (especially right after "upgrade") Link to comment Share on other sites More sharing options...
joannaleng Posted August 14, 2013 Author Share Posted August 14, 2013 hi, still getting errors: http://www.francescascloset.com/6-tops <-- Warning: Function addCSS() is deprecated in /home8/singapz7/public_html/francescascloset/modules/uhu_setting/uhu_setting.php on line 375 in /home8/singapz7/public_html/francescascloset/classes/Tools.php on line 1845 Fatal error: Uncaught exception 'SmartyCompilerException' with message 'Syntax Error in template "/home8/singapz7/public_html/francescascloset/themes/uhu077v15/pagination.tpl" on line 72 "{section name=pagination start=$start loop=$stop 1 step=1}" too many shorthand attributes' in /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php:665 Stack trace: #0 /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_compilebase.php(71): Smarty_Internal_TemplateCompilerBase->trigger_template_error('too many shorth...', 72) #1 /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_compile_section.php(52): Smarty_Internal_CompileBase->getAttributes(Object(Smarty_Internal_SmartyTemplateCompiler), Array) #2 /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php(483): Smarty_Internal_Compile_Section->compile(Array, Object(Smarty_Internal_SmartyTemp in /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php on line 665 http://www.francescascloset.com/ <-- Warning: Function addCSS() is deprecated in /home8/singapz7/public_html/francescascloset/modules/uhu_setting/uhu_setting.php on line 375 in /home8/singapz7/public_html/francescascloset/classes/Tools.php on line 1845 Link to comment Share on other sites More sharing options...
vekia Posted August 14, 2013 Share Posted August 14, 2013 this is only warning, moreover is not from php, but from prestashop engine. It mean that module uhu_settings isn't compatibile at all with your ps version (module uses old functions to add css and js files) you don't have to worry about these messages. BUT. There are also ERRORs. in /home8/singapz7/public_html/francescascloset/classes/Tools.php on line 1845 Fatal error: Uncaught exception 'SmartyCompilerException' with message 'Syntax Error in template "/home8/singapz7/public_html/francescascloset/themes/uhu077v15/pagination.tpl" on line 72 "{section name=pagination start=$start loop=$stop 1 step=1}" too many shorthand attributes' in /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php:665 Stack trace: #0 /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_compilebase.php(71): Smarty_Internal_TemplateCompilerBase->trigger_template_error('too many shorth...', 72) #1 /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_compile_section.php(52): Smarty_Internal_CompileBase->getAttributes(Object(Smarty_Internal_SmartyTemplateCompiler), Array) #2 /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php(483): Smarty_Internal_Compile_Section->compile(Array, Object(Smarty_Internal_SmartyTemp in /home8/singapz7/public_html/francescascloset/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php on line 665 this is strictly related to the theme files. I suppose that it isn't compatibile at all... Link to comment Share on other sites More sharing options...
Recommended Posts