This topic is locked

Uploaded site won't load

11/17/2016 5:11:50 PM
PHPRunner General questions
A
alohasara author

I've been searching Google and forum for 2 days and I can't seem to figure out what's going on. Please help.
When I run my site on my local machine through PHPRunner, everything works great. I copied my database over to a server and FTP'd the site to the same server, updated the DB pointers and configured PHP (edited the php.ini - running on Windows Server 2012 R2) and the site won't load. I'm getting a 500 - Internal Server Error - There is a problem with the resources you are looking for, and it cannot be displayed.
I put the phpinfo.php into the same directory with the site and it loads up just fine, so PHP seems to be working. The page is found as I can see it in the url, but I can't get it to load. Any help is much appreciated.
Thank you.

-Sara

Admin 11/17/2016

As a first step turn on detailed error messages in IIS settings and this would tell you what exactly is the error there. This article explains how to achieve this:

http://stackoverflow.com/questions/2640526/detailed-500-error-message-asp-iis-7-5

A
alohasara author 11/17/2016



As a first step turn on detailed error messages in IIS settings and this would tell you what exactly is the error there. This article explains how to achieve this:

http://stackoverflow.com/questions/2640526/detailed-500-error-message-asp-iis-7-5


Thank you. That helped me get past one problem (open_basedir was misconfigured), but now I just get a blank page and the error detail show nothing. Please advise.
Thanks,

Sara

lefty 11/18/2016



Thank you. That helped me get past one problem (open_basedir was misconfigured), but now I just get a blank page and the error detail show nothing. Please advise.
Thanks,

Sara



If it does not show any error message and just a blank white page with correct url in address bar , one of your table events is probably misconfigured or has an error. This happens to me occassionally. When I see open_basedir that is a clue.

Are you uploading images/files anywhere if so make sure since you changed from local to server that the paths are correct and are pointing to the server now or any other code that was pointing to local server. If you have no login , try typing out url to some other page to see if it comes up or redirects back to home page. Also make sure the folders you use to upload files/images have read/write permissions and the same for templates_c directory.

Another option is to comment out temporarily the suspected table event and see if the home page comes up.
Also try different browsers , IE sometimes shows me just white page even with ( settings http freindly error messages turned off ) if I have an event that has a syntax error in it. Use chrome or firefox and open developer tools to see if you can find error there.

Admin 11/18/2016

I would suggest to make sure that database connection settings are correct. If PHPRunner app is able to connect to the database you should be able to see something.

A
alohasara author 11/18/2016



I would suggest to make sure that database connection settings are correct. If PHPRunner app is able to connect to the database you should be able to see something.


Thank you. I can get to the database when I load the site from my computer (connection string has the IP Address as the server for the name). But, maybe I can't get to it when I load it from the server. Do I need to configure ODBC (database is MySQL running on the same server)?

Admin 11/18/2016

No, ODBC is not required but MySQL can be configured the way that remote access and local access works different i.e. while connecting locally you need to use "localhost" as server address instead of "yourwebsite.com".
You need to talk to your web hosting company in this regard and ask them what connection settings you need to use while connecting to MySQL from PHP script.

A
alohasara author 11/18/2016



No, ODBC is not required but MySQL can be configured the way that remote access and local access works different i.e. while connecting locally you need to use "localhost" as server address instead of "yourwebsite.com".
You need to talk to your web hosting company in this regard and ask them what connection settings you need to use while connecting to MySQL from PHP script.


There is no web hosting company. The server is running on my own network and like I said, it's a Windows 2012 R2 Server running MySQL on the same host. I can connect to the database fine when I run the application from my machine, but when I try to run it from the server it's blank. If the connector were the issue, would I be able to see it from my machine? I have the account setup in MySQL as having full access from anywhere (%). If the database connection isn't working, shouldn't I still at least get the header \ footer? I get nothing, so it seems the website just doesn't load at all (not just can't see the data).

Admin 11/18/2016

