Hello ..
I've Mysql,Php Newbie ..
I was adding articles to my Database and suddenly the main page of my site started not to open ..
The error is :
Warning: MySQL: Unable to save result set in /home/admin/www/eng/html/index.php on line 29
1030: Got error 127 from table handler
The line 29 in index.php is :
$result = mysql_query("SELECT sid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes FROM stories ORDER BY sid DESC limit 6");
if(!$result) {
echo mysql_errno(). ": ".mysql_error(). "<br>"; exit();
}
I've checked the Table stories through : PhpMyAdmin and I can browse all of it without errors ..
Can anybody suggest what should I do to get my page working again?
Thanks
I've Mysql,Php Newbie ..
I was adding articles to my Database and suddenly the main page of my site started not to open ..
The error is :
Warning: MySQL: Unable to save result set in /home/admin/www/eng/html/index.php on line 29
1030: Got error 127 from table handler
The line 29 in index.php is :
$result = mysql_query("SELECT sid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes FROM stories ORDER BY sid DESC limit 6");
if(!$result) {
echo mysql_errno(). ": ".mysql_error(). "<br>"; exit();
}
I've checked the Table stories through : PhpMyAdmin and I can browse all of it without errors ..
Can anybody suggest what should I do to get my page working again?
Thanks