[phpesp-general] Problem - Blank Report

[Steve G. <gr...@um...>]

I relatively new to phpESP but have installed and used it for several 
surveys and been very happy with it.  I'm running v1.6 with MySQL 
3.23.32.  I completed a survey a couple of months ago which I ended and 
viewed the survey results and all was well.

Just yesterday I needed to look at the survey results again for an 
evaluation I was writing and all the questions had zeros (o) in the 
summary tabulation fields.  On the "Pick Survey to View" page it shows 
that I have 58 responses to the survey.  However, when I click on the 
link to view the survey results (all questions come up just fine) there 
are zeros in the average rank column.  BTW almost all the questions are 
"rank" type questions.

I did a little poking around in the database and I found the survey was 
still in the survey table and all the respondents were in the response 
table.  However, when I tried to view the response_rank table I rec'd 
the following error:

Error

SQL-query :

SHOW KEYS FROM `response_rank`

MySQL said:

Can't open file: 'response_rank.MYD'. (errno: 145)

I'm no SQL expert (I use phpMyAdmin) but think this must have something 
to do with it.

Can someone point me in the right direction on fixing this.

Thank-you,

Steve

-------------
Steve Gray
LStech.Org Project
Ann Arbor, MI
http://lstech.org