ginatrapani/ThinkUp — Issue #1178: MySQL missing default value in tu_users/last_post_id
Author: clescuyer
Created: 2011-11-22 09:56:39+00:00
State: open

First facebook app creation:

Database error!
ThinkUp could not execute the following query:
INSERT INTO tu_users (user_id, user_name, full_name, avatar, location, description, url, is_protected, follower_count, post_count, found_in, joined, network ) VALUES ( :user_id, :username, :full_name, :avatar, :location, :description, :url, :is_protected, :follower_count, :post_count, :found_in, :joined, :network )
PDOException: SQLSTATE[HY000]: General error: 1364 Field 'last_post_id' doesn't have a default value

**Possible migration:**

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