While every Learner record in Ability LMS has a unique 'InternalID', it is possible to have duplicate Learner Profiles in AbilityLMS. So, even though the two Learner records may have the same Learner ID, they will have different InternalIDs values. You can use the SQL Processor to determine the InternalID that is in use for each profile. Select Configuration | SQL Processor to open the SQL Statement Processor page. 



Then copy and paste the statement below, replacing the <YOUR LEARNER ID> value (including the symbols) with the Learner ID in question:


SELECT InternalID FROM Learners WHERE Learner_Id='<YOUR LEARNER ID>'



InternalIDs are allocated sequentially, so the earlier record will have a lower InternalID.  Decide which record to delete and then copy and paste the statement below, replacing the <YOUR CHOSEN  INTERNAL ID> value (including the symbols) with the Learner ID in question:, again in SQL Processor:


DELETE Learners WHERE InternalD='<YOUR TARGET INTERNAL ID>'


This will only delete the Learners record,it won't delete things like history or tracks.




TIP:  Locating SQL Passwords


Below are the steps in locating the password needed for SQL Processor.


1.  Under the MANAGER MENU go to CONFIGURATION.



2.  On Configuration page, click on CONFIGURATION MANAGER to open the Configuration Manager page and type in SQL on the search box.




3. Under the VALUE column the System Administrator can view the password the will be needed for the SQL Processor. Each command corresponds to a certain password, for example the password that was used for SELECT command earlier was aaa and ddd is used for DELETE.