Error (near “ON” at position 25) while importing Table for WORDPRESS
August 10, 2023
Some time When we import the large database file then shows the errors like as below:
Error Static analysis: 1 errors were found during analysis. Missing expression. (near "ON" at position 25) SQL query: Edit Edit SET FOREIGN_KEY_CHECKS = ON; MySQL said: Documentation #2006 - MySQL server has gone away
The solution of this problem is to change the php.ini values as below:
max_execution_time = 500 max_input_time = 500 memory_limit = 512M post_max_size = 512M max_allowed_packet = 512M
Now restart the services… hope it will work.