From: Andreas Unterkircher <unki@netshadow.at>
Date: Sun, 8 Jul 2007 13:04:44 +0000 (+0000)
Subject: issue35, if too many tags are selected and AND condition is used, this will show... 
X-Git-Tag: phpfspot-1.2~152
X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=phpfspot.git;a=commitdiff_plain;h=086cf84bfd20fcccdc978a0200ab97cdeca2c172

issue35, if too many tags are selected and AND condition is used, this will show up a warning now


git-svn-id: file:///var/lib/svn/phpfspot/trunk@183 fa6a889d-dae6-447d-9e79-4ba9a3039384
---

diff --git a/phpfspot.class.php b/phpfspot.class.php
index f3944d1..32c2df7 100644
--- a/phpfspot.class.php
+++ b/phpfspot.class.php
@@ -371,6 +371,12 @@ class PHPFSPOT {
          }
          elseif($_SESSION['tag_condition'] == 'and') {
 
+            if(count($_SESSION['selected_tags']) >= 32) {
+               print "A SQLite limit of 32 tables within a JOIN SELECT avoids to<br />\n";
+               print "evaluate your tag selection. Please remove some tags from your selection.\n";
+               return Array();
+            } 
+
             /* Join together a table looking like
 
                pt1.photo_id pt1.tag_id pt2.photo_id pt2.tag_id ...