Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 356675

Summary: unspecified version of birt and technology.subversive may be wrong copy of technology.subversive
Product: [Technology] Babel Reporter: Satoru Yoshida <ramat>
Component: WebsiteAssignee: Babel Bugzilla inbox <babel.core-inbox>
Status: CLOSED FIXED QA Contact:
Severity: trivial    
Priority: P3 CC: denis.roy, kitlo
Version: unspecified   
Target Milestone: ---   
Hardware: All   
OS: All   
URL: /babel/stats.php
Whiteboard:
Attachments:
Description Flags
inactive_project_version none

Description Satoru Yoshida CLA 2011-09-04 10:03:46 EDT 
Hello, I find both unspecified version of technology.subversive and birt are committed as same time as technology.subversive 0.7 on http://babel.eclipse.org/babel/recent.php .

I think both are wrong copy of technology.subversive 0.7 .

Thanks.
Comment 1 Kit Lo CLA 2011-09-04 11:51:48 EDT 
Created attachment 202718 [details]
inactive_project_version

A few old/invalid projects/versions are marked as inactive in the map_files table. However, some files and strings belonging to these projects/versions are still active.

Denis, can you help to come up with the SQL commands to mark the files and strings belonging to these projects/versions to be inactive?
Comment 2 Denis Roy CLA 2011-09-07 14:11:38 EDT 
subversive:
mysql> update files set is_active = 0 where project_id = "technology.subversive" and version="unspecified";
Query OK, 6 rows affected (0.09 sec)
Rows matched: 6  Changed: 6  Warnings: 0

mysql> update strings set is_active = 0 where file_id in (select file_id from files where project_id = "technology.subversive" and version="unspecified");
Query OK, 0 rows affected (16.90 sec)
Rows matched: 2344  Changed: 0  Warnings: 0



mysql> update files set is_active = 0 where project_id = "birt" and version="unspecified";
Query OK, 6 rows affected (0.09 sec)
Rows matched: 46  Changed: 6  Warnings: 0

mysql> update strings set is_active = 0 where file_id in (select file_id from files where project_id = "birt" and version="unspecified");
Query OK, 8170 rows affected (17.01 sec)
Rows matched: 10514  Changed: 8170  Warnings: 0
Comment 3 Kit Lo CLA 2011-09-07 14:53:41 EDT 
Thanks, Denis!

Yoshida-san, I touched some of the strings you translated. Babel does not update the unspecified versions anymore.

Resolving as fixed.
Comment 4 Satoru Yoshida CLA 2011-09-07 22:09:52 EDT 
Thank You, Denis Roy and Kit Lo.

I can ensure the unspecified versions are not update now ;)