[MacPorts] #34463: Source upgrade from 2.0.4 to 2.1.0 fails with sqlite error on OS X 10.4.11

[MacPorts]

#34463: Source upgrade from 2.0.4 to 2.1.0 fails with sqlite error on OS X 10.4.11
----------------------------+-----------------------------------------------
 Reporter:  nad@…           |       Owner:  cal@…           
     Type:  defect          |      Status:  assigned        
 Priority:  High            |   Milestone:                  
Component:  base            |     Version:  2.1.0           
 Keywords:  tiger haspatch  |        Port:                  
----------------------------+-----------------------------------------------

Comment(by nad@…):

 The patch does not seem to work at least as I'm trying to do the upgrade.
 I tried it both on my existing source installation which has a non-default
 prefix, then with a vanilla default 2.0.4 built from source.  Basic steps:
 download 2.0.4 tarball, '''./configure''', '''make''', '''sudo make
 install''', '''sudo port sync''', '''sudo port install bzip2''' (just to
 test) -> OK.  Then download 2.1.0 tarball, download and apply patch to
 src/cregistry/sql.c.  Run '''make''' which compiles sql.c with warnings:


 {{{
 gcc -c -DUSE_TCL_STUBS -g -O2 -Wextra -Wall -pedantic  -DHAVE_CONFIG_H
 -I.. -I.  -I"/usr/include" -fno-common sql.c -o sql.o
 sql.c:269:17: warning: C++ style comments are not allowed in ISO C90
 sql.c:269:17: warning: (this will be reported only once per input file)
 ar cr cregistry.a registry.o entry.o sql.o vercomp.o util.o file.o
 }}}

 Then '''sudo make install''' which eventually errors with:


 {{{
 ===> making install in tests
 make[1]: Nothing to be done for `install'.
 [ ! -f /macports/etc/macports/mp_version ] || rm -vf
 /macports/etc/macports/mp_version
 /usr/bin/install -c -o root -g admin -m 444 setupenv.bash
 /macports/share/macports/
 /usr/bin/install -c -o root -g admin -m 444 macports-pubkey.pem
 /macports/share/macports/
 /usr/local/bin/tclsh src/upgrade_sources_conf_default.tcl "/macports"
 /usr/local/bin/tclsh src/images_to_archives.tcl
 "/macports/share/macports/Tcl"
 sqlite error: near "ADD": syntax error (1) while executing query: ALTER
 TABLE registry.files ADD COLUMN binary BOOL
     while executing
 "registry::open $db_path"
     (procedure "mportinit" line 633)
     invoked from within
 "mportinit ui_options"
     (file "src/images_to_archives.tcl" line 18)
 make: *** [install] Error 1

 }}}

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