Hello, I uploaded my site to hosting and when I try to use my get filter or list content of some database tables, I get error like … Column not found: 1054 Unknown column …
On my local wamp installation, everything is working:
Even, some database tables are displayed also on production site.
Can anyone please help me how to set up my app to work on my php hosting?
Thank you very much!
BTW, Identifier Quoting is enabled.
Assuming you have the exact same database structure on both your local & live, have you cleared the cache in case that column its not finding is a new field?
bin/cake cache clear_all
Thank you very much for your reply.
The issue was that I had lowercase column name in my filter. Probably, this was not a problem for Windows 10 WAMP installation but it was problem for my Linux hosting.
Example of code that does not work:
Example of code that works:
So the only difference is in capitalization of table column names. Interesting thing is that in my database, the column names are lowercase.
The column name in both of your examples are lowercase. It’s the Table Name, that has to be uppercase.