Symptoms

When trying to Start a Review session on experiment data using Ponemah v6.30, Ponemah seems to be "stuck" at the point when it loads events:

If you wait a couple hours, Ponemah will eventually open and the events table will contain several hundreds of thousands of events. 

Workaround

Follow these steps to delete all records in the Events table: 

1. Run C:\Ponemah\Utils\SQLBrowser\SQLiteBrowser.exe. 
2. Click Open Database
3. Select the PnmMarks file that has a corrupt Event table. 
4. Click the Execute SQL tab. 
5. Type in the following command:
   DELETE FROM `ExperimentEvent` WHERE `_rowid_`>0;  
6. Click the Play button to execute the command: 
   
   
   
   
7. The log field should indicate that the query executed successfully: 
   
   
   
   
8. Select the File menu | Compact Database:
   
   
   
   
9. Click OK.
10. Select the File menu | Write changes. 
11. Select the File menu | Exit.

You may now Start the Review session for your Experiment. The Events for the Subject(s) whose Events tables were deleted may be reentered within Review.