edit-task

Task Description: {"PRB:":"Register ON PG - process FAILing with DB ERROR,WHEN=form submitted"}

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-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>