MySQL PHP Will Not Save The Results In Set
👤 By wallpaperama | 📆
Are you getting this error on you php pages with mysql that says Warning: mysql_query() [function.mysql-query]: Unable to save result set in line xx - well if you want to know what this error means i will try to explain what i was doing when i got this error myself.
so there i was, i was loading some heavy data into mysql database, it was running for a while now. and at the same time, i had started a ssh session on my server. then i accidentally restarted mysql server. as soon as the mysql server was restarted, i saw this error:
so basically, you are probably getting this error message also because the connection to your mysql was lost. did you powered off your server? did you lose power? did it crashed?
you might want to ping your server to see if its running, if it is, try restarting your server, this is the command i used to restart my database server:
hope that helps
so there i was, i was loading some heavy data into mysql database, it was running for a while now. and at the same time, i had started a ssh session on my server. then i accidentally restarted mysql server. as soon as the mysql server was restarted, i saw this error:
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /var/www/counts.php on line 29
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/counts.php on line 30
SQL ERROR LINE: 39
Lost connection to MySQL server during query
so basically, you are probably getting this error message also because the connection to your mysql was lost. did you powered off your server? did you lose power? did it crashed?
you might want to ping your server to see if its running, if it is, try restarting your server, this is the command i used to restart my database server:
/etc/init.d/mysqld restart
hope that helps