port upgrade sqlite3 failed

[Ryan Schmidt]

On Oct 12, 2007, at 16:31, Yvon Thoraval wrote:

> i need to install the latest sqlite3, then i did a :
> $ sudo port upgrade sqlite3
>
> falling in error :
>
> --->  Building sqlite3 with target all
> Error: Target org.macports.build returned: shell command " cd "/opt/ 
> local/var/macports/build/ 
> _opt_local_var_macports_sources_rsync.macports.org_release_ports_datab 
> ases_sqlite3/work/sqlite-3.4.2" && gnumake all " returned error 2
> Command output: sed -e s/--VERS--/3.4.2/ ./src/sqlite.h.in | \
> sed -e s/--VERSION-NUMBER--/3004002/ >sqlite3.h
> /usr/bin/gcc-4.0 -O2 -I/opt/local/include - 
> DSQLITE_ENABLE_LOCKING_STYLE=1 -DHAVE_READLINE=1 -o lemon ./tool/ 
> lemon.c
> cp ./tool/lempar.c .
> cp ./src/parse.y .
> ./lemon  parse.y
> mv parse.h parse.h.temp
> gawk -f ./addopcodes.awk parse.h.temp >parse.h
> cat parse.h ./src/vdbe.c | gawk -f ./mkopcodeh.awk >opcodes.h
> ./libtool --mode=compile --tag=CC /usr/bin/gcc-4.0 -O2 -I/opt/local/ 
> include -DSQLITE_ENABLE_LOCKING_STYLE=1 -DHAVE_READLINE=1 -I. -I./ 
> src -DNDEBUG   -DTHREADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=-1 - 
> DSQLITE_ENABLE_LOCKING_STYLE=1 -DSQLITE_OMIT_LOAD_EXTENSION=1 -c ./ 
> src/alter.c
> mkdir .libs
>  /usr/bin/gcc-4.0 -O2 -I/opt/local/include - 
> DSQLITE_ENABLE_LOCKING_STYLE=1 -DHAVE_READLINE=1 -I. -I./src - 
> DNDEBUG -DTHREADSAFE=1 -DSQLITE_THREAD_OVERRIDE_LOCK=-1 - 
> DSQLITE_ENABLE_LOCKING_STYLE=1 -DSQLITE_OMIT_LOAD_EXTENSION=1 -c ./ 
> src/alter.c  -fno-common -DPIC -o .libs/alter.o
> In file included from ./src/alter.c:17:
> ./src/sqliteInt.h:1950: error: syntax error before 'void'
> ./src/alter.c: In function 'sqlite3AlterRenameTable':
> ./src/alter.c:327: error: 'struct sqlite3_module' has no member  
> named 'xRename'
> gnumake: *** [alter.lo] Error 1
>
> Error: Unable to upgrade port: 1
>
> any workaround ?

Try

sudo port -f uninstall sqlite3
sudo port clean --work sqlite3
sudo port install sqlite3