# Urgent! Cant add data to database from UI

**URL:** <https://community.forestadmin.com/t/urgent-cant-add-data-to-database-from-ui/710>\
**Category:** Help me!\
**Tags:** howtos\
**Created:** [July 22, 2020, 6:32pm UTC](https://community.forestadmin.com/t/urgent-cant-add-data-to-database-from-ui/710 "2020-07-22T18:32:13Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![BK42](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/bk42/32/568_2.png) [@BK42](https://community.forestadmin.com/u/BK42)\
**Post date:** [July 22, 2020, 6:32pm UTC](https://community.forestadmin.com/t/urgent-cant-add-data-to-database-from-ui/710/1 "2020-07-22T18:32:13Z")

</div>

I just connected to the DB, tried creating my first row from the admin panel.

## Expected behavior

It gets saved with no error

## Actual behavior
 creation failed: invalid input syntax for type timestamp: "Invalid date" This happens even when I put deleted at the date to make sure it is not empty:

 ![Screen Shot 2020-07-22 at 11.24.35 AM](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/1X/16ff8f5cee15f06ba39f91ba25b5ff082e950b1a.png)

## Failure Logs

Deprecation warning: value provided is not in a recognized RFC2822 or ISO format. moment construction falls back to js Date(), which is not reliable across all browsers and versions. Non RFC2822/ISO date formats are discouraged and will be removed in an upcoming major release. Please refer to [http://momentjs.com/guides/#/warnings/js-date/](http://momentjs.com/guides/#/warnings/js-date/) for more info.  
Arguments:  
[0] \_isAMomentObject: true, \_isUTC: false, \_useUTC: false, \_l: undefined, \_i: CURRENT\_TIMESTAMP, \_f: undefined, \_strict: undefined, \_locale: [object Object]  
Error  
at Function.createFromInputFallback (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/moment/moment.js:319:25)  
at configFromString (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/moment/moment.js:2536:19)  
at configFromInput (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/moment/moment.js:2978:13)  
at prepareConfig (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/moment/moment.js:2961:13)  
at createFromConfig (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/moment/moment.js:2928:44)  
at createLocalOrUTC (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/moment/moment.js:3022:16)  
at createLocal (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/moment/moment.js:3026:16)  
at hooks (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/moment/moment.js:16:29)  
at DATE.\_applyTimezone (/Users/bk/server-admin/node\_modules/sequelize/lib/data-types.js:460:21)  
at DATE.\_stringify (/Users/bk/server-admin/node\_modules/sequelize/lib/data-types.js:465:17)  
at DATE.\_stringify (/Users/bk/server-admin/node\_modules/sequelize/lib/dialects/postgres/data-types.js:175:20)  
at DATE.stringify (/Users/bk/server-admin/node\_modules/sequelize/lib/data-types.js:23:19)  
at DATE.bindParam (/Users/bk/server-admin/node\_modules/sequelize/lib/data-types.js:31:35)  
at PostgresQueryGenerator.format (/Users/bk/server-admin/node\_modules/sequelize/lib/dialects/abstract/query-generator.js:1011:29)  
at PostgresQueryGenerator.insertQuery (/Users/bk/server-admin/node\_modules/sequelize/lib/dialects/abstract/query-generator.js:201:30)  
at QueryInterface.insert (/Users/bk/server-admin/node\_modules/sequelize/lib/query-interface.js:880:37)  
at Promise.try.then.then.then (/Users/bk/server-admin/node\_modules/sequelize/lib/model.js:3985:52)  
at tryCatcher (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/util.js:16:23)  
at Promise.\_settlePromiseFromHandler (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/promise.js:547:31)  
at Promise.\_settlePromise (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/promise.js:604:18)  
at Promise.\_settlePromise0 (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/promise.js:649:10)  
at Promise.\_settlePromises (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/promise.js:729:18)  
at \_drainQueueStep (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/async.js:93:12)  
at \_drainQueue (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/async.js:86:9)  
at Async.\_drainQueues (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/async.js:102:5)  
at Immediate.Async.drainQueues [as \_onImmediate] (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/async.js:15:14)  
at processImmediate (internal/timers.js:443:21)  
[forest] 🌳🌳🌳 Unexpected error: invalid input syntax for type timestamp: “Invalid date”  
SequelizeDatabaseError: invalid input syntax for type timestamp: “Invalid date”  
at Query.formatError (/Users/bk/server-admin/node\_modules/sequelize/lib/dialects/postgres/query.js:354:16)  
at query.catch.err (/Users/bk/server-admin/node\_modules/sequelize/lib/dialects/postgres/query.js:71:18)  
at tryCatcher (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/util.js:16:23)  
at Promise.\_settlePromiseFromHandler (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/promise.js:547:31)  
at Promise.\_settlePromise (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/promise.js:604:18)  
at Promise.\_settlePromise0 (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/promise.js:649:10)  
at Promise.\_settlePromises (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/promise.js:725:18)  
at \_drainQueueStep (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/async.js:93:12)  
at \_drainQueue (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/async.js:86:9)  
at Async.\_drainQueues (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/async.js:102:5)  
at Immediate.Async.drainQueues [as \_onImmediate] (/Users/bk/server-admin/node\_modules/sequelize/node\_modules/bluebird/js/release/async.js:15:14)  
at processImmediate (internal/timers.js:443:21)  
POST /forest/divisionOutlines 500 96 - 141.730 ms

## Context

Please provide any relevant information about your setup.

- Package Version:

- Express Version:  
“chalk”: “~1.1.3”,  
“cookie-parser”: “1.4.4”,  
“cors”: “2.8.5”,  
“debug”: “~4.0.1”,  
“dotenv”: “~6.1.0”,  
“express”: “~4.16.3”,  
“express-jwt”: “5.3.1”,  
“forest-express-sequelize”: “^6.0.0”,  
“morgan”: “1.9.1”,  
“require-all”: “^3.0.0”,  
“sequelize”: “~5.15.1”,  
“pg”: “~8.2.2”

- Sequelize Version:

- Database Dialect:

- Database Version:

- Project Name: server-admin

---

<div class="post-metadata">

**Author:** ![Arnaud\_Moncel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/arnaud_moncel/32/24_2.png) [@Arnaud\_Moncel](https://community.forestadmin.com/u/Arnaud_Moncel)\
**Post date:** [July 23, 2020, 9:28am UTC](https://community.forestadmin.com/t/urgent-cant-add-data-to-database-from-ui/710/2 "2020-07-23T09:28:49Z")

</div>

Hi @BK42 👋 thank your for your feedback.  
To understand more easily your issue you faced of, can you provide me the definition of your `Divison Outine` model please.

---

<div class="post-metadata">

**Author:** ![BK42](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/bk42/32/568_2.png) [@BK42](https://community.forestadmin.com/u/BK42)\
**Post date:** [July 23, 2020, 9:20pm UTC](https://community.forestadmin.com/t/urgent-cant-add-data-to-database-from-ui/710/3 "2020-07-23T21:20:27Z")

</div>

Hi @Arnaud_Moncel ,

Thank you for looking into it.

Following is the schema i have in place. I could be 100% wrong, but i suspect there might be a bug in CURRENT\_TIMESTAMP being not formatted in a way that could be understood by postgres.`

```javascript
CREATE TABLE IF NOT EXISTS division_outlines(
    id serial PRIMARY KEY,
    created_at timestamp default current_timestamp,
    updated_at timestamp default current_timestamp,
    deleted_at timestamp,

    name VARCHAR (50) UNIQUE NOT NULL,
    ao_involvement VARCHAR (50) NOT NULL,
    description VARCHAR (255)
);

CREATE TABLE IF NOT EXISTS function_outlines(
    id serial PRIMARY KEY,
    created_at timestamp default current_timestamp,
    updated_at timestamp default current_timestamp,
    deleted_at timestamp,

    name VARCHAR (50) UNIQUE NOT NULL,
    folder VARCHAR (50)
);

CREATE TABLE function_outlines_division_outlines (
    function_outline_id int REFERENCES function_outlines (id) ON UPDATE CASCADE,
    division_outline_id int REFERENCES division_outlines (id) ON UPDATE CASCADE,
    CONSTRAINT function_outlines_division_outlines_pkey PRIMARY KEY (function_outline_id, division_outline_id)
);

```

---

<div class="post-metadata">

**Author:** ![arnaud](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/arnaud/32/32_2.png) [@arnaud](https://community.forestadmin.com/u/arnaud)\
**Post date:** [July 24, 2020, 12:14pm UTC](https://community.forestadmin.com/t/urgent-cant-add-data-to-database-from-ui/710/4 "2020-07-24T12:14:34Z")

</div>

Hi @bk42

It is probably an issue with the model related to this table.  
Could you please share with us the content of your generated `/models/division_outlines.js` model?

Thanks for your help.

---

<div class="post-metadata">

**Author:** ![BK42](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/bk42/32/568_2.png) [@BK42](https://community.forestadmin.com/u/BK42)\
**Post date:** [July 24, 2020, 6:12pm UTC](https://community.forestadmin.com/t/urgent-cant-add-data-to-database-from-ui/710/5 "2020-07-24T18:12:11Z")

</div>

See model below, should ‘CURRENT\_TIMESTAMP’ be actual JS date object/UNIX timestamp?

```javascript
// This model was generated by Lumber. However, you remain in control of your models.
// Learn how here: https://docs.forestadmin.com/documentation/v/v6/reference-guide/models/enrich-your-models
module.exports = (sequelize, DataTypes) => {
  const { Sequelize } = sequelize;
  // This section contains the fields of your model, mapped to your table's columns.
  // Learn more here: https://docs.forestadmin.com/documentation/v/v6/reference-guide/models/enrich-your-models#declaring-a-new-field-in-a-model
  const DivisionOutlines = sequelize.define('divisionOutlines', {
    createdAt: {
      type: DataTypes.DATE,
      defaultValue: "CURRENT_TIMESTAMP",
    },
    updatedAt: {
      type: DataTypes.DATE,
      defaultValue: "CURRENT_TIMESTAMP",
    },
    deletedAt: {
      type: DataTypes.DATE,
    },
    name: {
      type: DataTypes.STRING,
    },
    aoInvolvement: {
      type: DataTypes.STRING,
    },
    description: {
      type: DataTypes.STRING,
    },
  }, {
    tableName: 'division_outlines',
    underscored: true,
    schema: process.env.DATABASE_SCHEMA,
  });

  // This section contains the relationships for this model. See: https://docs.forestadmin.com/documentation/v/v6/reference-guide/relationships#adding-relationships.
  DivisionOutlines.associate = (models) => {
    DivisionOutlines.belongsToMany(models.functionOutlines, {
      through: 'functionOutlinesDivisionOutlines',
      foreignKey: 'division_outline_id',
      otherKey: 'function_outline_id',
    });
  };

  return DivisionOutlines;
};

```

---

<div class="post-metadata">

**Author:** ![anon20071947](https://avatars.discourse-cdn.com/v4/letter/a/b5a626/32.png) [@anon20071947](https://community.forestadmin.com/u/anon20071947)\
**Post date:** [July 25, 2020, 9:30am UTC](https://community.forestadmin.com/t/urgent-cant-add-data-to-database-from-ui/710/6 "2020-07-25T09:30:30Z")

</div>

Hi @BK42 👋🏼

The fix below should get you going, can you please apply it to your different models where you have the `createdAt` and `updatedAt` fields?

```javascript
// This model was generated by Lumber. However, you remain in control of your models.
// Learn how here: https://docs.forestadmin.com/documentation/v/v6/reference-guide/models/enrich-your-models
module.exports = (sequelize, DataTypes) => {
  const { Sequelize } = sequelize;
  // This section contains the fields of your model, mapped to your table's columns.
  // Learn more here: https://docs.forestadmin.com/documentation/v/v6/reference-guide/models/enrich-your-models#declaring-a-new-field-in-a-model
  const DivisionOutlines = sequelize.define('divisionOutlines', {
    createdAt: {
      type: DataTypes.DATE,
      defaultValue: Sequelize.literal('CURRENT_TIMESTAMP'),
    },
    updatedAt: {
      type: DataTypes.DATE,
      defaultValue: Sequelize.literal('CURRENT_TIMESTAMP'),
    },
    deletedAt: {
      type: DataTypes.DATE,
    },
    name: {
      type: DataTypes.STRING,
    },
    aoInvolvement: {
      type: DataTypes.STRING,
    },
    description: {
      type: DataTypes.STRING,
    },
  }, {
    tableName: 'division_outlines',
    underscored: true,
    schema: process.env.DATABASE_SCHEMA,
  });

  // This section contains the relationships for this model. See: https://docs.forestadmin.com/documentation/v/v6/reference-guide/relationships#adding-relationships.
  DivisionOutlines.associate = (models) => {
    DivisionOutlines.belongsToMany(models.functionOutlines, {
      through: 'functionOutlinesDivisionOutlines',
      foreignKey: 'division_outline_id',
      otherKey: 'function_outline_id',
    });
  };

  return DivisionOutlines;
};

```

We will look into what went wrong during the models generation and keep you posted.

Let us know if you need anything else 🙂

---

<div class="post-metadata">

**Author:** ![BK42](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/bk42/32/568_2.png) [@BK42](https://community.forestadmin.com/u/BK42)\
**Post date:** [July 26, 2020, 9:28pm UTC](https://community.forestadmin.com/t/urgent-cant-add-data-to-database-from-ui/710/7 "2020-07-26T21:28:39Z")

</div>

Hi @anon20071947,

That did the trick, ForestAdmin community is the best 🙌

Thanks a tonne!  
-BK

---

<div class="post-metadata">

**Author:** ![BK42](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/bk42/32/568_2.png) [@BK42](https://community.forestadmin.com/u/BK42)\
**Post date:** [September 1, 2020, 4:43am UTC](https://community.forestadmin.com/t/urgent-cant-add-data-to-database-from-ui/710/8 "2020-09-01T04:43:58Z")

</div>

Did we fix anything at the model generation level to address this? I think my lumber is still generating models `defaultValue: "CURRENT_TIMESTAMP"`