[Bug 19161] New: Script broken [AppDB] [Cron maintenance] - Orphan version cleanup

http://bugs.winehq.org/show_bug.cgi?id=19161

Summary: Script broken [AppDB] [Cron maintenance] - Orphan
                    version cleanup
           Product: WineHQ Apps Database
           Version: unspecified
          Platform: Other
               URL: http://appdb.winehq.org
        OS/Version: other
            Status: UNCONFIRMED
          Severity: trivial
          Priority: P2
         Component: appdb-unknown
        AssignedTo: [e-mail]
        ReportedBy: [e-mail]

Looks like the cron maintenance script is broken for "Orphan version cleanup"

The script report:
-------------------------------------------------------
Found these orphaned versions in the database with
this sql command 'select versionId, versionName from appVersion where appId =
0'
versionId/name
11773/1.0.1
10398/1st Throne - The Kamael
11081/2.0.0.16
11133/1.1
14849/10.00 Alpha
15895/6.0.0.689
-------------------------------------------------------

I checked and deleted these orphan versions but they continue to be listed in
the report:

eg: See the link for the first appdb:
http://appdb.winehq.org/objectManager.php?sClass=version&iId=11773

which reports "This entry has been deleted (class: version, id: 11773)
Its content may have been moved to another entry"

[Bug 19161] Script broken [AppDB] [Cron maintenance] - Orphan version cleanup

http://bugs.winehq.org/show_bug.cgi?id=19161

Ken Sharp  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
                 CC|                            |[e-mail]
     Ever Confirmed|0                           |1

--- Comment #1 from Ken Sharp   2009-07-08 10:54:26 ---
Confirming.

[Bug 19161] Script broken [AppDB] [Cron maintenance] - Orphan version cleanup

http://bugs.winehq.org/show_bug.cgi?id=19161

Alexander Nicolaysen Sørnes  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
                 CC|                            |[e-mail]
         Resolution|                            |FIXED

--- Comment #2 from Alexander Nicolaysen Sørnes   2009-07-12 16:36:55 ---
Should be fixed now; the script wasn't taking into account that deleted
versions are no longer removed from the DB

[Bug 19161] Script broken [AppDB] [Cron maintenance] - Orphan version cleanup

http://bugs.winehq.org/show_bug.cgi?id=19161

Dmitry Timoshkov  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED
              Alias|cronOrphan                  |

--- Comment #3 from Dmitry Timoshkov   2009-07-12 23:34:56 ---
Closing.