http://forum.neo22s.com/ Forum Neo22s » Tag: sql error [256] (1064) - Recent Topics en Fri, 30 Jul 2010 11:58:28 +0000 http://forum.neo22s.com/topic/de-nuevo-el-error-sql#post-101 Mon, 21 Sep 2009 22:00:50 +0000 gneral 101@http://forum.neo22s.com/ <p>Saludos. De nuevo el servidor me envia este aviso:</p> <p>##############################################################################</p> <p>&lt;b&gt;SQL Error&lt;/b&gt; [256] (1064) 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 ( c.idCategory=7 or c.idCategoryParent=7)<br /> order by p.insertDate Desc LI' at line 7</p> <p> Query : SELECT p.idPost,p.title,p.description,p.insertDate,<br /> c.Name category,c.idCategoryParent,p.type,p.price,<br /> (select Filename from postsimages where idPost=p.idPost order by FileName asc Limit 1) image<br /> FROM posts p<br /> inner join categories c<br /> on c.idCategory=p.idCategory<br /> where p.isAvailable=1 and p.isConfirmed=1 and p.type= and ( c.idCategory=7 or c.idCategoryParent=7)<br /> order by p.insertDate Desc LIMIT 15</p> <p> On line 23 in file /rss/index.php<br /> , PHP 5.1.6 (Linux)</p> <p> Aborting...</p> <p>#############################################################################</p> <p>A que es debido? Pense que era el formato del texto, pero no. y como de bases de datos ando mal, si alguien me puede indicar como solucionarlo, le agradezco </p> <p>Joaquim Gener </p>