MP trunk sql.c COLLATE VERSION

[Bradley Giesbrecht]

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)