Flex production server problem

2019-12-09 Thread dw1970
After developed a Flex application, I made the flex 4 production release to a production server. In the development environment, the application has been working fine under flash builder 4.6 and WAMP. After FTP the release build to production server (running MYSQL5, PHP5 and Apache2) and execute th

Re: Flex production server problem

2019-12-11 Thread dw1970
Have used Charles 4.5.5 as advised. Recorded "Failed to parse data (com.xk72.amf.AMFException: Unsupported AMF3 packet type 60 at 1)" as in this image also, recorded " *Warning*: is_readable(): open_basedir rest

Re: Flex production server problem

2019-12-11 Thread dw1970
Hi, Javier, Good point, I have made changes in the amf_config.ini so that the webroot is now webroot =/var/www/vhosts/bbrchk.com/httpdocs After the change and recorded it with Charles 4.5.5, I got a different warning (seems like closer to fixing) mysqli_connect(): (HY000/1045): Access denied for

Re: Flex production server problem

2019-12-12 Thread dw1970
Hi, Javier, Let me give a briefly describe what I want to achieve. I developed a simple app called testprodserver using Flex builder 4.6, WAMP. The purpose of developing this is to make sure the production server is setup probably with ZendFramework, a DB called bookclub with only one table called

Re: Flex production server problem

2019-12-12 Thread dw1970
Instead of using localhost, use the exact IP address in LevelService.php, everything works now. -- Sent from: http://apache-flex-users.246.n4.nabble.com/

MySQL view definer

2020-01-13 Thread dw1970
Have a simple flex app, say FlexApp to retrieve two tables and a view from MySQL DB in webhosting service provider, say A and B. Currently, FlexApp runs in service provider A with no problem at all. The FlexApp can be seen in http://www.bbrchk.com/testdb/testdb.html Because we need to move to a new

Re: MySQL view definer

2020-01-16 Thread dw1970
Have checked out php error log at server side (error logging has been enabled) but it did not generate any error. (I am sure the error logging has been enabled because I intentionally edit the $databasename wrongly, I can trigger the php error log stating DB access denied) So, even I put back ever

Re: MySQL view definer

2020-01-19 Thread dw1970
hi, The two Service Providers (SPA and SPB) are using different versions of PHP and MySQL, the details is as follow. One point to note is that the flex app is called testdb which will retrieve data from a DB called bookclub which has 2 tables called staff and position and 2 views called staffviewp

Re: MySQL view definer

2020-01-23 Thread dw1970
Have followed Javier's hints to edit view of staffviewposition by applying security to the invoker instead of the definer. But still unable to solve the problem ie unable to fetch view data. see http://www.bbrclubhk.com/testdb/testdb.html as compared to the one in another web hosting service provid

Re: MySQL view definer

2020-02-08 Thread dw1970
To simulate the problem in an environment that I can read the DB query log, I joined a different plan in the same web hosting service provider. This plan is called Managed VPS (let's called it planB as opposed to the shared web hosting let's call say it planA). Th planA is having the programA that

How to return the primary key sequence number after MySQL insert

2021-02-12 Thread dw1970
I am using flex builder 4 to write actionscript to insert a row to a table. The table has a primary key, say iddCourse with AUTO_INCREMENT. In FB4, I used to have dataservice PHP to insert row and it will return the sequence number of the newly created row, ie the generated number stored in iddCour