2. ASPRunnerPro General questions
  3. Ghost in the Server??
This topic is locked

Ghost in the Server??

 		8/21/2003 10:32:53 PM
ASPRunnerPro General questions
M
 MaxLm author

OK - Has this happened to you?
This happened to me a few times already.
I built a new MDB with a username table and another table using Access. After building, built all the permissions on the db on the server.
OK - I run it and it worked perfectly. I Logged in and then did some add/edit and list the contents of the mdb on my browser.
Later, I rebuilt my ASP, added a few fields to the tables. REbuilt ASP and put again the db permission back.
NOw, why is it now givin me a blank page? It sitll goes automaticlaly to the Log-in asp but its a blank page now. Saying there is a problem with the page I am tryhing to reach and it cannot be displaced - HTTP 500 - Internal Server Error.
There is nothing I did but rebuilt the asp page. This isnot only the first time. This is the 3rd time and I am getting so frustrated. I need to make the listings available tomorrow to the east and west coast folks, but I am having this problems.
Server is on the same segment as my LapTop just the next room.
Any help please ??
Sergey Kornilov admin 8/22/2003

Hi,
here is what I can recommend if you experience this kind of behaviour

  1. Before copying new database to the server make sure that old database is not accessed by any applications, ASP pages etc.
  2. After you put new database to the server restart IIS.
  3. If restart doesn't help - reboot server.
    Sergey Kornilov

    Support team
M
 		MaxLm author 8/22/2003

Still Cant... Restarted IIS and still cant.
I created a new DB and run new codes from ASPrunner. Now, I am getting broken link being redirected by _default.asp to the login.asp.
Max
Sergey Kornilov admin 8/22/2003

Max,
there is one more thing that you can try:
in the begining of page that fails find the following line of code:

On Error Resume Next


and change it to:

' On Error Resume Next


This should display ASP error messages on the page if any.
Sergey Kornilov

Support team
M
 		MaxLm author 8/23/2003

Did that -

  1. Default.asp - this riderects it to Login.asp

    <meta http-equiv=refresh content="0;url=HDSL_login.asp">
  2. HDSL_login.asp has one instance of "On Error Resume Next"

    Commented it 'On Error Resume Next
    It does not display any error or anything on the browser. Dont know if it will display it on the browser or no error at all.
    I still get the blank page.
    I checked the includes files and there was nothing there.
    Problem is, it was trying to display the html login page, but for some reason it is having some difficulty.
    Any ideas ?? I am running XP2003, maybe this is inherent to XP2003. Has this happened on Windows 2000 Server? Yes, I did the same yesterday using the 2000 Server box, and it just redirects me to from default.asp to login.asp.
    Let me know what else you think there is to do.

    thanks,
M
 		MaxLm author 8/24/2003

Sergey-

Seems there is some problems the way ASPrunner generates the ASP codes. I turned off Friendly HTTP error messages on my browser to actually see what seems to be the problem and it reported the following:
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/include/HDSL_aspfunctions.asp, line 624
if "LEC Name" = strName then strSQL = "SELECT [ID], [LECname]

-----------------------------------------------------------------------------^
This was created by ASPrunner. What happened was the function

Function BuildSelectControl, it truncated all the lines from the "FROM" .......... to End If.
I edited all of them and now it works...
You Need to fix the code generator.
Max