Digtrain Posted September 15, 2009 Share Posted September 15, 2009 Ciao a tutti,ieri sera mi sono lanciato e ho uplodato il sito 1.2.3 italia sul server Tophost.Sono senza parole... tutto ok l'installazione, semplicemente grandioso.In questo momento sto personalizzando e smanettando e alla pressione del link offerte si presenta questa scritta: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 'AND p.`active` = 1 AND p.`id_product` IN ( SELECT cp.`id_product` FRO' at line 3 SELECT COUNT(DISTINCT p.`id_product`) AS nb FROM `ps_product` pAND p.`active` = 1AND p.`id_product` IN (SELECT cp.`id_product`FROM `ps_category_group` cgLEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)WHERE cg.`id_group` = 1Dipende quindi dalla versione MySQL del server? Suggerimenti?Grazie a tutti.Ciao Walter Link to comment Share on other sites More sharing options...
Diemux Posted September 17, 2009 Share Posted September 17, 2009 I'm having the same issue and I can't seem to resolve it. I'm using 1.2.3.0. (btw, 1.2.2.0 doesn't seem to have this issue, same server). Link to comment Share on other sites More sharing options...
disarci Posted September 17, 2009 Share Posted September 17, 2009 Avete provato con la 1.2.4?did you try with the 1.2.4?cheap host! ahi ahi ahi!;-) Link to comment Share on other sites More sharing options...
Diemux Posted September 17, 2009 Share Posted September 17, 2009 Ehm, I think this isn't related to the host. Useless comment.Anyhow, updating to 1.2.4.0 resolved the issue. Link to comment Share on other sites More sharing options...
disarci Posted September 17, 2009 Share Posted September 17, 2009 Dieumux,we've installed 123 on 9 servers to try italian version and we had only the 3rd page problem on 2 of them, reported in bugs and in different post,it's was not an "Useless comment" because I really think it was related to some PHP configuration. You see that the variables in the query are totally truncated.Sorry if the joke have bothered you! Instead a gave a resolving tips (also if it was expected)--trad--Dieumux,abbiamo installato la 123 su 9 server per provare la versione italiana, e abbiamo avuto un problam in 3rd pagina su 2 di questi, riportati tra i bug e su post differenti.Non era un "commento inutile" perché ritengo realmente che sia relativo ad una configurazione di PHP. Vedi che le variabili nella query sono troncate.Scusa se lo scherzo ti ha dato fastidio! Comunque avevo dato un consiglio risolutivo (anche se ovvio) Link to comment Share on other sites More sharing options...
Digtrain Posted September 17, 2009 Author Share Posted September 17, 2009 Ciao a tutti,ho caricato la versione 1.2.4 e il problema si è risolto!!Grazie per i Vostri preziosi consigli.Ciao Walter Link to comment Share on other sites More sharing options...
memex Posted September 19, 2009 Share Posted September 19, 2009 The problem was in the file Products.php 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