[pLog-svn] r6318 - plog/branches/lifetype-1.2

[Andy Wright]

I noticed this when I transferred a non-live - development database from
a host, into a VM.

The error I was receiving was that my admin account was not assigned to
a Blog

It took me, well, long.. when I then set the _user_permissions,
permission_id rows to all '0', logged into the admin area and noticed
the tmp_users_permissions was then deleted, and the DB was restored.  

I don't know if this has any meaning, or may help in any way (don't know
the DB schematic well enough), but I thought I would speak out in case
it did.
-- 
Andy Wright                              
IT/IS Professional                     
IT/IS Forum # (608)554-0030 VM                     
Open Forum Skype: extracted          
Thanks BB, "water is wet"                          
___________________________________________
andy.wright at extracted.org
For public and private use.
KEY ID 7CECF855
http://7cecf855.extracted.org

ALTERNATIVE: myside at gmail.com
___________________________________________


On Thu, 2008-04-24 at 14:11 -0400, mark at devel.lifetype.net wrote:
> Author: mark
> Date: 2008-04-24 14:11:23 -0400 (Thu, 24 Apr 2008)
> New Revision: 6318
> 
> Modified:
>    plog/branches/lifetype-1.2/wizard
> Log:
> Another serious bug in wizard when we perform upgrade. We just drop the tmp_users_permission table in the first while loop.
> 
> The users_permissions table never convert "complete" when user upgrade from 1.1 :(
> 
> The same question, why there are no user complain about this.
> 
> Modified: plog/branches/lifetype-1.2/wizard
> ===================================================================
> --- plog/branches/lifetype-1.2/wizard	2008-04-24 16:11:05 UTC (rev 6317)
> +++ plog/branches/lifetype-1.2/wizard	2008-04-24 18:11:23 UTC (rev 6318)
> @@ -1537,6 +1537,7 @@
>              $res3 = $this->Execute( $query3, $this->page, $this->itemsPerPage );
>              if( $res3->RecordCount() == 0 ) {
>  				$this->message .= "No more records to process";
> +				$this->Execute("DROP TABLE ".Db::getPrefix()."tmp_users_permissions");
>  				return( true );
>  			}
>  			
> @@ -1563,12 +1564,12 @@
>  						}
>  					}
>  				}
> +				
> +				$this->updatedRecords++;
>              }
>        
>              $this->message .= "{$this->updatedRecords} users updated (".$this->getPercentProcessed()."%%)<br/>";
>  
> -            $this->Execute("DROP TABLE ".Db::getPrefix()."tmp_users_permissions");
> -
>              return true;
>          }
>      }
> 
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://limedaley.com/mailman/listinfo/plog-svn
>