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 ) ".
|
