Hi all,
i've got a table:
CREATE TABLE [usr_user] ([id] INTEGER PRIMARY KEY AUTOINCREMENT,
[name] TEXT, [email] TEXT, [password] TEXT, [createDate] DATETIME
DEFAULT (NOW()))
see the problem? i figured out myself that "NOW()" as a default value
doesn't work (i'm new with sqlite, coming from mysql - so it didn't
occur to me right away).
now, when i tried to insert a row into this table:
INSERT INTO usr_user ('asdf', '[email protected]', 'somemd5hash')
it crashed sqliteman, sqlitestudio and apache with php5/pdo. in php i
was able to step through the code, crashing occured when preparing
that statement.
for reference, the error reported in apaches error log file is:
[Wed Sep 30 08:24:51 2009] [notice] Parent: child process exited with
status 3221225477 -- Restarting.
i remember the status code to be a different one when trying it from home.
i've tried to replicate it on 3 different systems, all with the same result:
* winXP 32b
* win7 64b
* Linux 2.6.27.7-grsec #25 SMP Mon Feb 16 16:37:38 CET 2009 i686
sqlite info:
PECL Module version: (bundled) 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.4
2008/12/31 11:17:42 sebastian Exp $
SQLite Library: 3.3.7
now, this error is easily fixed by just removing/replacing the
offending default value, but shouldn't it be handelt differently than
just crashing?
thanks, stefan
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
