Configured Connection and it all seems to be fine. When I try to run App I can open the menu etc. but the moment I try to access any data I get this error:
Error Error while accessing the database:
Unknown table ‘…table name…’
Any idea what else can I check or what might cause this ?
ARTHUR
You get this error on every form? Test connection from prod env works ok?
Could you check if you connection has been lost at application level? One thing to try is to do a bulk edit and reset the connection.
I edited the connection in the Production Environment tool. Tested and it says OK. when I open the Project all Apps that read the SQL table report the same error, so the thole project has no connectivity. Of course internet connection works fine because all html/php files open properly. Something like this has happened to me first time. I hate to do that but perhaps I could try to remove and the add the whole database again then restore test data from my PC. I would add of course some extra work, but that would be the last thing to try if I cannot see any other solution. This same project locally works without problem on XAMPP.
Arthur
Maybe you can delete the connection in production, close the browser, open the browser and create the connection again in production.
Or check your table name.
www.LiviApps.com (Scriptcase Specialist - English language)
www.OwenSolution.com (Scriptcase Specialist - Indonesian language)
I had to remove every singles piece of code from the server as well as the database and then re-upload it again. Now it works but it is scary situation. I was lucky this was only a testing version of the project. What would I do with production setup ? Ughhhhh! 