I started with DBD::SQLite 1.26_05 and went back as much as DBD::SQLite 1.21. Kept on getting segfaults. Any further back, and I got DBD::SQLite 1.14 which bundled FTS2, so that wasn't good as well.
Finally, the amazing Audrey Tang to rescue. I downloaded the classic DBD::SQLite::Amalgamation 3.6.12 (http://search.cpan.org/~audreyt/DBD-SQLite-Amalgamation-3.6.1.2/), replaced the .c and .h files in it with those from the latest tarball of original source 3.6.19, built it, and it works just fine, thank you very much. Of course, now my problem is that I have to somehow convince my shared web host provider to also do the above rigmaroo or wait until the default version from CPAN starts working again. FTS3, in my personal view, is far more useful and important than getting Foreign Keys support. That is because the latter can be emulated in the app code, but the former can't. Will be grateful when FTS3 is working again flawlessly in the publicly available CPAN version. -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= Sent from Madison, WI, United States _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users