yangxuan Posted August 27, 2018 Share Posted August 27, 2018 it report that server error '500' when you click 'CLEAR CACHE',i find the error log,it report mysql syntax error. Do i need to update the mysql version? Link to comment Share on other sites More sharing options...
bsmither Posted August 27, 2018 Share Posted August 27, 2018 Welcome yangxuan! Glad to see you made it to the forums. The error from Aug 22 is a few days old. In admin, Maintenance, Database tab, that SQL statement should have either OPTIMIZE, REPAIR, CHECK, or ANALYZE just before the word TABLE. Since it does not, perhaps you failed to select an action to perform from the drop-down selector With selected. A 500 Server Error when Clear Cache is clicked will create a different error. Please create the PHP error log. Link to comment Share on other sites More sharing options...
yangxuan Posted August 27, 2018 Author Share Posted August 27, 2018 5 hours ago, bsmither said: Welcome yangxuan! Glad to see you made it to the forums. The error from Aug 22 is a few days old. That SQL statement should have either OPTIMIZE, REPAIR, CHECK, or ANALYZE just before the word TABLE. Since it does not, perhaps you failed to select an action to perform from the drop-down selector With selected. A 500 Server Error when Clear Cache is clicked will create a different error. Please create the PHP error log. thanks for the response!I have found the error_log,it reports some error as follows,does the memory is not enough? [27-Aug-2018 07:16:15 UTC] PHP Warning: get_headers() [<a href='http://docs.php.net/manual/en/function.get-headers.php'>function.get-headers.php</a>]: http:// wrapper is disabled in the server configuration by allow_url_fopen=0 in /home/pcsensor/public_html/classes/catalogue.class.php on line 392 [27-Aug-2018 07:16:15 UTC] PHP Warning: get_headers() [<a href='http://docs.php.net/manual/en/function.get-headers.php'>function.get-headers.php</a>]: This function may only be used against URLs in /home/pcsensor/public_html/classes/catalogue.class.php on line 392 [27-Aug-2018 07:34:00 UTC] PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 2097152 bytes) in /home/pcsensor/public_html/classes/cache/file.class.php on line 87 Link to comment Share on other sites More sharing options...
yangxuan Posted August 27, 2018 Author Share Posted August 27, 2018 i have fix the issure i have change the size of the php_limit_memory to 128M,it's ok now! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.