On Mon, Dec 20, 2010 at 1:44 PM, Lee Kulberda <[email protected]>wrote:
> Sorry, in my frustration I posted the wrong code. > > Obviously I need to enable/install the FTS3 module, just having a tough > time finding reliable, specific information on how to do this. > > Here is the code: > > '$table = "CREATE VIRTUAL TABLE indexed_text USING > fts3(tokenize=simple);";' > > and here is the error: > > 'SQLSTATE[HY000]: General error: 1 no such module: fts3' > There is a compile-time option: SQLITE_ENABLE_FTS3 > > lk > ----- Original Message ----- > From: "Richard Hipp" <[email protected]> > To: "General Discussion of SQLite Database" <[email protected]> > Sent: Monday, December 20, 2010 1:36:51 PM GMT -05:00 US/Canada Eastern > Subject: Re: [sqlite] FTS3 indexing in PHP < 5.3 > > On Mon, Dec 20, 2010 at 1:31 PM, Lee Kulberda <[email protected] > >wrote: > > > Hello all > > > > I am trying to run a FTS3 on text files on a server running PHP Version > > 5.2.14. with sqlite 3.5.9 > > > > Going through the command line directly to sqlite3 the virtual tables and > > FTS3 works fine but I am trying to incorporate into a php app. > > > > I get the following error: > > > > SQLSTATE[HY000]: General error: 1 near "USING": syntax error > > > > on this line: > > > > $table = "CREATE TABLE indexed_text USING fts4(tokenize=simple);"; > > > > Should be: "create VIRTUAL table ...". Also, fts4 was added with SQLite > version 3.7.4, so it clearly won't work with version 3.5.9. Use fts3. > > > > > new-ish to sqlite, any help appreciated > > > > lk > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
