To find out what an error mean, you can do #perror <errno>: [root@indigest /root]# perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed
(http://www.mysql.com/doc/p/e/perror.html) So, at least one table from your query is crashed: forums or posts. To recover the table, take a look at: http://www.mysql.com/doc/D/i/Disaster_Prevention.html specially at sections 4.4.5 and 4.4.6. To start, it will be something like #myisamchck -rq table On Wed, 2002-01-23 at 14:27, Tsuna Quack wrote: > Hi everybody, > I'm new to this list and I don't know if my question can be send > here... > > I have a forum in PHP *based* on phpBB and a MySQL problem has > strangly been created in index.php > > On the website, I have this error: > Warning: MySQL: Unable to save result set in > [path]/forum/index.php on line 75 > > For these who know PHP, my line 75 is: > #75: if( (!$f_res = mysql_query($sql)) ) { > > and $sql = "SELECT f.*, u.username, u.user_id, p.post_time FROM > forums f LEFT JOIN posts p ON p.post_id = f.forum_last_post_id > LEFT JOIN users u ON u.user_id = p.poster_id ORDER BY f.cat_id, > f.forum_id"; > > For the others: > my query is: > SELECT f.*, u.username, u.user_id, p.post_time FROM forums f > LEFT JOIN posts p ON p.post_id = f.forum_last_post_id LEFT JOIN > users u ON u.user_id = p.poster_id ORDER BY f.cat_id, f.forum_id > > phpMyAdmin returned: > Got error 127 from table handler > > and I don't understand this error. > I tried to search in the documentation but I didn't found > anything... > > Hope somebody will be able to help me, > > - Tsuna - > > Why must I database and sql and query and table to send my > message ??? > > ----------------------------------------------------------------------- > Weź udział w konkursie i wygraj komputer lub 10 000 zł! < >http://konkurs.wp.pl/inteligo/ > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Diana Soares (sql) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php