[MacPorts] #35281: Registry consistency is broken

[MacPorts]

#35281: Registry consistency is broken
---------------------------+------------------------------------------------
  Reporter:  vova@…        |       Owner:  macports-tickets@…                   
      Type:  defect        |      Status:  closed                               
  Priority:  Normal        |   Milestone:                                       
 Component:  base          |     Version:  2.1.1                                
Resolution:  duplicate     |    Keywords:                                       
      Port:                |  
---------------------------+------------------------------------------------

Comment(by vova@…):

 Thanks, now it works

 sqlite3  /opt/local/var/macports/registry/registry.db
 SQLite version 3.7.11 2012-03-20 11:35:50
 Enter ".help" for instructions
 Enter SQL statements terminated with a ";"
 sqlite> .load
 /opt/local/var/macports//sources/rsync.macports.org/release/base/src/cregistry/macports.sqlext
 sqlite> SELECT id,name,version,variants,date,requested,state,installtype
 FROM ports WHERE name LIKE 'm4';
 11|m4|1.4.14||1282054187|0|imaged|image
 238|m4|1.4.15||1286454187|0|imaged|image
 411|m4|1.4.15||1291384065|0|imaged|image
 1496|m4|1.4.16||1343051173|0|installed|image
 sqlite>


 I've fixed database, what is strange, in my case fixing query was:

 UPDATE dependencies SET id = 686 WHERE id = 1;

 same id=686 as in #34482,  probably it is magic number?

-- 
Ticket URL: <https://trac.macports.org/ticket/35281#comment:8>
MacPorts <http://www.macports.org/>
Ports system for Mac OS