Bug 443563 - FEAT: Match the new db schema of bz3.0 [#7 TABLE longdescs]
FEAT: Match the new db schema of bz3.0 [#7 TABLE longdescs]
Status: CLOSED NOTABUG
Product: Red Hat Ready Certification Tests
Classification: Retired
Component: web site (Show other bugs)
2
All Linux
medium Severity medium
: ---
: ---
Assigned To: XINSUN
Yu Shao
:
Depends On:
Blocks: hwcert->BZ3_tracker
  Show dependency treegraph
 
Reported: 2008-04-22 04:30 EDT by XINSUN
Modified: 2008-04-24 22:20 EDT (History)
9 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2008-04-24 22:20:20 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description XINSUN 2008-04-22 04:30:50 EDT
7.Relate to TABLE longdescs need to change list below: 
    7.1 New  the field already_wrapped,comment_id,type (Not NULL) in the table
longdescs

(Maybe this place is not necessary to change our codes, because it just impacts
the insert the comments and the fields which are defined as                    
Not NULL have the default value in the longdescs table. So just mark it for
checking if it will have some more new logic from bz 3.2 with the longdescs.
comment_id etc.)
Comment 1 XINSUN 2008-04-23 13:10:59 EDT
Have not tested my above thought
Comment 2 XINSUN 2008-04-24 12:59:26 EDT
After fixed the login issue with Dave's patch, I can do the adding comments
test. It worked well in the hwcert catalog. the db records is below

+--------+--------+---------------------+-----------+---------+-----------+--------------+-----------------+------------+------+------------+
| bug_id | who    | bug_when            | work_time | thetext | isprivate |
public_in_it | already_wrapped | comment_id | type | extra_data |
+--------+--------+---------------------+-----------+---------+-----------+--------------+-----------------+------------+------+------------+
| 437538 | 215871 | 2008-04-24 09:58:59 |      0.00 | test    |         0 |    
       0 |               0 |    1640574 |    0 | NULL       |
+--------+--------+---------------------+-----------+---------+-----------+--------------+-----------------+------------+------+------------+

Maybe. hwcert catalog need to add some more particular codes with the column
"comment_id".Because the comment_id is 0 by default in catalog, while 3.2
bugzilla need the column "comment_id" to update or make private for the
comments. Is that right?
Comment 3 XINSUN 2008-04-24 22:20:20 EDT
Sorry for my carelessness, Column "Comment_id" is auto_increment. So close this
bug as not a bug.

Note You need to log in before you can comment on or make changes to this bug.