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' 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
