Help!! Trouble after moving site to reseller account (Sub-Directory)

[theMachien]

Ok I managed a site. www.jumpalotcda.com and the owner sold it. the own hosted at Readyhosting.com as an individual account. I had full control over the account and so with the new owners I resold hosting to my account at www.bigfootdesigns.com also w/ readyhosting.com.

So after creating a new sub-directory../ JAL2 I moved all the files over site did not work. Went and change the path for the database and everyting came up fine. I tested the site and all was working fine. Then 2 days ago the client called saying that she cound not access the admin page or the news letter sign up wa not working. So I called ReadyHosting and they claim that it is in my code and they do not TS code. OK so I look further into it and here is what is happening. For example if you goto this page http://www.jumpalotcda.com/news_signup_letter.asp and fillout the form and submit it it should do one of two things. Either re-direct to a thank you page or tell you that your email is already in the DB. But here is what happening. It is re-directing to http://www.jumpalotcda.com/JAL2/news_signup_letter.asp. Right back onto itself. I can't for the life of me figure out what is happening...where is it getting the /news_signup_letter.asp it is no where in the code. I am think that it is an issue with the subdirectory. This also happens on the admin-login in page it is like it is not even running the script to proccess it to the DB.

This is all standard DW CS4 code that it writes.

Any help would be great

thanks

B

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/conn_JAL.asp" -->
Dim MM_editAction
MM_editAction = CStr(Request.ServerVariables("URL"))
If (Request.QueryString <> "") Then
  MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If

' boolean to abort record edit
Dim MM_abortEdit
MM_abortEdit = false
%>
<%
' *** Redirect if username exists
MM_flag = "MM_insert"
If (CStr(Request(MM_flag)) <> "") Then
  Dim MM_rsKey
  Dim MM_rsKey_cmd
  
  MM_dupKeyRedirect = "news_signed_up.htm"
  MM_dupKeyUsernameValue = CStr(Request.Form("email1"))
  Set MM_rsKey_cmd = Server.CreateObject ("ADODB.Command")
  MM_rsKey_cmd.ActiveConnection = MM_conn_JAL_STRING
  MM_rsKey_cmd.CommandText = "SELECT news_email FROM tb_newsgroup WHERE news_email = ?"
  MM_rsKey_cmd.Prepared = true
  MM_rsKey_cmd.Parameters.Append MM_rsKey_cmd.CreateParameter("param1", 200, 1, 255, MM_dupKeyUsernameValue) ' adVarChar
  Set MM_rsKey = MM_rsKey_cmd.Execute
  If Not MM_rsKey.EOF Or Not MM_rsKey.BOF Then 
    ' the username was found - can not add the requested username
    MM_qsChar = "?"
    If (InStr(1, MM_dupKeyRedirect, "?") >= 1) Then MM_qsChar = "&"
    MM_dupKeyRedirect = MM_dupKeyRedirect & MM_qsChar & "requsername=" & MM_dupKeyUsernameValue
    Response.Redirect(MM_dupKeyRedirect)
  End If
  MM_rsKey.Close
End If
%>
<%
If (CStr(Request("MM_insert")) = "news_news") Then
  If (Not MM_abortEdit) Then
    ' execute the insert
    Dim MM_editCmd

    Set MM_editCmd = Server.CreateObject ("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_conn_JAL_STRING
    MM_editCmd.CommandText = "INSERT INTO tb_newsgroup (news_username, news_info, news_email, news_city) VALUES (?, ?, ?, ?)" 
    MM_editCmd.Prepared = true
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 202, 1, 255, Request.Form("fName")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 255, Request.Form("select1")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 255, Request.Form("email1")) ' adVarWChar
    MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 255, Request.Form("city")) ' adVarWChar
    MM_editCmd.Execute
    MM_editCmd.ActiveConnection.Close

    ' append the query string to the redirect URL
    Dim MM_editRedirectUrl
    MM_editRedirectUrl = "email_news_thankyou.asp"
    If (Request.QueryString <> "") Then
      If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then
        MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
      Else
        MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
      End If
    End If
    Response.Redirect(MM_editRedirectUrl)
  End If
End If
%>
<form ACTION="<%=MM_editAction%>" METHOD="POST" id="news_news" name="news_news">

[bregent]

Did you fix this? I just tested the form and it appeared to work - redirected to a thank you page at least.

[theMachien]

Yes after 6 hrs of running over the code and TS w/ ReadyHosting it was resolved. I finally got a agent that was aware of an issue that they have with the IIS servers and sub-directories re-directing correctly. The other clown that I was talking to would not look at the RAW code only what was being returned from the code live and the call of the MM_editAction = CStr(Request.ServerVariables("URL")) which was giving the form the wrong URL and so the reset of the code was not running. The last agent looked at the RAW code and then walked through the site and after seeing what was going on he recognized right away that it was a known issue and help to resolve it. Took 15 mins.

Really kills me that when a tech TS's that they do not take the time to TS correctly and do a process of elemination instead he took the easy way out and used the excuse that they do not TS code...and that I need to fix my code.

Anyway its fixed issue solved and lesson learned.

Here are some of the ticket responses.

I have checked your domain 'jumpalotcda.com' and noticed that it is pointing to the folder 'JAL2'. After submitting the form at http://www.jumpalotcda.com/news_signup_letter.asp URL is redirecting to invalid URL http://www.jumpalotcda.com/JAL2/news_signup_letter.asp where as correct URL is http://www.jumpalotcda.com/news_signup_letter.asp . Please correct link in your script and then check the URL redirection from your end.

If you have any further questions, please update the Support Console.

Sincerely,

Vern Hines
Technical Specialist

Thank you for your reply.

I have again checked the URL redirecting issue and it appears to be scripting issue. After submitting the form URL is redirecting to incorrect URL http://jumpalotcda.com/JAL2/news_signup_letter.asp . I have pointed your domain to root and then I have accessed the your form at http://jumpalotcda.com/JAL2/news_signup_letter.asp where I was able to submit the form without any issue. There is no issue with our server. Please check the script and resolve this issue from your end. Since, we are a hosting provider unfortunately we do not provide support for designing website and customer’s coding related issues. Could you please contact the web developer to resolve this issue?

If you have any further questions, please update the Support Console.

Sincerely,

Vern Hines
Technical Specialist

Thank you for contacting Support.

The issue appears to be scripting related, as when we point "jumpalotcda.com" to the root the form is working correctly. You will need to check your code and resolve this issue from your end. Please let us know if you need further assistance.

M. Foster
Tier 2 Support

Thank you for contacting Support.

I have checked the issue, but I could not find the folder 'JAL2' either in the redirect code or in the root directory. The script 'news_signup_letter.asp' has a redirect code as ' MM_editRedirectUrl = "email_news_thankyou.asp"'. The domain 'jumpalotcda.com' is pointing to the home directory and the form at URL http://www.jumpalotcda.com/news_signup_letter.asp is working fine. Please check you code and let us know if you need further assistance.

M. Foster
Tier 2 Support

B