Try removing the comma before the closing parenthesis? And add a semi-Colin after the create table command.
On Aug 9, 2012, at 12:04 AM, "Brandon Pimenta" <brandonskypime...@gmail.com> wrote: > I just found a bug in SQLite. It says "1: near ")": syntax error". Here's > my SQL query: > > CREATE TABLE online_status ( > username varchar(255) NOT NULL default '', > timestamp char(14) NOT NULL default '', > ) > CREATE INDEX username ON online_status (username); > > It returns this error. What does this error mean, and where is the error? > _______________________________________________ > 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