Joomla error Warning: Invalid argument supplied for foreach() in .../libraries/joomla/database/database/mysql.php on line 383

This error made me headache for a morning.
These warnings are displayed instead of displaying articles
 You can also have a problem when you login  to admin panel and can not read some articles, category,..
Also, using phpmyadmin can not get table structure although you repair them.
Anyway, you can see this error when trying to save configuration file:

“The Global Configuration extension could not be found. Text filter settings have not been saved.”

 

The problem is: tmp of mysql server is full
Solution: Clear tmp
Done!