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
