Re: [phpesp-general] Problem - Blank Report

[Matthew G. <gr...@mu...>]

That error usually means a corrupt mysql table.
Connect to your mysql server with a user that has "admin" privileges
with the command line mysql client.
Something like:
"mysql -h yourhost -u youruser -p yourESPdb"

then try to run repair table:
"repair table response_rank;"

You can also try from the command line:
myisamchk -r response_rank.

Consult these mysql links for more info:
http://www.mysql.com/doc/en/Corrupted_MyISAM_tables.html
http://www.mysql.com/doc/en/Repair.html

On Mon, 2004-03-08 at 23:54, Steve Gray wrote:
> 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
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)