Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By huss on
How can I edit some of database table fields?
For example, I need to change the value of "created" field of a node. But when I edit the node, only the "Changed" field can be edited.
These fields affect the way of displaying and sorting the content by date (e.g. on the FrontPage).
Thank you!
Comments
When adding/editing do you see "Authoring information"
When adding/editing do you see "Authoring information" down toward the bottom of the form. If yes, click to expand at set the "Authored on:" field.
Yes, but I would like to
Yes, but I would like to change another field. In the Node tables in the database, I see two data/time fields - for the date of creation and for the date of modifying the node. I need to change the first one.
Authored on does change the creation date
Authored on does change the creation date, the modify date is handled by the node module.
Thank you, but is there a
Thank you, but is there a way to change the value of the other field?
For that you would need to edit the database
As far as I know you would need to edit the database or write a script to change the value.