Bug 443562

Summary: FEAT: Match the new db schema of bz3.0 [#6 TABLE groups]
Product: [Retired] Red Hat Ready Certification Tests Reporter: XINSUN <xisun>
Component: web siteAssignee: XINSUN <xisun>
Status: CLOSED DUPLICATE QA Contact: Yu Shao <yshao>
Severity: medium Docs Contact:
Priority: medium    
Version: 2CC: yshao
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2008-04-25 05:13:31 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 443456    

Description XINSUN 2008-04-22 08:27:16 UTC
6.   Relate to TABLE groups need to change list below:
        6.1 Delete  the field last_changed from table groups
                             Added :     N/A
                             Removed:    FIELD  groups.last_changed

Comment 1 XINSUN 2008-04-25 05:13:31 UTC
=======================================================================================

A) File: Bugzilla/User.pm
            Line: 108
            Func: _create()    #this func seems not to be used and called in our
hwcert codes.
            Statement: 
             my $result = $dbh->selectrow_array(q{SELECT 1
                                           FROM profiles, groups
                                          WHERE userid=?
                                            AND profiles.refreshed_when <=
                                                  groups.last_changed},
                                       undef,
                                       $id)

=======================================================================================
Above codes has been removed in the #443566's patch.

So close it as a duplicate of bug #443566.

*** This bug has been marked as a duplicate of 443566 ***