Lookup table failed when migrating from localhost server

PHPMaker General Discussion (PHPMaker)
1

Hi,
I’ve just update phpmaker to 2021.0.1. Even though I’m using the same codebase and connect to the same database, All the combo box that lookup to another table/view showed empty in the server but it works on the localhost (on my computer). Is there any step that I miss?

2

Yes, please have a look at the following information: https://discourse.hkvstore.com/t/migrating-to-v2022/655/1

3

I create a new project in PHPM 2021. And I believe I’ve already followed the instruction (for the URL rewrite, etc). Is there any step that i miss? And please note that it’s working perfectly in the localhost

Is it possible because we use NGINX server? And is there any modification that we should make for the .htaccess file?

4

knkplans wrote:

Is it possible because we use NGINX server? And is there any modification that we should make for the .htaccess file?

You may see: http://www.slimframework.com/docs/v4/start/web-servers.html#nginx-configuration.

Note: According to above article, you need to setup the Nginx virtual host configuration (e.g. /etc/nginx/sites-available/mysite.com.conf, not a .htaccess file) for the domain.

5

After we use apache (and not NGINX), it worked perfectly.

6

knkplans wrote:

After we use apache (and not NGINX), it worked perfectly.

same problem with blank lookup tables trying to switch from apache to nginx.