Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 356675 - unspecified version of birt and technology.subversive may be wrong copy of technology.subversive
Summary: unspecified version of birt and technology.subversive may be wrong copy of te...
Status: CLOSED FIXED
Alias: None
Product: Babel
Classification: Technology
Component: Website (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 trivial (vote)
Target Milestone: ---   Edit
Assignee: Babel Bugzilla inbox CLA
QA Contact:
URL: /babel/stats.php
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-04 10:03 EDT by Satoru Yoshida CLA
Modified: 2011-09-07 22:09 EDT (History)
2 users (show)

See Also:

Attachments
inactive_project_version (14.54 KB, image/png)
2011-09-04 11:51 EDT, Kit Lo CLA 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

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