jjdejong / phpip-legacy

Patent and other IP rights portfolio manager and docketing system
GNU General Public License v3.0
1 stars 3 forks source link

how to set a french filling date of an application #9

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.Create a new French Patent App
2.Try to set the filing date in the past

What is the expected output? What do you see instead?
an output similar as if it was another patent application

What version of the product are you using? On what operating system?

Please provide any additional information below.
this is what I get: 
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a 
child row: a foreign key constraint fails (`phpip`.`task`, CONSTRAINT 
`fk_assigned_to` FOREIGN KEY (`assigned_to`) REFERENCES `actor` (`login`) ON 
DELETE SET NULL ON UPDATE CASCADE)

Original issue reported on code.google.com by alexandr...@gmail.com on 23 Oct 2014 at 12:23

GoogleCodeExporter commented 9 years ago
Hi Alexandre,

Thank you for this bug report. Indeed, as you stated in the LinkedIn 
discussion, this bug was due to the presence of an undefined actor in the 
assigned_to column of the task table in the database creation script 
(phpip_skel-current.sql).

The undefined actor has been replaced by 'NULL' in the latest commit.

Original comment by jean-jac...@gadz.org on 27 Oct 2014 at 8:28