On Apr 16, 2009, at 12:46 PM, Arthur Skowronek wrote:
> Hello,
> I have a problem again with the same database as
> before with the segfault bug.
>
> I can't insert any rows into the userMailBox table with
> this query:
>
> INSERT INTO userMailBox ( userID, senderNickID, isSystem,
> messageSubject, messageBody ) VALUES ( 0, -1, 1, "This is your new
> mailbox", "Messages sent by other users or server will be stored
> here." )
>
> The SQLite CLI prints out that there is no messageSubject
> column but thats not true. Here are the SQL instructions
> to construct the database:
> http://pastebin.com/m61b3a437
>
Where you have
FOR EACH ROW WHEN ( messageSubject = '' )
It should read:
FOR EACH ROW WHEN ( new.messageSubject = '' )
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
