I can't connect to Mysql in my own server

ruy

Member
Licensed User
Longtime User
Hi, I am new to Basic4Droid and while experimenting with MySql example I find that it works fine as is. But if I try to replicate the php web service in my server and using my database,

Field Type Comment
name varchar(25) NOT NULL
id varchar(2) NOT NULL
population int(11) NOT NULL


it simply refuses to work. When it reads the first table (Names & Id's) it sends the following message:

"An error has occurredin sub:main_hc_responsesuccess (B4A line:63)
countries = parser.NextArray 'returns a list with maps
java.lang.RuntimeException: JSON Array expected.
continue?"


It is an exact replica of the files in the tutorial except for quotes missing in the php listing for the MySql server credentials (which I changed for the ones in my server/database) and the address of the php file.

The log file shows identical structures for the one that runs with the original http://www.b4x.com/android/countries.php and the one that runs at my server http://www.ruydiaz0.net/countries.php, though, it refuses to continue.

What am I doing wrong? :sign0085:

Ruy
 
Last edited:
Top