Sql is correct, but php cannot query it.

I wrote a query in thinkphp, but I couldn"t find it out, and then I printed it out

.

clipboard.png

clipboard.png

shows that it is successful. I don"t know what"s going on. I ask for help from all the great gods

.
Mar.11,2021

Please delete all caches in runtime and other directories in the thinkphp framework, and try again.


if there is a database field cache in thinkphp, if tp3 is in _ fields under Data under runtime, if you use the command to clear the field cache or delete the cache file


sometimes it is found that there are two databases locally. One has data and the other has no data, and then php connects to those without data


two possibilities
1. Database caching is enabled
2. Query caching is enabled

clear the runtime directory

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1beb740-46abf.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1beb740-46abf.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?