sqlite3 fails to install on Leopard

[Ryan Schmidt]

On Feb 20, 2008, at 04:14, <haydnw at yahoo.com> <haydnw at yahoo.com> wrote:

> I'm trying to install apache2 using Macports on Leopard. Leopard  
> and Macports are both fully up to date, as are the Xcode tools.  
> When trying to install apache, Macports fails at the point where  
> it's installing the sqlite3 dependancy. The error message it gives  
> is as follows:
>
>
> --->  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.5.6" && gnumake all " returned error 2
> Command output: ./libtool --mode=compile --tag=CC /usr/bin/gcc-4.0 - 
> O2 -I. -I./src -DNDEBUG   -DSQLITE_THREADSAFE=1 - 
> DSQLITE_THREAD_OVERRIDE_LOCK=-1 -DSQLITE_OMIT_LOAD_EXTENSION=1 -c ./ 
> src/alter.c
>  /usr/bin/gcc-4.0 -O2 -I. -I./src -DNDEBUG -DSQLITE_THREADSAFE=1 - 
> DSQLITE_THREAD_OVERRIDE_LOCK=-1 -DSQLITE_OMIT_LOAD_EXTENSION=1 -c ./ 
> src/alter.c  -fno-common -DPIC -o .libs/alter.o
> ./src/alter.c: In function 'renameTableFunc':
> ./src/alter.c:77: error: 'TK_SPACE' undeclared (first use in this  
> function)
> ./src/alter.c:77: error: (Each undeclared identifier is reported  
> only once
> ./src/alter.c:77: error: for each function it appears in.)
> ./src/alter.c:79: error: 'TK_LP' undeclared (first use in this  
> function)
> ./src/alter.c:79: error: 'TK_USING' undeclared (first use in this  
> function)
> ./src/alter.c: In function 'renameTriggerFunc':
> ./src/alter.c:135: error: 'TK_SPACE' undeclared (first use in this  
> function)
> ./src/alter.c:148: error: 'TK_DOT' undeclared (first use in this  
> function)
> ./src/alter.c:148: error: 'TK_ON' undeclared (first use in this  
> function)
> ./src/alter.c:151: error: 'TK_WHEN' undeclared (first use in this  
> function)
> ./src/alter.c:151: error: 'TK_FOR' undeclared (first use in this  
> function)
> ./src/alter.c:151: error: 'TK_BEGIN' undeclared (first use in this  
> function)
> ./src/alter.c: In function 'reloadTableSchema':
> ./src/alter.c:246: error: 'OP_DropTrigger' undeclared (first use in  
> this function)
> ./src/alter.c:251: error: 'OP_DropTable' undeclared (first use in  
> this function)
> ./src/alter.c:256: error: 'OP_ParseSchema' undeclared (first use in  
> this function)
> ./src/alter.c: In function 'sqlite3AlterRenameTable':
> ./src/alter.c:366: error: 'OP_String8' undeclared (first use in  
> this function)
> ./src/alter.c:367: error: 'OP_VRename' undeclared (first use in  
> this function)
> ./src/alter.c: In function 'sqlite3AlterFinishAddColumn':
> ./src/alter.c:479: error: 'TK_NULL' undeclared (first use in this  
> function)
> gnumake: *** [alter.lo] Error 1
>
>
> Error: Status 1 encountered during processing.
>
>
> I get the same if I CD to the directory and try to do the "gnumake  
> all" bit myself. I would be very grateful if anyone could throw any  
> ideas in my direction about what the problem might be, as I'll  
> confess that those error messages are beyond me!

Really? We have this bug reported in our issue tracker:

http://trac.macosforge.org/projects/macports/ticket/13953

And a note there says that installing gmake first fixes the issue.  
Does that not work for you?

There's also this ticket:

http://trac.macosforge.org/projects/macports/ticket/13500

which suggests you need nawk installed for sqlite3 to install properly.