I've been mucking around with Flash Builder (beta 2) and trying to get some PHP services hooked up. It's dead simple through FB assuming no hiccups. But I've been hiccupping for days now.
I'm running the latest WAMP install with only one modification mentioned below (fresh install) on WinXPSP2.
TO sum up, I have a very simple DB table set up, primary key + 4 other fields. I have a sample PHP service set up to talk communicate with MySQL and receive the table row data. However, whether I try to connect through FB, or just running a test.php which utilises the same PHP service, I get these errors from MySQL:
**Warning: mysqli_connect() [function.mysqli-connect]: MySQL server has gone away in C:\wamp\www\PHPService\services\EmployeeService.php on line 33 Warning: mysqli_connect() [function.mysqli-connect]: Error while reading greeting packet. PID=1024 in C:\wamp\www\PHPService\services\EmployeeService.php on line 33 Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2006): MySQL server has gone away in C:\wamp\www\PHPService\services\EmployeeService.php on line 33 Fatal error: Maximum execution time of 60 seconds exceeded in C:\wamp\www\PHPService\services\EmployeeService.php on line 27**
As suggested on an Adobe FB forum, I tried increasing my default 'max_execution_time = 30 ;' in php.ini upto 120, 240 and then 360 in that order. No cigar.
This url: http://www.codefinger.co.nz/_etc/mySQLError.zip contains;
- MySQL Database table I'm using
- EmployeeService.php as seen i the above error
- test.php, in the same folder as EmployeeService.php
Any help appreciated, I'm no MySQL or PHP wiz, everything provided has been taken from online example materials from Adobe, all I've done is put in my own DB details and an altered version of 'EmployeeService.php' to reflect the data I'm trying to get from MySQL.
If you're keen to help and I haven't included some vital logs or whatnot, just holler and maybe let me know where I can find what you need to troubleshoot.
Cheers, - danjah
 I should note that in 'EmployeeService.php' you'll see I commented out the username/pswd settings, just to test if that was a problem, I have tried it with the correct creds though (the commented ones). I also turned my firewall off temporarily while testing, shrug.