sqlite3 3.4.2 fails to build

[jay macports@…]

Attempts to upgrade sqlite3 are failing for me. This is on 10.4.10, MBP 2.1GHz, MacPorts 1.5.2, fresh sync:

--->  Fetching sqlite3
--->  Verifying checksum(s) for sqlite3
--->  Extracting sqlite3
--->  Applying patches to sqlite3
--->  Configuring sqlite3
--->  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_databases_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

[jann@…]

I can confirm that.

[jay macports@…]

I was able to get the build to succeed by removing

-DSQLITE_ENABLE_LOCKING_STYLE=1

from configure.cflags. However, I'm not sure of the effects of that other than "fixing" the build.

Also, -DHAVE_READLINE=1 should possibly be replaced with --enable-readline.

[jay macports@…]

Can I (jay+macports@…) please be added to the CC: list? Thanks.

[mww@…]

could it be, that everyone with that bug has fink installed? I cannot reproduce this error, neither on 10.4/ppc nor 10.4/x86.

Would someone mind providing a full log?

port clean sqlite3
port -d build sqlite3 2>&1 logfile.txt

[jay macports@…]

No fink, etc -- just a previous version of sqlite3 (3.3.13_0+darwin_8) installed. The problem is that the old sqlite3 includes in /opt/local/include are getting picked up. When I force uninstall sqlite3 first, the build succeeds. Maybe macports should use '-isystem ${prefix}/include' instead of '-I' ?

[ludwig@…]

log of failed build as requested

[william.allen.simpson@…]

See also report #12607

mine was 3.3.17_0 < 3.5.1_0

upgraded successfully to sqlite3 3.5.1_0 on 10.3.9

[mww@…]

o.k. - version 3.5.1 seems to have fixed this; (if problem still persists, please re-open and attach a recent build log!)