I have signed up with Zebrahost, who has set me all up to publish my version9 standard files to his server. Clive and I have gone over all the settings in my profile and when I publish and he has checked his server. All seem correct, but when the a5w page opens in the browser, I get error 3 - it cannot find the data files.
-
-
Re: FTP doesn't work
Simple stuff first:
Did you publish the data files?
Can Clive, you or others use your FTP account (maybe, with FileZilla or something) to see your data files?
Are you sure your path_alias.adb_path points to the correct location?-Steve
sigpic
-
Re: FTP doesn't work
We published all the files. The files were published, located on the server in the correct folders. Yet the .a5w page could not "see" the data files.Comment
-
Re: FTP doesn't work
You need to be able to answer Steve's question "Are you sure your path_alias.adb_path points to the correct location?" Open up one of the A5W pages on the server in Notepad. You can open a .A5WCMP also, but they are harder to search.
Look for physical path information pointing to a database file, see what you find. It will either be pointing to the wrong direction (but then at least you will know where) or (in the A5W page) it will look unchanged like [PathAlias_BBB.Path]\ because you spelled the alias wrong in code, or you did not actually use an alias where you should.
You might also go to View > Settings > Preferences > Web Publishing > Alias Resolution and change it to Publish Time, and then replublish.Comment
-
Re: FTP doesn't work
This is the aw5 page, located at C:\a5v9\a5Webroot, which should be looking for the file in the folder c:\a5v9\data. I don't see any direction in here. What am I missing?
<html>
<head>
<%a5
Delete tmpl_ex_congnology
DIM tmpl_ex_congnology as P
tmpl_ex_congnology = a5w_load_component("ex_congnology")
'Following code allows you to override settings in the saved component, and specify the component alias (componentName property).
'Tip: Keep the componentName property short because this name is used in page URLs, and it will help keep the URLs short.
'Each component on a page must have a unique alias (componentName property).
with tmpl_ex_congnology
componentName = "ex_congnology"
end with
'=======================================compute the HTML for the Component=======================================
delete x_ex_congnology
dim x_ex_congnology as p
x_ex_congnology = a5w_run_Component(tmpl_ex_congnology)
'=============================================================================================================
if x_ex_congnology.RedirectURL <> "" then
response.redirect(x_ex_congnology.redirectURL)
end
end if
?x_ex_congnology.Output.Head.JavaScript
?x_ex_congnology.Output.Head.CSS_Link
%>
<meta name="generator" content="Alpha Five HTML Editor Version 9 Build 1565-3191">
<title></title>
</head>
<body class="AirportPageBODY">
<p>This is a test</p>
<p> </p>
<p><br>
<table>
<tr>
<td><%A5 ?x_ex_congnology.Output.Body.Grid_Echo %></td>
</tr>
<tr>
<td><%A5 ?x_ex_congnology.Output.Body.UpdateErrors %></td>
</tr>
<tr>
<td><%A5 ?x_ex_congnology.Output.Body.Search_HTML %></td>
</tr>
<tr>
<td><%A5 ?x_ex_congnology.Output.Body.Grid_HTML %></td>
</tr>
<tr>
<td><%A5 ?x_ex_congnology.Output.Body.DetailView_HTML %></td>
</tr>
</table></p>
<p> </p>
<p> </p>
</body></html>Comment
-
Re: FTP doesn't work
Steve,
Never mind my prior note. I tried your second suggestion and it worked. Many thanks!!!!
ConradComment
-
Re: FTP doesn't work
Hi,
I am having the same sort of issues and followed the advice in these posts.
However, I am still challenged :(
I have set the preference as indicated above
I have set the [PathAlias.ADB_Path] = C:\TranData
I'm not sure what I am supposed to put in the Publish Database Files/Folder prompt in the profile. if I put nothing I get an error that it is empty, If I put the same path in I get
Error 3 - Error loading C:\TranData\staff.dbf: The system cannot find the file specified. \TranData\staff.dbf
Because you are not allowed to use a drive letter
Please - what the hell am I doing wrong
I can see the data files being created off the root of the web serverComment
-
Re: FTP doesn't work
The Alias tells Alpha were the data is at runtime, when a component or dialog is being submitted. If your dbf files are sitting in C:\TranData, then that is what the Alias should be. That path is relative to the server where the files will be published, so "C:\TranData" needs to be valid from the server's file system.
The Database Files/Folder settings tell Alpha were to publish files. The values are NOT directly related to the Alias at all; they are relative to the FTP (FTP Address property) or LAN (Webroot property).
Speaking only to your question about data, if your FTP or LAN property points to c:\TranData, then your Folder for data would be blank. If your FTP or LAN property points to c:\, then your folder would be TranData.Comment
-
Re: FTP doesn't work
Thanks again Steve,
It was the end of a 14 hour day and, as you can tell, I was ready to throw the PC out the window. I appreciate your quick responses.
Regards,
Brian.Comment
-
Re: FTP doesn't work
OK It works,
I did the following and am not sure if this is what I should do each time.
Set the FTP Setting to TranData
Database files were published to c:\A5Webroot\TranData as I expected they would be.
Moved the Database files to c:\TranData which is the setting I have for the Alias.
All worked great.
I was under the assumption that I could get the data to be published to the C:\TranData location automatically on publish, this was incorrect?
Regards,
Brian.Comment
-
Re: FTP doesn't work
The honest truth is that FTP fails quite a bit to publish the database when asked. I've documented this and several other problems with FTP and turned it in as a bug.
Run through it again, be sure to check the Publish Datafiles, and check the Edit list to ensure your tables are selected.Comment
Comment