(public).sospep.events ~ view task ~ FIX-PRB-1660

<h1 style="text-align: center;">PRB-Register (new user)</h1>
<ol>
<li><strong>TITLE =</strong></li>
<ol>
<li>'PRB-PG-Register' DB error</li>
</ol>
<li><strong>DESC =</strong></li>
<ol>
<li>WHEN='click Register' RESULT='error msg', msg='db error',</li>
<li>*] ( possibly since db_9 was assigned on jan 30,2013 )</li>
</ol>
<li><strong>[WHERE]</strong></li>
<ol>
<li>] ON PG = 'Register'&nbsp;</li>
</ol>
<li><strong>[WHEN]</strong></li>
<ol>
<li>] ON submit new registration form</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>] = ''</li>
</ol>
<li><strong>[TRY =]</strong></li>
<ol>
<li>x] edited users registration db, first avail is db_6 then db10</li>
<li>x] tested using getNextAvailable method from admin app</li>
<li>x] reset existing dbs that were marked as N/A ( all existing )</li>
<li>x] renamed existing from db-10, db-10 to db10, db11 <span style="background-color: #ffff99;">( '-' is NOT a valid character for mysql name, '_' puts all the db's under 1 )</span></li>
<li>x] cc DB INV create new db's, db13 ... db17</li>
<li><strong>[TEST=]</strong></li>
<ol>
<li>x]&nbsp;</li>
<li>x] FAIL - error, email goes through but when click confirmation link getting error</li>
<li>x] permissions on ...</li>
<li>] &nbsp;</li>
</ol>
<li><strong>[RESULT=]</strong></li>
<ol>
<li>x] PUBLISHED as rev-032</li>
</ol></ol>
<li><strong>[RESOLUTION=]</strong></li>
<ol>
<li>] add db inventory, ] reset db records, ] permissions</li>
</ol>
<li><strong>[STATUS]</strong></li>
<ol>
<li>X] RESOLVED, ] Pending,] Working</li>
</ol>
<li><strong>[OTHER]</strong></li>
<ol>
<li>openDate: 2013-05-17</li>
<li>openBy: don.sagrott</li>
<li>startDate: 2013-05-17</li>
<li>completeDate: 2013-05-21</li>
<li>owner: don.sagrott</li>
<li>time:&nbsp;</li>
</ol></ol>
<h2>[previously]</h2>
<ol>
<li><strong>]</strong></li>
</ol>
<h2>[currently]</h2>
<ol>
<li>] &nbsp;</li>
</ol>
<h2>[next]</h2>
<ol>
<li>] TEST =edit existing inventory to delete my existing users, TRY create new accounts using, TEST new dbs,&nbsp;</li>
</ol>

~ view task ~ TaskGroup] PROBLEMS-Solutions FROM [ Plan] doc-projects IN [ calendars] prj-022-sospep