I’m currently running the demo version and I’ve tried publishing some apps. Data are in an sqlite(3) database and the app works in my local script case development environment.
I tried publishing a first version ,and struggled to get the connection in my pro server to work, but eventually it did work (only when accessing my local server through my dyndns : ie 192.168.1xx then menu item selection didn’t work (error accessing the database : table xyz not found view SQL -sql underlined but no working link) but ???.webhop.net does work.
With a second version (more records but similar database) I haven’t managed to reproduce what I did to get the first one to work. When calling 192.168.1xx/MyApp and calling the relevant menu item: table xyz not found…, when calling ???.webhop.net/MyApp and calling the relevant menu item, it’s a column that isn’t found (so I assume the table is…)
Any idea on what is wrong ?
Thanks for your help…
When connecting again after 1 to 2 hrs, it works…and I didn’t change anything…
Is this a cache issue of some kind, the database not being found after publishing (because of “wrong” address) and this failure being kept in memory for quite some time ?