Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Other > Programming Help
Reload this Page

Switched servers and ASP broke

Discuss Switched servers and ASP broke in the Programming Help forum on ASP Free.
Switched servers and ASP broke Programming Help forum discussing programming solutions and code assistance related issues. Feel free to ask questions, or to offer your assistance.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old November 17th, 2006, 10:40 AM
e36M3 e36M3 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2006
Posts: 5 e36M3 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 54 m 56 sec
Reputation Power: 0
Unhappy Switched servers and ASP broke
I just switched over a clients ASP site from another hosting provider to my server. I know very little about ASP and I have no idea where to start. So far I've just copied all the files over. The site is (URL address blocked: See forum rules) and all the pages work except the audio/video page. That page uses an access file that links to the audio files that are uploaded via ccrsc.org/admin which doesn't work either. If anyone has any ideas let me know I'm sure its something simple.

This is whats coming up in my error log-

[Fri Nov 17 09:02:29 2006] [error] [asp] [17966] [debug] Bareword found where operator expected at /var/www/vhosts/ccrsc.org/httpdocs/media.asp line 9, near ") <--> \tcmdSpeaches" <-->
[Fri Nov 17 09:02:29 2006] [error] [asp] [17966] [debug] \t(Missing operator before cmdSpeaches?) <-->
[Fri Nov 17 09:02:29 2006] [error] [asp] [17966] [debug] Bareword found where operator expected at /var/www/vhosts/ccrsc.org/httpdocs/media.asp line 11, near ""Select distinct * from Speaches order by date desc" <--> \tcmdSpeaches" <-->
[Fri Nov 17 09:02:29 2006] [error] [asp] [17966] [debug] \t(Missing operator before cmdSpeaches?) <-->
[Fri Nov 17 09:02:29 2006] [error] [asp] [17966] [debug] Bareword found where operator expected at /var/www/vhosts/ccrsc.org/httpdocs/media.asp line 12, near "1 <--> \tcmdSpeaches" <-->
[Fri Nov 17 09:02:29 2006] [error] [asp] [17966] [debug] \t(Missing operator before cmdSpeaches?) <-->
[Fri Nov 17 09:02:29 2006] [error] [asp] [17966] [error] error compiling media.asp: syntax error at /var/www/vhosts/ccrsc.org/httpdocs/media.asp line 9, near ") <--> \tcmdSpeaches" <--> , /usr/lib/perl5/site_perl/5.8.6/Apache/ASP.pm line 1468
Reply With Quote
  #2  
Old November 17th, 2006, 10:59 AM
mehere's Avatar
mehere mehere is offline
Senior Sarcasm Wizardess
Click here for more information.
  
Join Date: Feb 2005
Location: Dreamland
Posts: 12,808 mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)  Folding Points: 10976 Folding Title: Novice Folder
Time spent in forums: 4 Months 4 Weeks 48 m 14 sec
Reputation Power: 1567
are you getting an error on the audio/video asp page? if so, what is it? what line does it refer to? and what's the code on that page?
__________________
Come JOIN the party!!!

Quote of the Month:
Risks: If you never try anything new, you'll miss out on many of life's great disappointments.

Questions to Ponder:
Is there another word for synonym?

iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright© 2008 sbenj69
Reply With Quote
  #3  
Old November 17th, 2006, 11:30 AM
e36M3 e36M3 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2006
Posts: 5 e36M3 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 54 m 56 sec
Reputation Power: 0
Quote:
Originally Posted by mehere
are you getting an error on the audio/video asp page? if so, what is it? what line does it refer to? and what's the code on that page?


The error on the audio/video page comes up as a 500 internal server error. I disabled friendly error messages in IE and it still gives me the same thing. Heres the code for that page - there is a problem with lines 9, 11, and 12 according to my error log but it worked fine on the other server. Could it be something as simple as changing file permissions.

Thanks - Ken

Code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<!-- #include file="includes/adovbs.inc" -->
<!-- #include file="includes/ccrsc-inc.asp" -->

<%
	Set cmdSpeaches = Server.CreateObject("ADODB.Command")
	cmdSpeaches.ActiveConnection = cnCCRSC
	cmdSpeaches.CommandText = "Select distinct * from Speaches order by date desc" 
	cmdSpeaches.CommandType = 1
	cmdSpeaches.Prepared = TRUE
	set rsSpeaches = cmdSpeaches.Execute


