[patch] Adding new ARP gives error: field delete doesn't have a default value

[GoogleCodeExporter]

I have attached a patch that fixes this issue.

What steps will reproduce the problem? Please provide file name if
possible.
1. sign in (mailtoken)
2. click 'ARP' tab
3. click the green + sign

What is the expected output? What do you see instead?

It should display a form for the new ARP, instead the AJAX POST receives the 
following error:

Backtrace:
0 /opt/janus/www/module.php:180 (N/A)
Caused by: PDOException: SQLSTATE[HY000]: General error: 1364 Field 'deleted' 
doesn't have a default value
Backtrace:
5 /opt/janus/modules/janus/lib/Database.php:146 (PDOStatement::execute)
4 /opt/janus/modules/janus/lib/Database.php:146 (sspmod_janus_Database::execute)
3 /opt/janus/modules/janus/lib/ARP.php:195 (sspmod_janus_ARP::save)
2 /opt/janus/modules/janus/www/AJAXRequestHandler.php:138 (setARP)
1 /opt/janus/modules/janus/www/AJAXRequestHandler.php:41 (require)
0 /opt/janus/www/module.php:135 (N/A)

What version of the product are you using?

JANUS version: 1.10.3
SimpleSAMLphp version: SVN r3029
Browser: Safari 5.1.3
PHP version: 5.3.3-7
Database version: MariaDB 5.1.60
OS: Debian 6.0.4

Additional info:
I have checked that janus.sql does not provide default value and that current 
JANUS SVN trunk still contains this bug.

Original issue reported on code.google.com by laas.t...@gmail.com on 10 Feb 2012 at 2:47

Attachments:

• ARP_deleted.patch

[GoogleCodeExporter]

Original comment by j...@wayf.dk on 13 Feb 2012 at 10:00

• Changed state: Accepted
• Added labels: Milestone-Release1.11
• Removed labels: ****

[GoogleCodeExporter]

This issue was closed by revision r980.

Original comment by j...@wayf.dk on 16 Feb 2012 at 11:53

• Changed state: Fixed
• Added labels: ****
• Removed labels: ****