testarosa
Posts: 15
Joined: Tue Jan 18, 2011 6:50 pm

trouble with HttpPostCollectData

I set up a custom dialog to send information to an sql server via php. The php form is posting data to the database, however, the server is receiving nothing from my app. Nada, nothing. Attached is the php file (minus specific db info)and the dialog arguments. This seems to be so straight forward and easy, I used this: http://www.advancedinstaller.com/user-g ... -info.html

Also, I'm not ever getting the "Please wait" http post request message that "should" be spawning.

Is there something I'm missing on the arguments?

Thanks, as always for your help and brilliance.

-C
Attachments
dialog.jpg
dialog.jpg (253.82 KiB) Viewed 6077 times
collect_db_example.txt
(823 Bytes) Downloaded 301 times
testarosa
Posts: 15
Joined: Tue Jan 18, 2011 6:50 pm

Re: trouble with HttpPostCollectData

additionally, you can test the php / database here: http://www.ltcceo.com/ltcceo/test.html

It's the installer dialog commands where something is missing so it's not even getting to the database.

-C
Bogdan
Posts: 2796
Joined: Tue Jul 07, 2009 7:34 am
Contact: Website

Re: trouble with HttpPostCollectData

Hi,

From what I can see your attached PHP sample does not have any values set for SQL connection parameters. Does the script you are using has these parameters set? The rest of the code seems correct.

Also, are the properties (FIRST_NAME, LAST_NAME, EMAIL) are correctly set in the aip too, to the edit controls? Can you please send us the aip to support at advancedinstaller dot com?

Regards,
Bogdan
Bogdan Mitrache - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
testarosa
Posts: 15
Joined: Tue Jan 18, 2011 6:50 pm

Re: trouble with HttpPostCollectData

Hi Bogdan,

I got it to connect, well not really. In the user guide, it says add "IAgree..." on DoAction, but it doesn't say what to do if you're not doing a privacy agreement. I changed condition to 1. Now I get the the "please wait" spawn, it gets to the server and I get an error 403 every single time. I pulled off my spawn dialog, just had only HttpPostUrl, HTTPPostCollectData and DoAction in published events. Still error 403. I can't get past error 403. There's something else, is it the properties of my fields? I can't find it.

I sent the currrent aip file. please see subject "SEE THIS AIP" :-)

Thanks!
-C
Bogdan
Posts: 2796
Joined: Tue Jul 07, 2009 7:34 am
Contact: Website

Re: trouble with HttpPostCollectData

Hi Cori,

The error 403 Forbidden is usually given if if the your server is not correctly configured. Here is a discussion on this subject.
You can find more suggestions on how to solve this error on a simple search on Google.

Regards,
Bogdan
Bogdan Mitrache - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
testarosa
Posts: 15
Joined: Tue Jan 18, 2011 6:50 pm

Re: trouble with HttpPostCollectData

I figured that out late last night. The host I have the database on has to white list the php file. I'm sorry I didn't reply to save you the trouble.

Thanks again!

-C
testarosa
Posts: 15
Joined: Tue Jan 18, 2011 6:50 pm

Re: trouble with HttpPostCollectData

Bogdan - the database is not populating with FIRST_NAME and LAST_NAME but not EMAIL - can you quick check my aip and see if it's anything in my EMAIL properties or dialog, I don't think it is but I can't be sure?

I got to release this thing now.

Thank you!

-C
Bogdan
Posts: 2796
Joined: Tue Jul 07, 2009 7:34 am
Contact: Website

Re: trouble with HttpPostCollectData

Hi Cori,

The email field has the same settings as the other two fields, so it should pass its value correctly to the PHP script.

Can you please debug the script and see if the value of the property gets in the variable "email" from your php script as a result of the POST operation?

Regards,
Bogdan
Bogdan Mitrache - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
testarosa
Posts: 15
Joined: Tue Jan 18, 2011 6:50 pm

Re: trouble with HttpPostCollectData

Bogdan,

Follow up on this....

I never could get the 3rd field (EMAIL) to populate in the database. I combined First Name and Last Name in the first field and moved EMAIL to the Last Name field. However, when I removed EMAIL from the HttpPostCollectData control, then the 2nd field failed to populate. It's dropping the last in the sequence in the argument of the control. So what I ended up doing is Argument FIRST_NAME;LAST_NAME;EMAIL;EMAIL - although I did NOT create a second EMAIL field, I still only have the three, I added a second EMAIL to the control argument and wah-lah! The FIRST_NAME;LAST_NAME;EMAIL are posting to the database. I don't know why and I don't care, because it's working this way. Just wanted to let you know. I'm not sure if this is something in Adv Installer.

It was the old jump up and down, clap your hands three times and create a fake field name trick.

-C

Return to “Common Problems”