You still need to make sure that you can connect to your MySQL from PHP script using the same credentials. Some MySQL servers can be configured the way that remote and local access require specify different server address i.e. localhost vs server name.
You can also check PHP error log or try to enable detailed error messages in php.ini.
If you have a valid support contract feel free contact support directly. It looks like you need someone to logon to your server and see what exactly is happening there.

lefty 11/19/2016



You still need to make sure that you can connect to your MySQL from PHP script using the same credentials. Some MySQL servers can be configured the way that remote and local access require specify different server address i.e. localhost vs server name.
You can also check PHP error log or try to enable detailed error messages in php.ini.
If you have a valid support contract feel free contact support directly. It looks like you need someone to logon to your server and see what exactly is happening there.



I'd like to know if this was resolved , as in the first question , she stated that the url is in the address bar ,That tells me the application is running , ( just project configuration is incorrect not database) See my statement above i have gone through this many times. so I don't know how it can be the connection if the url shows up ( only permissions would white page it or project errors) . The only other thing you can try is assigning a new user on server with permissions on a different machine and see if that works.

or once again you have errors in your project that were set correctly to local but not necessarily to remote server. Other problems arise such as ports . If you are on the same server why don't you use ipaddress on another machine.

The next step is to narrow down your project or create a one table project and see if it connects. Are you using Enterprise Edition / Regular PHP? Also need your phprunner version and build would help a little.

HJB 11/19/2016

Look, among tons of other goodies of world's best RAD tool, made by Xlinesoft, is the CONNECTION SCRIPT.

This is truly a LIFE-SAVER in regard to troubleshooting like yours, arising from TWO different locations,

1st your localhost developing arena and then the headache causing on 2nd, your web server.

Better to run the following now and in future. Copy the "phprunner.php" connection script into the web server

directory and connect world's best RAD tool named PHPR to your web server via this very connection script then.

Doing the code generation this way ensures that indeed the generated code is basing on the web server configuration

