Jump to content

Problemi con sintassi SQL


Digtrain
 Share

Recommended Posts

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` p
AND p.`active` = 1
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` = 1



Dipende quindi dalla versione MySQL del server? Suggerimenti?

Grazie a tutti.
Ciao
Walter

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More