Database exception when creating user. about rearview

[talbright]

How was it you were trying to create the user, manually? Or was this an exception that occurred during authorization authentication?

[usmanismail]

I was signing in using Open ID with my google apps domain account.

—Usman

On Monday, December 16, 2013, Trent Albright [email protected]
wrote:

How was it you were trying to create the user, manually? Or was this an
exception that occurred during authorization?

—
Reply to this email directly or view it on GitHub.

[talbright]

Can you double check your mysql schema for me. You should see this as the DDL for that column:

`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'

[usmanismail]

See below.

DESCRIBE users;
+------------+--------------+------+-----+---------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra
|
+------------+--------------+------+-----+---------------------+-----------------------------+
| id | bigint(20) | NO | PRI | NULL |
auto_increment |
| created | timestamp | NO | | 0000-00-00 00:00:00 |
|
| modified | timestamp | NO | | CURRENT_TIMESTAMP | on update
CURRENT_TIMESTAMP |
| email | varchar(255) | NO | UNI | NULL |
|
| first_name | varchar(255) | NO | | NULL |
|
| last_name | varchar(255) | NO | | NULL |
|
| last_login | timestamp | YES | | NULL |
|
+------------+--------------+------+-----+---------------------+-----------------------------+

On Monday, December 16, 2013, Trent Albright [email protected]
wrote:

Can you double check your mysql schema for me. You should see this as the
DDL for that column:

created timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'

—
Reply to this email directly or view it on GitHub.

[usmanismail]

I am on mysql 5.6.13, could be an issue with the mysql version?

On Monday, December 16, 2013, Usman Ismail [email protected] wrote:

See below.

DESCRIBE users;

+------------+--------------+------+-----+---------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra
|

+------------+--------------+------+-----+---------------------+-----------------------------+
| id | bigint(20) | NO | PRI | NULL |
auto_increment |
| created | timestamp | NO | | 0000-00-00 00:00:00 |
|
| modified | timestamp | NO | | CURRENT_TIMESTAMP | on
update CURRENT_TIMESTAMP |
| email | varchar(255) | NO | UNI | NULL |
|
| first_name | varchar(255) | NO | | NULL |
|
| last_name | varchar(255) | NO | | NULL |
|
| last_login | timestamp | YES | | NULL |
|

+------------+--------------+------+-----+---------------------+-----------------------------+

On Monday, December 16, 2013, Trent Albright [email protected]
wrote:

Can you double check your mysql schema for me. You should see this as
the DDL for that column:

created timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'

—
Reply to this email directly or view it on GitHub.

[talbright]

I'm targeting the end of the week for a new release of rearview (rewritten in ruby), so it may be more efficient to just wait for that.

[talbright]

I'm still working out some kinks over the holidays, but you can see the progress here: https://github.com/livingsocial/rearview/tree/ruby-port