I need your helps for this issue.
I created view name stock_view for a table from my database.
Everything working well on my local (create and view on phpmyadmin are ok).
Since I ran command to create view on Server. It's table view is created successfully but if I clicked on stock_view, then it took long time then it showed a message :
I ran a query but it has no response too
SELECT * FROM stock_view
Here is my server information:
Server type: MySQL Server version: 5.7.36-0ubuntu0.18.04.1 - (Ubuntu) Protocol version: 10 Apache/2.4.29 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/1.1.1 Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 7.2.34-26+ubuntu18.04.1+deb.sury.org+1
Version information: 4.6.6deb5ubuntu0.5
I changed proxy_read_timeout but no luck. I think it is problem with Mysql on my server.
I'm using Vestacp for creating web server.
Thank for your help.