Ok, I managed to execute the update queries using the sqlite3 commandline 
client.

sqlite> attach database 
"/opt/local/var/macports/registry/manual-upgrade/registry.db" as registry;
sqlite> .databases
seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /opt/local/var/macports/registry/manual-upgrade/ls        
2    registry         /opt/local/var/macports/registry/manual-upgrade/registry.d
sqlite> begin;
sqlite> ALTER TABLE registry.files ADD COLUMN binary BOOL;
sqlite> CREATE INDEX registry.file_binary ON files(binary);
sqlite> UPDATE registry.metadata SET value = '1.100' WHERE key = 'version';
sqlite> commit;
sqlite> select * from metadata;
version|1.100
created|1289913112
sqlite> .quit


Yay!!!

$ sudo port -v rev-upgrade
--->  Updating database of binaries: 100%
--->  Scanning binaries for linking errors: 100%
--->  No broken files found. :)


I do not know why manually updating the database worked while "make install" 
did not.


Regards,
Bradley Giesbrecht (pixilla)




_______________________________________________
macports-dev mailing list
macports-dev@lists.macosforge.org
http://lists.macosforge.org/mailman/listinfo.cgi/macports-dev

Reply via email to