This happened after I insert new value to table:

symfony SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid
input syntax for integer: ""

Form for inserted is auto-generated with

php symfony doctrine:generate-module --with-show --non-verbose-
templates frontend sprints rank_sprints

schema.yml:

rank_sprints:
  columns:
    sprint_id:
      primary: true
      type: serial
    sprint_name:
      unique: true
      type: string(255)
      notnull: true
    sprint_start:
      type: date
      notnull: true
    sprint_end:
      type: date
      notnull: true
    sprint_summary:
      type: string
    created:
      default: 'now'
      type: timestamp
      notnull: true

all code is auto-generated, there were no manual editings...

There is call-stack

1       Info sfPatternRouting   Match route "default" (/:module/:action/*)
for /sprints/edit/sprint_id/ with parameters array ( 'module' =>
'sprints', 'action' => 'edit', 'sprint_id' => '',)
2       Info sfFilterChain      Executing filter "sfRenderingFilter"
3       Info sfFilterChain      Executing filter "sfExecutionFilter"
4       Info sprintsActions     Call "sprintsActions->executeEdit()"
5       Info Doctrine_Connection_Pgsql  exec : SET NAMES 'UTF8' - ()
6       Info Doctrine_Connection_Statement      execute : SELECT r.sprint_id AS
r__sprint_id, r.sprint_name AS r__sprint_name, r.sprint_start AS
r__sprint_start, r.sprint_end AS r__sprint_end, r.sprint_summary AS
r__sprint_summary, r.created AS r__created FROM rank_sprints r WHERE
(r.sprint_id = ?) LIMIT 1 - ()
7       Error Doctrine_Connection_Pgsql_Exception       SQLSTATE[22P02]: Invalid
text representation: 7 ERROR: invalid input syntax for integer: ""
8       Info sfWebResponse      Send status "HTTP/1.1 500 Internal Server Error"
9       Info sfWebResponse      Send header "Content-Type: text/html;
charset=utf-8"

-- 
If you want to report a vulnerability issue on symfony, please send it to 
security at symfony-project.com

You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en

Reply via email to