edit-task

Task Description: {"PRB:":"view-article-416 WHEN created field does NOT have a valid timestamp value,"}

Start Date:

Start Time:

Duration:

Priority:

Status: To Do Completed In Process

Add Photo:

Owner ID:

Content: use HTML Edit Content <h1 style="text-align: center;">PRB-view/article?id=416</h1> <ol> <li><strong>TITLE =</strong></li> <ol> <li>x]&nbsp;PRB - view/article "sospep learn-more" (id=416)</li> </ol> <li><strong>DESC =</strong></li> <ol> <li>x] WHEN='view/article ?id=#' RESULT='error msg', msg='db error',</li> <li>x] PRB - error object not set&nbsp;</li> </ol> <li><strong>[WHERE]</strong></li> <ol> <li>] ON PG = 'view/article'&nbsp;</li> </ol> <li><strong>[WHEN]</strong></li> <ol> <li>x] any 'article record' does NOT have a value assigned to the created field(TIMESTAMP)</li> </ol> <li><strong>[WHAT.HAPPENS.WHEN]</strong></li> <ol> <li>x] ERROR MSG&nbsp;= 'db ERROR'</li> <li>x] ERROR MSG DETAILS ='*cannot convert null to int*'</li> </ol> <li><strong>[CAUSE.SUSPECT]</strong></li> <ol> <li>] = ' PREV&nbsp;PG update to display created field, DID NOT TEST records with NULL value in this field'</li> </ol> <li><strong>[TRY =]</strong></li> <ol> <li>x] db public - fill feild with valid value,&nbsp;</li> <li>] db inventory - db_1 ... db_x</li> <li><strong>[TEST=]</strong></li> <ol> <li>x] PASS</li> </ol> <li><strong>[RESULT=]</strong></li> <ol> <li>x] PG displays properly after valid value is assigned to created field</li> </ol></ol> <li><strong>[RESOLUTION=]</strong></li> <ol> <li>x] UPDATE articles set created=2012-01-01 13:00:00,&nbsp;</li> <li>x] VERIFY v-012 DB template -- 001] CHECK table article created NOT NULL</li> </ol> <li><strong>[STATUS]</strong></li> <ol> <li>] RESOLVED, ] Pending,i] Working</li> </ol> <li><strong>[OTHER]</strong></li> <ol> <li>openDate: 2013-05-18</li> <li>openBy: don.sagrott</li> <li>startDate: 2013-05-18</li> <li>completeDate: 2013-05-18</li> <li>owner: don.sagrott</li> <li>time: 1.0</li> </ol></ol> <h2>[previously]</h2> <ol> <li>]</li> </ol> <h2>[currently]</h2> <ol> <li>] db inventory - db_1 ... db_x</li> </ol> <h2>[next]</h2> <ol> <li>]&nbsp;</li> </ol>