Bug 443562 - FEAT: Match the new db schema of bz3.0 [#6 TABLE groups]
Summary: FEAT: Match the new db schema of bz3.0 [#6 TABLE groups]
Keywords:
Status: CLOSED DUPLICATE of bug 443566
Alias: None
Product: Red Hat Ready Certification Tests
Classification: Retired
Component: web site
Version: 2
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: XINSUN
QA Contact: Yu Shao
URL:
Whiteboard:
Depends On:
Blocks: hwcert->BZ3_tracker
TreeView+ depends on / blocked
 
Reported: 2008-04-22 08:27 UTC by XINSUN
Modified: 2008-04-25 05:13 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2008-04-25 05:13:31 UTC
Embargoed:

Attachments (Terms of Use)

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 ***
Note You need to log in before you can comment on or make changes to this bug.