I had a problem compiling Sqlite on ealrier versions of AIX. It turned out to be a linker problem and compiling without the -g optimization solved the problem.
What compiler are you using? Xlc or gcc? Chris Pierce wrote: > Hi, > > I am having problems with SQLite v3.5.7 on AIX v5.2. > > I downloaded the amalgamation tarball. It looks like > it builds fine, but I get an error when I try to > create a table. > > Here's what I'm doing/getting: > > AIX$ ./sqlite3 test.db > SQLite version 3.5.7 > Enter ".help" for instructions > sqlite> create table mytest(first smallint); > Unable to open database "mytest": SQL logic error or > missing database > AIX$ > > I've searched the list's archives and seen some > similar problems, but I have been unable to fix the > problem. > > Looking through the config.log file I guess it's not > building fine. Here are a few things from the log > that may or may not help in troubleshooting: > > 1) configure:3025: cc -c -Os conftest.c >&5 > "conftest.c", line 15.14: 1506-275 (S) Unexpected text > me encountered. > "conftest.c", line 15.8: 1506-045 (S) Undeclared > identifier choke. > configure:3031: $? = 1 > configure: failed program was: > | /* confdefs.h. */ > | #define PACKAGE_NAME "sqlite" > | #define PACKAGE_TARNAME "sqlite" > | #define PACKAGE_VERSION "3.5.7" > | #define PACKAGE_STRING "sqlite 3.5.7" > | #define PACKAGE_BUGREPORT "http://www.sqlite.org"; > | #define PACKAGE "sqlite" > | #define VERSION "3.5.7" > | /* end confdefs.h. */ > | > | int > | main () > | { > | #ifndef __GNUC__ > | choke me > | #endif > | > | ; > | return 0; > | } > > 2) configure:3279: cc -c -Os conftest.c >&5 > "conftest.c", line 45.39: 1506-195 (S) Integral > constant expression with a value > greater than zero is required. > configure:3285: $? = 1 > configure: failed program was: > | /* confdefs.h. */ > > 3) configure:3279: cc -qlanglvl=extc89 -c -Os > conftest.c >&5 > 1506-173 (W) Option langlvl=extc89 is not valid. > Enter xlc for list of valid op > tions. > "conftest.c", line 45.39: 1506-195 (S) Integral > constant expression with a value > greater than zero is required. > > > I'm not sure if any of this is helpful or not. There > are more errors like this. I can send the whole > config.log if needed. Oh, the system has cc, but > doesn't have gcc, FWIW. > > BTW, I used the Windows version to create a small test > database that works fine in Windows, but when I try to > use it with the AIX build I still get the error: > > AIX$ ./sqlite3 test.db > Unable to open database "test.db": SQL logic error or > missing database > AIX$ > > Sorry for the long message, but if anyone could help I > would greatly appreciate it. > > I'm not much of a C programmer, I'm rusty on *nix, and > I'm not an admin on this system. > > Please let me know if there is other information I > need to send that might help in fixing the problem (or > if I'm just completely missing the obvious cause). > > Thanks! > > Chris > [EMAIL PROTECTED] > > > > > ____________________________________________________________________________________ > You rock. That's why Blockbuster's offering you one month of Blockbuster > Total Access, No Cost. > http://tc.deals.yahoo.com/tc/blockbuster/text5.com > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
