Remote database connection drops out immediately

Anything beyond the basics in using the LiveCode language. Share your handlers, functions and magic here.

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
nicoloose
Posts: 99
Joined: Mon Sep 16, 2013 3:35 pm

Remote database connection drops out immediately

Post by nicoloose » Wed Feb 03, 2016 10:55 am

Good morning,

I host my mysql databases on GoDaddy and my application (that I have been using for years previously on a local network) connects as expected when I log in but as soon as it tries to retrieve data, I get an error that "Mysql has gone away". I am told that I should change values on the PhP installation but since this is a godaddy hosted account, I can't really tell them to make such a change.

Can anyone start me in the right direction.
Regards
Nic

nicoloose
Posts: 99
Joined: Mon Sep 16, 2013 3:35 pm

Re: Remote database connection drops out immediately

Post by nicoloose » Wed Feb 03, 2016 1:00 pm

Solution:

Contant kDB_TABLENAME had a capital letter on the table name. This was not affecting my local test server for some reason but was being rejected by hosted server.

Klaus
Posts: 14208
Joined: Sat Apr 08, 2006 8:41 am
Contact:

Re: Remote database connection drops out immediately

Post by Klaus » Wed Feb 03, 2016 3:15 pm

That is one of the reasons why I ALWAYS use lower case for tables, database fields, filenames and whatever! 8)
Especially since iOS and Android are case sensitive file systems!

Post Reply