%>
<html>
<head>
<title>CCRSC</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="stylesheets/ccrsc.css" rel="stylesheet" type="text/css">
</head>

<body bgcolor="#CEE5F5" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="MM_preloadImages('images/btnPract-dn.gif','images/btnWWA-dn.gif','images/btnWWB-dn.gif','images/btnOurMin-dn.gif','images/btnDA-dn.gif','images/btnClasses-dn.gif','images/btnEvents-dn.gif','images/btnDiscussion-dn.gif','images/btnAudio-dn.gif','images/btnBookStore-dn.gif','images/btnWAW-dn.gif','images/btnContact-dn.gif','images/btnLML-dn.gif')">
<table width="100%" height="100%" ><tr><td valign="top">
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
<td align="center" valign="top">
<!--#include file="header.asp"-->
</td>
</tr>
<tr>
    <td height="16" bgcolor="#7CC5EE" valign="top"><!--seperator--></td>
</tr>
<tr>
    <td bgcolor="#2F3E99" valign="top"> 
      <table border="0" cellspacing="0" cellpadding="0" align="left">
        <tr>
          <td width="205" align="left" valign="top">
            <!--#include file="menu.asp"--></td>
                <td align="right" width="495">
                  <!-- Content Cell -->
                  <table width="100%" border="0" cellspacing="0" cellpadding="3">
                    <tr> 
                      <td colspan="4"><h2>Audio & Video</h2></td>
                    </tr>
                    
					<%
						If rsSpeaches.EOF then%>
						<tr><td colspan="4"><h3>No Speaches at this time</h3></td></tr>
						<% ELSE %>
					<tr> 
                      <td><h3>Description</h3></td>
                      
                      <td><h3>Listen</h3></td>
                      <td><h3>Date</h3></td>
                    </tr>
					<% Do While	not rsSpeaches.EOF%>
                    <tr> 
                      <td><%=rsSpeaches("Description")%><br>(<%=rsSpeaches("speaker")%>)</td>
                      <td align="center" valign="middle"><a href="audio/2003/<%=rsSpeaches("name")%>"><img src="/images/speaker.gif" width="32" height="29" border="0"></a></td>
                      
                      <td align="center" valign="middle"><%=rsSpeaches("date")%></td>
                    </tr>
                    <% rsSpeaches.MoveNext
					Loop
					End If%>
                  </table>
                  

			  
            <!-- End Content Cell --></td>
  </tr>
  <tr><td colspan="2" align="center" width="100%" class="footer">
  <!--#include file="footer.asp" --></td></tr>
</table>

</td>
</tr><tr>
    <td height="16" bgcolor="#7CC5EE"><!--seperator--></td>
</tr>
</table>
</td></tr></table>
</body>
</html>
Reply With Quote
  #4  
Old November 17th, 2006, 01:23 PM
mehere's Avatar
mehere mehere is offline
Senior Sarcasm Wizardess
Click here for more information.
  
Join Date: Feb 2005
Location: Dreamland
Posts: 12,808 mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)mehere User rank is General 9th Grade (Above 100000 Reputation Level)  Folding Points: 10976 Folding Title: Novice Folder
Time spent in forums: 4 Months 4 Weeks 48 m 14 sec
Reputation Power: 1567
is your connection to the database a DSN connection or DSN-less connection? if it's a DSN connection, have you created it on the new server?
Reply With Quote
  #5  
Old November 18th, 2006, 02:48 PM
e36M3 e36M3 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Nov 2006
Posts: 5 e36M3 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 54 m 56 sec
Reputation Power: 0
Quote:
Originally Posted by mehere
is your connection to the database a DSN connection or DSN-less connection? if it's a DSN connection, have you created it on the new server?


DSN-less.....The only path to the database I could find in all the scripts was
Code:
strSource = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\WEBSITES\ccrsc.org\db\ccrsc.mdb"


the new path to the database would be \var\www\vhosts\ccrsc.org\httpdocs\database\ccrsc. mdb and its on a virtual dedicated Linux server if that makes a difference....i tried changing it to that but im getting the same error.

Thanks
Reply With Quote
Reply

Viewing: ASP Free Forums > Other > Programming Help > Switched servers and ASP broke

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway.