ginatrapani/ThinkUp — Issue #1177: MySQL missing default value in tu_instances/last_post_id
Author: clescuyer
Created: 2011-11-22 09:49:16+00:00
State: open

Trying to create first Facebook app:

Database error!
ThinkUp could not execute the following query:
INSERT INTO tu_instances (network_user_id, network_username, network, network_viewer_id) VALUES (:user_id , :username, :network, :viewer_id)
PDOException: SQLSTATE[HY000]: General error: 1364 Field 'last_post_id' doesn't have a default value

**Possible migration:**

ALTER TABLE tu_instances MODIFY last_post_id varchar(80) NOT NULL COMMENT 'Last network post ID fetched for this instance.' DEFAULT '';