Page 1 of 1

Remote database connection drops out immediately

Posted: Wed Feb 03, 2016 10:55 am
by nicoloose
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

Re: Remote database connection drops out immediately

Posted: Wed Feb 03, 2016 1:00 pm
by nicoloose
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.

Re: Remote database connection drops out immediately

Posted: Wed Feb 03, 2016 3:15 pm
by Klaus
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!