rather than your localhost one. Next BIG FORTUNE is that on any later change (hoping that you are making as well

very good use of world's best RAD tool built-in FTP to incremental file uploads later once changes need to be made),

you are just loading the project file, make your changes and FTP the "only changed file" by simple mouse-click then.

In other simple terms, once you are able to connect to your web server via connection script, it ensures that any

generated code is basing on of what PHPR is finding in regard to configuration. It save you not only a lot of time,

but avoids troubleshooting you have by generating the code for a local configuration which seems to differ of what

you have on your web server, just my 2 cents on the issue. HTH

A
alohasara author 11/25/2016



Look, among tons of other goodies of world's best RAD tool, made by Xlinesoft, is the CONNECTION SCRIPT.

This is truly a LIFE-SAVER in regard to troubleshooting like yours, arising from TWO different locations,

1st your localhost developing arena and then the headache causing on 2nd, your web server.

Better to run the following now and in future. Copy the "phprunner.php" connection script into the web server

directory and connect world's best RAD tool named PHPR to your web server via this very connection script then.

Doing the code generation this way ensures that indeed the generated code is basing on the web server configuration

rather than your localhost one. Next BIG FORTUNE is that on any later change (hoping that you are making as well

very good use of world's best RAD tool built-in FTP to incremental file uploads later once changes need to be made),

you are just loading the project file, make your changes and FTP the "only changed file" by simple mouse-click then.

In other simple terms, once you are able to connect to your web server via connection script, it ensures that any

generated code is basing on of what PHPR is finding in regard to configuration. It save you not only a lot of time,

but avoids troubleshooting you have by generating the code for a local configuration which seems to differ of what

you have on your web server, just my 2 cents on the issue. HTH


Thanks everybody for your ideas and suggestions. I finally got this to work. From what I could tell, it seemed to not like the version of PHP I was using. When I downgraded it to use 5.6 it started working with no other changes.
As suggested, I had created a simple one page design and uploaded that and it didn't work either. I also took my site and uploaded it to the Demo Site provided and it did work there, so I figured it had something to do with my machine. I'm using Windows Server 2012 R2 Standard with IIS and PHP 7 was the one that wouldn't work (hopefully this helps somebody else in the future).
Thanks again.

-Sara

HJB 11/25/2016

Yours "...and PHP 7 was the one that wouldn't work (hopefully this helps somebody else in the future)" refers ...

FYI only, immdly the November 2015 build, supporting PHP 7.0, came out, things ran successfully on the web server.

Testing was done rather than to put a blame on Zuckerberg's HipHop technology, but to see the up to 70% faster

issue with own eyes. The PHPR tank is robust on PHP 7.0, no doubt about it, yet the right configuration matters.

Just my 2 cents on the issue ...

lefty 11/25/2016



Yours "...and PHP 7 was the one that wouldn't work (hopefully this helps somebody else in the future)" refers ...

FYI only, immdly the November 2015 build, supporting PHP 7.0, came out, things ran successfully on the web server.

Testing was done rather than to put a blame on Zuckerberg's HipHop technology, but to see the up to 70% faster

issue with own eyes. The PHPR tank is robust on PHP 7.0, no doubt about it, yet the right configuration matters.

Just my 2 cents on the issue ...


I am still on php 5.2.17 as I tried Php 5.3.15 on PHP runner 8.0 and all hell broke loose . I use the PHPrunnner's suggested server inspirunner.com for hosting and I still got the White screen just like above when I adjusted to 5.3.15. Haven't tried with 9.6 but will have to now that I see this. ( for future )as it is not offered yet on insiprunner.com ( plesk control panel ). I thought seeing posts above it wasn't the server it is compatability . As soon as the url came up and white screened it had to be either an event not compatibale with your program ie ... 7.0 or a syntax error with php #below that, either the earlier or later. I think 9.6 is supposed to work with php 7 as it shows it in the proudcut system requirements but you might have to make some adjustments in as I said before , your event code and I guess according to walkfly some compatability issues with server . I am still working on programs in PHPrunner 8.0 and just started some new projects with 9.6 so I am glad I saw this post. ... regards and good coding. Just a note insiprunner.com is a really good host to run on as it is tied in with the API and upload is simple. Also has all the server settings correct for asp/php runner . I know you have your own server but for anyone else out there with issues, it runs alot faster then most of the other hosting companies I have tried. No need to keep asking support to change settings as they already have it setup for this great API.

HJB 11/26/2016

John, many thanks for your input. Indeed, the hosting market is in full swing

to new income orbits, say, seeing web hosters on the web to offer 1 year free

hosting for PHP 7.0 including Maria DB (that's what ORACLE won't like to see

as commercially used MySQL and subsequent license fees are going to be lost),

the only logical way out to run things like that is to somehow emulate of what

is happening in the gastro scene (restaurants, bistros etc pp) where apps are

sold against 1% of monthly income as the fee rather than a fixed one. That is

referring to the commercially oriented market, but when you are applying the

PHPR hammer in full to bring a sponsored "grocery-list" to the USA market for

the private households, of course including COUPON management, I would say this

could be a something where a PHPR generated heat map of best prices in town may

finally turn out to get INSIPRUNNER to the stock exchange as well.
P.S. I tasted various ready-made M-POS (mobile POS systems) in the past, none

of them could meet with my simple requirements at all, so, second hammer after

1st introductory one to ramp up at the stock exchange could be an INSPIRUNNER

POS as indeed every thing one needs to properly perform in record time is aboard.
In my place, the monthly access fee for restaurant owners starts at 49 Euros on

POS products, I won't be even willing to get in touch with for my whole life-time.
Finally I wrote to USA service company months ago (they managed to run real-time

registration channel with the governmental company registration office and as well

provide share hold percentage management on the web plus tons more services around)

in regard to their start-up offer of $99 as company registration fees, thankfully

getting NO reply by them at all as it only came to light by now that trumped tax

effects in the USA are said to lower rates into the 15% region (as usual, my mistake

is always to run "early bird" like biz missions), so, things in mind had now been

postponed to happen somewhere after 20th January 2017.