So, pjlumby has uncovered what we believe is a bug in the data service wizard. It turns out that when you use the auto generated service calls that change the database such as create<blah>(item), update<blah>(item) and possibly delete<blah>item(itemID) that the data service does not 'commit' the change so nothing happens to your database. No call to the PHP code, no network traffic.
However, there is a 'commit()' function in the _Super_<blah>.as file in your services directory. If you put a break point there, you will see that the method is never called. Hmmmm.
If you add the 'commit()' statement at the end of all the methods (before the return) that modify the database (see first paragraph)[methods are located in _Super_<blah>.as in your services directory], well, things start working the way they are suppose to.
Hope this helps those who have this bug. I've wasted three days on this.
Big thankyou to pjlumby.
Thanks A LOT!!! this issue was driving me nuts, Re-cheling every thing for the past week, you really help me out
Glad it helped! I'm not a big IDE fan and this is one of the reasons. The IDE developers think they have all their bits covered and all a user has to do is follow their wizards and examples, unfortunately, when they have some bad bits, the IDE hides the sources necessary to really see what is going on. I really want to make flashbuilder work but it's stuff like this that makes me remember why I like all the sources, VIM and Make
Thanks so much for your answer and solution.
I had the same problem/bug and couldn't resolve it till now.
Adding the commit() function solved it.
Thanks again for your time!!!
Thank you very much paula.... It was really helpful.... Thank you again..... You saved me before getting frustrated for days......
Now I have the "commit();" code before the return of each function in the "Super...Service.as" file but I I still get this error and my php-mysql data connection settings are there:
Channel disconnected before an acknowledgement was received
If you have any suggestions of what can this be I would truly appreciate your help. Thank you.
You may want to monitor your network traffic to make sure that you are talking to your server. The error you reported would indicate that you are attempting network connection to your server but your server is not responding. I would dig deeper and look at the network monitor tool to be sure you are getting traffic out of your flash.
It has been a long time since I played with the php wizard. I've moved on to my own python services and use standard http cgi api calls with json return objects.
I downloaded a program CHARLES to monitor traffic and find out what’s going on. Could you elaborate a little bit about Python Service. Sounds interesting enough J
flashbuilder actually has a network monitor (one of the tabs in the bottom window by whre the problems an data service tags are).
I use python mod_wsgi. There is a bit of setup but once configures life gets real easy. I can create a new interface in minutes and dashboards that include the flash code and the service side code in under an hour. There is learning curve and a set up curve.
i dont understand, should I just add "commit();" before return ? i have the same problem, except mine doesnt work even when testing