Kimze999 Posted April 10, 2013 Share Posted April 10, 2013 Ola, Acabei de atualizar a minha loja para a nova versão do prestashop.. Instalou tudo direitinho, base de dados, configurações etc...... Na hora de testar a minha loja em http://lojamundial.net/ mostra um erro e não abre.. O erro é o seguinte: Couldnt execute query2 Já aconteceu alguem?como corrigir? Obrigado Link to comment Share on other sites More sharing options...
guest* Posted April 10, 2013 Share Posted April 10, 2013 Movi a sua pergunta para instalação e configuração que é a categoria correta do forum. O seu banco de dados parece estar corrupto. Vc. fez um back-up manual antes de atualizar ? Restaure a sua loja manualmente, não através da opção "roll back" do módulo 1-click-upgrade. Link to comment Share on other sites More sharing options...
jose_rui_sa Posted June 23, 2013 Share Posted June 23, 2013 eu fiz o upgrade td ok, excepto um modulo (acho eu que é um modulo) jirafe.zip que deu erro tenho acesso ao admin, mas a pagina principal dá o erro Couldnt execute query2 o que será Estou em Local Server.... posso "estragar à vontade) Link to comment Share on other sites More sharing options...
guest* Posted June 24, 2013 Share Posted June 24, 2013 Desativa o módulo ou deleta da lista de módulos. Se nao possível entao deleta diretamente no FTP /modules/jirafe Link to comment Share on other sites More sharing options...
jose_rui_sa Posted June 24, 2013 Share Posted June 24, 2013 será esse modulo a dar o erro do query2? vou tentar já digo algo. Link to comment Share on other sites More sharing options...
jose_rui_sa Posted June 24, 2013 Share Posted June 24, 2013 (edited) Viva O upgrade correu bem agora sem qualquer erro. Ao abrir a pagina continuo a obter o erro que nao posso abrir o query2 Edited June 24, 2013 by jose_rui_sa (see edit history) Link to comment Share on other sites More sharing options...
jose_rui_sa Posted June 24, 2013 Share Posted June 24, 2013 tentei outras formas e parece-me que seja algum problema com o tema. no entanto meti um tema default limpo e continua igual. Link to comment Share on other sites More sharing options...
guest* Posted June 24, 2013 Share Posted June 24, 2013 Ativa o modo debug e limpe os erros lá mostrados: Altere no FTP o seu ficheiro /config/config.defines.inc.php estas linhas: /* Debug only */ define('_PS_MODE_DEV_', true); if (_PS_MODE_DEV_) { @ini_set('display_errors', 'on'); define('_PS_DEBUG_SQL_', true); /* Compatibility warning */ define('_PS_DISPLAY_COMPATIBILITY_WARNING_', true); } Link to comment Share on other sites More sharing options...
jose_rui_sa Posted June 24, 2013 Share Posted June 24, 2013 Jejus tantos erros Warning: Function addCSS() is deprecated in /Applications/MAMP/htdocs/modules/blockpermanentlinks2/blockpermanentlinks2.php on line 87 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: Function hookExec() is deprecated in /Applications/MAMP/htdocs/modules/blocksearchcenter/blocksearchcenter.php on line 56 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: Function addCSS() is deprecated in /Applications/MAMP/htdocs/modules/blocksearchcenter/blocksearchcenter.php on line 73 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: Function addJS() is deprecated in /Applications/MAMP/htdocs/modules/blocksearchcenter/blocksearchcenter.php on line 74 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: Function addCSS() is deprecated in /Applications/MAMP/htdocs/modules/blocksearchcenter/blocksearchcenter.php on line 76 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: Function addCSS() is deprecated in /Applications/MAMP/htdocs/modules/blocksearchcenter/blocksearchcenter.php on line 77 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: Function addCSS() is deprecated in /Applications/MAMP/htdocs/modules/blockbestsellers2/blockbestsellers2.php on line 132 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: Function addCSS() is deprecated in /Applications/MAMP/htdocs/modules/blockcart2/blockcart2.php on line 189 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: Function addJS() is deprecated in /Applications/MAMP/htdocs/modules/blockcart2/blockcart2.php on line 191 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: Function addCSS() is deprecated in /Applications/MAMP/htdocs/modules/sendtoafriend2/sendtoafriend2.php on line 57 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: Function addCSS() is deprecated in /Applications/MAMP/htdocs/modules/blockadvertmulti/blockadvertmulti.php on line 260 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Strict Standards: Declaration of Mobile_Theme::disable() should be compatible with ModuleCore::disable($forceAll = false) in/Applications/MAMP/htdocs/modules/mobile_theme/mobile_theme.php on line 802 Warning: Function addJS() is deprecated in /Applications/MAMP/htdocs/modules/mobile_theme/mobile_theme.php on line 323 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: Function addCSS() is deprecated in /Applications/MAMP/htdocs/modules/blocktestimonial/blocktestimonial.php on line 278 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: Function getDiscounts() is deprecated in /Applications/MAMP/htdocs/modules/blockcart2/blockcart2.php on line 88 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /Applications/MAMP/htdocs/modules/blocktestimonial/blocktestimonial.php on line 251 Couldnt execute query2 Link to comment Share on other sites More sharing options...
jose_rui_sa Posted June 24, 2013 Share Posted June 24, 2013 desactivei os modulos com Warning e tenho o erro do query2 na mesma... Link to comment Share on other sites More sharing options...
guest* Posted June 24, 2013 Share Posted June 24, 2013 Todos estes módulos estao causando problemas com PS 1.5. vc. deverá desativá-los. blockcart2 deve vir to seu thema. Themas para PS 1.4. nao funcionam com PS 1.5.X Link to comment Share on other sites More sharing options...
jose_rui_sa Posted June 24, 2013 Share Posted June 24, 2013 fiz outra coisa... o Couldnt execute query2 ficou resolvido. Solved Removi todos os modulos da pagina antiga (tive de "esquecer" o autoupgrade) e meti tds os modulos do 1.5.... aparentemente já está melhor... ja aparece qualquer coisa... ligeiramente diferente do tema original... tenho agora de corrigir. Link to comment Share on other sites More sharing options...
jose_rui_sa Posted June 24, 2013 Share Posted June 24, 2013 Estou com configurações do tema diferentes do tema default. Ele parece que tem definições no sql do tema antigo. Estarei correcto? Existe conf de sql do tema que eu possa importar ? Link to comment Share on other sites More sharing options...
guest* Posted June 25, 2013 Share Posted June 25, 2013 Não. Vc. vai ter que comprar um tema novo para PS 1.5. Link to comment Share on other sites More sharing options...
jose_rui_sa Posted June 25, 2013 Share Posted June 25, 2013 (edited) Bom dia Eu estive a comparar o tema default do que tenho na pagina antiga e na pagina nova. E deparei-me com o seguinte: Original: A minha pagina atualizada com o tema original do prestashop (default): Depois de tentar ver diferenças tentei ir ao modulo Top Horizontal Menu e configurar e obtenho o seguinte (relembro que os modulos sao todos da ultima versão): [PrestaShopDatabaseException] Unknown column 'll.link' in 'field list' SELECT l.id_linksmenutop, l.new_window, ll.link, ll.label FROM ps_linksmenutop l LEFT JOIN ps_linksmenutop_lang ll ON (l.id_linksmenutop = ll.id_linksmenutop AND ll.id_lang = 6 AND ll.id_shop=1) WHERE 1 AND l.id_shop IN (0, 1) 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 482 - classes/db/Db.php] - [1 Arguments] [b]DbCore->executeS[/b] - [line 37 - modules/blocktopmenu/menutoplinks.class.php] - [1 Arguments] [b]MenuTopLinks::gets[/b] - [line 261 - modules/blocktopmenu/blocktopmenu.php] - [3 Arguments] [b]Blocktopmenu->getContent[/b] - [line 675 - controllers/admin/AdminModulesController.php] - [size=3][0 Argument][/size] [b]AdminModulesControllerCore->postProcessCallback[/b] - [line 795 - controllers/admin/AdminModulesController.php] - [size=3][0 Argument][/size] [b]AdminModulesControllerCore->postProcess[/b] - [line 158 - 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 - admin789/index.php] - [size=3][0 Argument][/size] Edited June 25, 2013 by jose_rui_sa (see edit history) Link to comment Share on other sites More sharing options...
CarlosC Posted June 25, 2013 Share Posted June 25, 2013 Booas O erro que relata tem pouco haver com o tema. Verifica mais erros em outros sítios? Cumps Link to comment Share on other sites More sharing options...
jose_rui_sa Posted June 25, 2013 Share Posted June 25, 2013 não me parece... agora tenho o erro Warning: Function display() is deprecated in /Applications/MAMP/htdocs/classes/controller/Controller.php on line 185 in /Applications/MAMP/htdocs/classes/Tools.php on line 1845 E já tenho a pagina a parecer assim. Creio mesmo ser definições no sql (por exemplo onde fica guardada a informação que um determinado modulo está ativo ou nao?) Link to comment Share on other sites More sharing options...
CarlosC Posted June 25, 2013 Share Posted June 25, 2013 Verifique os logs na raiz de ficheiros do prestashop para ver se aparece mais detalhes sobre esses problemas. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now