http://www.zenphoto.org/support/ zenphoto forums Topic: Version 1.2.2: bad SQL query in getImageRotation() en Thu, 23 May 2013 12:30:27 +0000 http://www.zenphoto.org/support/topic.php?id=4440#post-26254 Wed, 03 Dec 2008 17:18:51 +0000 sbillard 26254@http://www.zenphoto.org/support/ <p>Thanks, fix is in the nightly build tonight. </p> http://www.zenphoto.org/support/topic.php?id=4440#post-26240 Wed, 03 Dec 2008 10:54:11 +0000 lukehough 26240@http://www.zenphoto.org/support/ <p>The current query method is this:<br /> <pre><code>$result = query_single_row(&#39; SELECT EXIFOrientation FROM &#39;.prefix(&#39;images&#39;).&#39; AS i, &#39;.prefix(&#39;albums&#39;).&#39; AS a WHERE i.albumid = a.id&#39;);</code></pre> <p>which returns all EXIFOrientation entries, then selects the first. Since the unique image ID does not appear to be available to this function, I have passed $imgfile containing the full file path. Then queried based on $imgfile containing the album directory and image filename.</p> <pre><code>function getImageRotation($imgfile) { $result = query_single_row(&#39; SELECT EXIFOrientation FROM &#39;.prefix(&#39;images&#39;).&#39; AS i JOIN &#39;.prefix(&#39;albums&#39;).&#39; as a ON i.albumid = a.id WHERE &quot;&#39;.$imgfile.&#39;&quot; LIKE CONCAT(&quot;%&quot;,a.folder,&quot;/&quot;,i.filename)&#39;);</code></pre> <p>This should return a unique result.</p> <p>Disclaimer: I'm no pro so some of this may be wrong.</p> <p>-Luke </p>