| Author |
 Topic  |
|
c1sissy
New Member
85 Posts |
 Posted - 24 December 2003 : 10:19:39
|
Hi, my first problem isn't reall all that giant, I have two statistics boxes on the page and would like guidance in removing one.
Next problem is sort of major.
I was listed on 1asp host on one page and moved to another one. The were supposed to remove the old one, but it is still up. I have people signing up there and on the new page as well. How do I merge the members into the one site? And Ihave emailed their support for removing the old page. or redirecting.
Next problem is that I cant get into the members area to see the information. I keep getting an error.
Microsoft VBScript compilation error '800a0400'
Expected statement
/fibrom/members.asp, line 435
" <td bgcolor=""" & CColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine
^
I would like to thank you in advance for any help. |
c1sissy
Can I hypnotise myself to learn faster??!!!
http://rienfam.tripod.com |
Edited by - ruirib on 29 December 2003 14:13:15 |
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 24 December 2003 : 11:41:51
|
| dunno bout 1st and 3rd but u could try the long way - adding them all urself... i was gonna do that with mine but then i came to my senses ;) |
 |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 24 December 2003 : 16:47:29
|
As for the first, have you done any modifications to default.asp? Can you post a link to a text-version of default.asp?
The second. Do you still have ftp-access to your 1asp host? If so, remove all files on 1asp host, and add a new default.asp which has the url to the new website. Are you using access for database? If so, download it before you delete it.
For the third, use the info from your downloaded database to add the newly registered members to your new site. Or just use the email-addy they used to notify them that they have to register again on your new website. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
c1sissy
New Member
85 Posts |
Posted - 28 December 2003 : 21:54:34
|
quote:
Originally posted by masterao
As for the first, have you done any modifications to default.asp? Can you post a link to a text-version of default.asp?
The second. Do you still have ftp-access to your 1asp host? If so, remove all files on 1asp host, and add a new default.asp which has the url to the new website. Are you using access for database? If so, download it before you delete it.
For the third, use the info from your downloaded database to add the newly registered members to your new site. Or just use the email-addy they used to notify them that they have to register again on your new website.
Unfortunatly, I sent an email to the host, and they did a redirect before I could do anything to save my members that werent on the new page They dont' usually respond so quickly, and over Christmas with so much to do, who'd thought that they would have done this so quickly?
I have lost about 7 members, which is 7 too many.
quote:
As for the first, have you done any modifications to default.asp? Can you post a link to a text-version of default.asp?
Yes, I had added several mods to the forum. I'm sure that it is something that I have done within the addition to this.
I see your directions masterao, and am confused as I am not used to doing such things with the database. I can give you access to the site so that you can see the files as they changed soemthing and the way that the data is accessed is different from the way that it is explained how to do this in the set up (I hope that I am making sense) I had a bud from another forum that I am in fix the connection string for me.
sorry so long to reply, but holiday and such kept me busy, lol.
Hope that all had a wonderful christmas. And please have a safe new years. |
c1sissy
Can I hypnotise myself to learn faster??!!!
http://rienfam.tripod.com |
Edited by - c1sissy on 28 December 2003 21:55:16 |
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 29 December 2003 : 07:02:22
|
Where are the statistics boxes shown? On all pages, or on only one page?
Give a link to the page(s) where those boxes are shown and which you'd like to see removed. Then someone can ask for the right file(s) and give you pointers for the removal of one of the boxes.
Post a link to a .txt version of your members.asp so we can take a look at what's possibly causing that error. |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
c1sissy
New Member
85 Posts |
Posted - 29 December 2003 : 11:06:06
|
Hi Roland! How are you, and how was your Christmas?
Ok Roland and Masterao, here is the link to the page with the double statistics box
http://c.1asphost.com/fibrom/
Be patient as the host appears to be down right now. I had to go to domaindlx and post the text file so that you could all see it.
And here is the link to the text file
http://users.domaindlx.com/c1sissy/members.txt
I'm sure that I did a few errors when adding mods.
I would like to thank all of you who spend time here that know asp helping thos who dont. |
c1sissy
Can I hypnotise myself to learn faster??!!!
http://rienfam.tripod.com |
|
|
|
miperez
Junior Member
Spain
243 Posts |
Posted - 29 December 2003 : 12:07:09
|
Hi,c1sissy.
That seems to be default.asp. The code that displays the Statistics there is the following one:
...
end if
next '## Next Category
end if
if strShowStatistics = "1" then
WriteStatistics
end if
Response.Write " </table>" & vbNewline & _
" </td>" & vbNewline & _
...
It is between lines 578 and 580 in my forum, but it's modded so they may be different in yours.
I suggest you to open the file in a text editor, and look for "WriteStatistics", that should only appear once; in case it appears twice, you should remove the second one.
Edited to remark this: except if the second one is just the function definition, of course 
Try it and see if it helps |
Best Regards
Mikel Perez
"Hell is the place where everything test perfectly, and nothing works"
|
Edited by - miperez on 29 December 2003 12:09:06 |
|
|
|
c1sissy
New Member
85 Posts |
Posted - 29 December 2003 : 13:59:12
|
quote:
Originally posted by miperez
Hi,c1sissy.
That seems to be default.asp. The code that displays the Statistics there is the following one:
...
end if
next '## Next Category
end if
if strShowStatistics = "1" then
WriteStatistics
end if
Response.Write " </table>" & vbNewline & _
" </td>" & vbNewline & _
...
It is between lines 578 and 580 in my forum, but it's modded so they may be different in yours.
I suggest you to open the file in a text editor, and look for "WriteStatistics", that should only appear once; in case it appears twice, you should remove the second one.
Edited to remark this: except if the second one is just the function definition, of course
Try it and see if it helps
Hi Miperez:
Thanks, I will load this into homestyle as it seems to give a better look at the code. I tried to look at it before but couldn't seem to figure out what it was that I needed to fix.
Now to the members.asp. Soemthing is goofy, as the one that I downloaded from the site did say members.asp, which I resaved as text to display. I'm soooo confused!
<edit>Correction to the double statistcs is fixed! Thanks for the help on this one!</edit> |
c1sissy
Can I hypnotise myself to learn faster??!!!
http://rienfam.tripod.com |
Edited by - c1sissy on 29 December 2003 14:11:19 |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 29 December 2003 : 14:14:17
|
c1sissy, in you members.asp, locate the following on line 435 and add the redmarked text:
end if
Response.Write " <td bgcolor=""" & CColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine
That should fix that problem with members.asp. What did you consider goofy with members.asp/members.txt?
If you don't find the repetetive code that miperez mentioned in default.asp, save it as a text-file and post the link here. We will find the errant code for you  . |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
Edited by - masterao on 30 December 2003 09:25:30 |
|
|
|
c1sissy
New Member
85 Posts |
Posted - 29 December 2003 : 14:29:55
|
quote:
Originally posted by masterao
c1sissy, in you members.asp, locate the following on line 435 and add the redmarked text:
end if
Response.Write " <td bgcolor=""" & CColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine
That should fix that problem with members.asp. What did you consider goofy with members.asp/members.txt?
If you don't find the repetetive code that miperez mentioned in default.asp, save it as a text-file and post the link here. We will find the errant code for you .
I thought that the previous reply re the members.asp was stating that it was the defaul asp? I could have mis read this.
*Note to self, rest when sick and don't work on pc ;>)
Thanks for the code for the members page, I'll get to that now. The previous thing with the double statistics boxes is fixed. I loaded up into the homestle and got it right away. lol, love the find feature on that. |
c1sissy
Can I hypnotise myself to learn faster??!!!
http://rienfam.tripod.com |
|
|
|
c1sissy
New Member
85 Posts |
Posted - 29 December 2003 : 14:43:10
|
quote:
Originally posted by c1sissy
[quote]Originally posted by masterao
c1sissy, in you members.asp, locate the following on line 435 and add the redmarked text:
end if
Response.Write " <td bgcolor=""" & CColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine
That should fix that problem with members.asp. What did you consider goofy with members.asp/members.txt?
If you don't find the repetetive code that miperez mentioned in default.asp, save it as a text-file and post the link here. We will find the errant code for you .
I thought that the previous reply re the members.asp was stating that it was the defaul asp? I could have mis read this.
*Note to self, rest when sick and don't work on pc ;>)
Thanks for the code for the members page, I'll get to that now. The previous thing with the double statistics boxes is fixed. I loaded up into the homestle and got it right away. lol, love the find feature on that.
EDIT:
Now i have a different problem. On the home page if I click members it just takes me right back to the home page. Tried to access this from the file manager and the following is what I am getting now
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'M_DATE M_AIM'.
/fibrom/members.asp, line 237
|
c1sissy
Can I hypnotise myself to learn faster??!!!
http://rienfam.tripod.com |
Edited by - c1sissy on 29 December 2003 14:44:33 |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 30 December 2003 : 09:29:42
|
I missed to mark the code red in my earlier post, but I have corrected that now.
Regarding the new problem with members.asp, Im unable to load both the text-file or your forum. In case you have removed the members.txt, perhaps you can put it back again? |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
c1sissy
New Member
85 Posts |
Posted - 30 December 2003 : 11:10:53
|
| Hi Jan, there is apparently a server problem today as loading the pages were a problem. If you get the page can't be displayed it is always due to the server over there. I just clicked the link here in the forum and it took me right there. btw, I did figure out what was missing that was not in red. Thanks again for the help in that area. |
c1sissy
Can I hypnotise myself to learn faster??!!!
http://rienfam.tripod.com |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 30 December 2003 : 16:58:56
|
Im still not able to reach that text-file, although your forum loaded rather quick this time. I'll try to help you regardless.
The error you recieve now seems to be caused by a faulty sql-query. Does line 237 start with rs.open? If so, how does the whole line 237 looks like?
If it looks like this, rs.open strSql & strSql2 & strSql3 & strSql4, my_Conn, adOpenStatic, then do as follows:
Add the following two lines before line 237.
response.write strSql & strSql2 & strSql3 & strSql4
response.end
Copy the text that members.asp outputs and post it here. You can then remove those two lines from your members.asp. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
c1sissy
New Member
85 Posts |
Posted - 30 December 2003 : 20:50:41
|
| Hi Jan, thanks for the help, even though you can't see it. I am going to upload it to a different site that I use this way maybe you can get in, also I'll open it up in the homesite and take a look at the line that you are refering to. I'll post both when I fix it, and thanks bunches for your great help! |
c1sissy
Can I hypnotise myself to learn faster??!!!
http://rienfam.tripod.com |
|
|
|
Topic |
|
Topic Locked
