Works fine on local host, broken on web

[starbuck]

I have an application that works fine on the local host during "Live Preview" but won't work right when posted to the web. We're using Alpha's Firm Support Hosting Professional.

When trying to enter a new record through a gridlinker component (parent/child table relationships), the database won't allow new records to be entered unless the component property is set to "allow new record entry only".

Further, when the update property is enabled, the program allows existing records in the table to be updated but still will not accept new record entries.

I'm confused because all of this worked fine a couple of weeks ago and when we revisted and did some page formatting changes, it stopped working. We downloaded the latest build of Alpha 5, seems to work ok on the local host, but will not work at all when we upload to the web server. Now we have reverted to the original working version, but it still will not work on the web!

Any help appreciated! Example URL is at http://immi.alpha5host.com/promocall4.a5w.

[Rayr]

Re: Works fine on local host, broken on web

I have an application that works fine on the local host during "Live Preview" but won't work right when posted to the web. We're using Alpha's Firm Support Hosting Professional.

When trying to enter a new record through a gridlinker component (parent/child table relationships), the database won't allow new records to be entered unless the component property is set to "allow new record entry only".

Further, when the update property is enabled, the program allows existing records in the table to be updated but still will not accept new record entries.

I'm confused because all of this worked fine a couple of weeks ago and when we revisted and did some page formatting changes, it stopped working. We downloaded the latest build of Alpha 5, seems to work ok on the local host, but will not work at all when we upload to the web server. Now we have reverted to the original working version, but it still will not work on the web!

Any help appreciated! Example URL is at http://immi.alpha5host.com/promocall4.a5w.

Hi,
I triad the link to test the site and when I click most of your buttons on station status it gives me an err that it can't find the Phone.dbf, Liners.dbf, Sales.dbf, maybe when you republished your site something when wrong.

Mabe try bublishing your site to see what happens, someone else had a prob when they changed their site and published it; it would not show the change, see link below-
http://msgboard.alphasoftware.com/al...258#post396258

I don't know if this will fix your trouble but it's worth a shot, maybe Steve will chime in and solve you'r trouble.

[rogersville]

Re: Works fine on local host, broken on web

Hi,
I triad the link to test the site and when I click most of your buttons on station status it gives me an err that it can't find the Phone.dbf, Liners.dbf, Sales.dbf, maybe when you republished your site something when wrong.

Mabe try bublishing your site to see what happens, someone else had a prob when they changed their site and published it; it would not show the change, see link below-
http://msgboard.alphasoftware.com/al...258#post396258

I don't know if this will fix your trouble but it's worth a shot, maybe Steve will chime in and solve you'r trouble.

[starbuck]

Re: Works fine on local host, broken on web

Hello Ray,

Please try the URL again. We tried posting the files up using Filezilla to see if the Alpha publisher was the problem, and really got into a mess.

We have corrected that problem, so all the child tables work now.

http://immi.alpha5host.com/promocall4.a5w

We have further pinpointed the original problem, which seems to have just started in the last while. When you try to add a new record, it will only work if you have edited the record before it without submitting. For example, if you try to add a new record in the gridlinker component called "Call Record" it will not add the record unless you also type in the record above it, then when you submit, it will add the record. Really weird.

Anyway, it all works fine on the local host, just when you post to the web, we see the strange behaviour above. Any suggestions or help greatly appreciated.

Lisa

[Rich Hartnett]

Re: Works fine on local host, broken on web

Lisa the site opened up for me. Slowly, but it did open. I tried sending in a test, but I don't know if it took, because it disappeared after I clicked on the submit button.

(I like your icons for the advanced buttons. Pretty cool.)

[starbuck]

Re: Works fine on local host, broken on web

Thanks Rich. Are you saying you tried to add a Call Record and it didn't show up after the submit? That is exactly the behaviour we are seeing.

We think the application is slow also, though we are hosting it on Firm Support's "high speed" server. Do you have any web apps that are this complex that are faster, and if so, are you hosting yourself or elsewhere?

Thanks,
Lisa

[Dan Blank]

Re: Works fine on local host, broken on web

I think the main reason your site loads so slow is due to all of the various web components you have on the first page. Your session ID also shows up in the URL.

I would try to break some of the web components out and use links to show that data with a pop up window.

I would also do the same thing for adding a new entry. The user presses a button, a dialog web page opens up, they fill it out, the web page closes, and the redirect is to the main web page.

Have Fun,

[Rayr]

Re: Works fine on local host, broken on web

Hello Ray,

Please try the URL again. We tried posting the files up using Filezilla to see if the Alpha publisher was the problem, and really got into a mess.

We have corrected that problem, so all the child tables work now.

http://immi.alpha5host.com/promocall4.a5w

We have further pinpointed the original problem, which seems to have just started in the last while. When you try to add a new record, it will only work if you have edited the record before it without submitting. For example, if you try to add a new record in the gridlinker component called "Call Record" it will not add the record unless you also type in the record above it, then when you submit, it will add the record. Really weird.

Anyway, it all works fine on the local host, just when you post to the web, we see the strange behaviour above. Any suggestions or help greatly appreciated.

Lisa

It All works now.

[Rich Hartnett]

Re: Works fine on local host, broken on web

Yes the Call Record is what I was talking about. I entered today's date and time, and under "call notes" I entered "Test - Rich Hartnett" and submitted. But as you said, it doesn't look like it was saved to the table.

As for the speed, what Dan said above it exactly true. Having more than two components on a single page seems to really slow down the performance. I had an application that originally had three grid linked components on one page and it was slow as molasses. I switched to using the tabbed gridlinker function, and now I have the same application with EIGHT components, but no more than the parent and one child grid on each page, and it opens 2-3 times faster than when I had the three components on one page.

I know it's nice to have everything showing on one page, but you really take a hit on speed if you do.

[Rayr]

Re: Works fine on local host, broken on web

Yes the Call Record is what I was talking about. I entered today's date and time, and under "call notes" I entered "Test - Rich Hartnett" and submitted. But as you said, it doesn't look like it was saved to the table.

As for the speed, what Dan said above it exactly true. Having more than two components on a single page seems to really slow down the performance. I had an application that originally had three grid linked components on one page and it was slow as molasses. I switched to using the tabbed gridlinker function, and now I have the same application with EIGHT components, but no more than the parent and one child grid on each page, and it opens 2-3 times faster than when I had the three components on one page.

I know it's nice to have everything showing on one page, but you really take a hit on speed if you do.

Hi Rich,
Maybe with v8 and the so called AJAX support it will be faster, I dont know.
http://msgboard.alphasoftware.com/al...highlight=AJAX