[fusionregistry-commitlog] SF.net SVN: fusionregistry: [14] branches/stable_3_0_x/upload/sources/

[SVN c. <fus...@li...>]

Revision: 14
          http://fusionregistry.svn.sourceforge.net/fusionregistry/?rev=14&view=rev
Author:   copland007
Date:     2007-06-18 12:25:40 -0700 (Mon, 18 Jun 2007)

Log Message:
-----------
Resolve bug 1739318. Insert "$this->ipsclass->DB->allow_sub_select =
1;" before any sub-select queries.

Modified Paths:
--------------
    branches/stable_3_0_x/upload/sources/components_public/fusionscripts/fusionregistry/upgrade/upgrade_30000/version_upgrade.php

Modified: branches/stable_3_0_x/upload/sources/components_public/fusionscripts/fusionregistry/upgrade/upgrade_30000/version_upgrade.php
===================================================================
--- branches/stable_3_0_x/upload/sources/components_public/fusionscripts/fusionregistry/upgrade/upgrade_30000/version_upgrade.php	2007-06-18
07:25:57 UTC (rev 13)
+++ branches/stable_3_0_x/upload/sources/components_public/fusionscripts/fusionregistry/upgrade/upgrade_30000/version_upgrade.php	2007-06-18
19:25:40 UTC (rev 14)
@@ -191,6 +191,7 @@
         // These are straight "INSERT ... SELECT ... FROM ..." statements.

         // Images
+        $this->ipsclass->DB->allow_sub_select = 1;
         $this->ipsclass->DB->query( "INSERT INTO
".$this->ipsclass->vars['sql_tbl_prefix']."registry_images ".
                                           "( attach_id,
attach_location, attach_hits, attach_ext, attach_file, ".
                                           "attach_thumb_location,
attach_thumb_width, attach_thumb_height, ".
@@ -203,6 +204,7 @@
         $executed++;

         // Gallery
+        $this->ipsclass->DB->allow_sub_select = 1;
         $this->ipsclass->DB->query( "INSERT INTO
".$this->ipsclass->vars['sql_tbl_prefix']."registry_gallery ".
                                           "( id, item_id, image_id ) ".
                                     "SELECT g.id, g.garage_id, g.image_id ".
@@ -211,6 +213,7 @@
         $executed++;

         // Guestbooks
+        $this->ipsclass->DB->allow_sub_select = 1;
         $this->ipsclass->DB->query( "INSERT INTO
".$this->ipsclass->vars['sql_tbl_prefix']."registry_guestbooks ".
                                           "( id, item_id, author_id,
post_date, ip_address, post ) ".
                                     "SELECT gb.id, gb.garage_id,
gb.author_id, gb.post_date, gb.ip_address, gb.post ".
@@ -219,6 +222,7 @@
         $executed++;

         // Categories
+        $this->ipsclass->DB->allow_sub_select = 1;
         $this->ipsclass->DB->query( "INSERT INTO
".$this->ipsclass->vars['sql_tbl_prefix']."registry_categories ".
                                           "( id, title, image_id ) ".
                                     "SELECT c.id, c.title, c.image_id ".
@@ -227,6 +231,7 @@
         $executed++;

         // Makes
+        $this->ipsclass->DB->allow_sub_select = 1;
         $this->ipsclass->DB->query( "INSERT INTO
".$this->ipsclass->vars['sql_tbl_prefix']."registry_makes ".
                                           "( id, make ) ".
                                     "SELECT m.id, m.make ".
@@ -235,6 +240,7 @@
         $executed++;

         // Models
+        $this->ipsclass->DB->allow_sub_select = 1;
         $this->ipsclass->DB->query( "INSERT INTO
".$this->ipsclass->vars['sql_tbl_prefix']."registry_models ".
                                           "( id, make_id, model ) ".
                                     "SELECT m.id, m.make_id, m.model ".
@@ -243,6 +249,7 @@
         $executed++;

         // Modifications
+        $this->ipsclass->DB->allow_sub_select = 1;
         $this->ipsclass->DB->query( "INSERT INTO
".$this->ipsclass->vars['sql_tbl_prefix']."registry_mods ".
                                           "( id, item_id, member_id,
category_id, title, price, install_price, ".
                                           "rating, comments,
image_id, date_created, date_updated ) ".