Author |
Topic  |
chris1381
Starting Member
19 Posts |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 26 November 2001 : 01:26:30
|
send me your admin username and password for your forum. also give me your username and password for brinkster.
- David |
 |
|
EllesDee
Starting Member
4 Posts |
Posted - 26 November 2001 : 07:53:22
|
yeah, same problem here... can't open register.asp, pop_profile.asp and a couple of other .asp files...
-= Elles =- |
 |
|
EllesDee
Starting Member
4 Posts |
Posted - 26 November 2001 : 09:36:51
|
OK...
Let me just explain my installing procedure before you try anything, maybe I just made some mistakes while installing.
1. I have downloaded the .zip file and unpacked it in a directory on my PC 2. I have also unzipped the "tools.zip" 3. I have changed the confing.asp file, so that it now looks like this:
Session.LCID = 1033 '## Do Not Edit Response.Buffer = true
dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix '## Do Not Edit
'################################################################################# '## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql) '################################################################################# 'strDBType = "sqlserver" strDBType = "access" 'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines! 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/tools/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/EllesDee/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000 'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 7 'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 2000 'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
strTablePrefix = "FORUM_" strMemberTablePrefix = "FORUM_"
nothing else was changed!
4. I started uploading all files to the /ellesdee/forum/ directory as some .asp files couldn't be uploaded because of "on error resume next" line, i commented those out. At the end of every .asp file where that line was commented out, I've put "on error goto 0" just before the closing bracket, at the end of file. 5. I have uploaded the snitz_forums_2000 ms access file to the /ellesdee/db/ directory 6. After uploading, I went to /ellesdee/forum/setup.asp ---> succesful installation. 7. I went to the /ellesdee/forum/default.asp page 8. I tried to change my settings (username, password) and that's where first problems occured. The "Admin" page couldn't be loaded. I got the same message as I tried to reach the "register" page.
Now, I must say that I have absolutly no idea about ASP or SQL, and maybe I will have to learn it first BUT: if there is a possibility of seting that forum up without having to learn ASP and SQL, then I would be very gratefull for every help I get! :) Another thing: I know that this forum was made by people who didn't earn a thing on it. Maximum respect for that! I am also aware of the fact that the problem lies on brinkster.com and not on this forum. Nevertheless, I would like to keep my brinkster account, as it is free AND no banners :)
Ok, that should be it!
P.S.: Sorry about my bad english!
-= Elles =- |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 26 November 2001 : 16:37:35
|
You need to un-comment the "on error resume next" code. Don't remove. delete or un-comment that code out of any of the files. All you need to do is place the "on error goto 0" code at the end of the files before the closing bracket just like you did.
- David |
 |
|
EllesDee
Starting Member
4 Posts |
Posted - 26 November 2001 : 18:38:41
|
That's exactly what I have done. Still, it didn't work out. I have deleted the whole forum directory and will reinstall it tomorrow. If I don't succed, I'll cry for help again 
-= Elles =- |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 26 November 2001 : 23:42:03
|
Oh wow. You didn't have to do that. Just because you have a problem in one file doesn't mean your whole forum needs to be re-installed. It's not like a software that you run on your computer. If there is a problem with the software you try and restart or re-install it to see if it will fix the problem.
If there is a problem with one file, re-installing the forum won't fix it. Because the problem is in the code. Re-installing on Brinkster is the last thing I would want to do, since you have to upload 5 files at a time.
- David |
 |
|
EllesDee
Starting Member
4 Posts |
Posted - 27 November 2001 : 06:46:08
|
No, wait!
I didn't delete it to fix the problem, I deleted it because I got really pissed off :)
Anyway, found a new forum, so the problem is fixed.
Thanx anyway!
-= Elles =- |
 |
|
chris1381
Starting Member
19 Posts |
Posted - 03 December 2001 : 23:07:49
|
quote:
send me your admin username and password for your forum. also give me your username and password for brinkster.
- David
I sent you my info for brinkster and snitz
|
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 03 December 2001 : 23:28:39
|
Was it only the registration you had a problem with? If so, it should be fixed.
- David |
 |
|
chris1381
Starting Member
19 Posts |
Posted - 04 December 2001 : 13:23:44
|
When i try to post a new forum it gives me an error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'FORUM_ALLOWED_MEMBERS.FORUM_ID ='.
/chris1381/forum/post.asp, line 910
|
 |
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 04 December 2001 : 19:49:05
|
I had that same error when sodding about a couple of days back..
I'm pretty sure its caused by the "On Error GoTo 0" being added in the wrong place or in the wrong way..... If you use Davio's Brinkster files you'll find it will fix this problem..
Good Luck, Robin.
............................................... Snitz 3.3.03, hosted by 121, access 2000 database. Mods Installed: Active Users, PM, IP Ban, Hide email. Avatar2. Forum: www.carp-uk.net/forum |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 05 December 2001 : 02:36:35
|
Doughnut, that should be the reason for this error, but it's not. I just checked his post.asp file and it has the on error goto 0 statement at the end. It's my brinkster file he is using. All the on error resume next statements are there. 3 are in post.asp. With the first one being commented out.
I added the on error goto 0 statement in my forum file and tried it and it didn't give any error.
My second guess woul dhave been frontpage. But the file is exactly as the same as my brinkster file so that can't be it.
chris, can you send me your admin username and password for your forum. The one you sent me doesn't work. I get an "invalid username and password".
- David |
 |
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 05 December 2001 : 04:23:54
|
Alright Davio,
Sorry I'm not doubting you at all but are you sure hes uploaded all your files... when I was messing around I got the same errror and in the end I found it to be a combination of two files causing this and when I got them both right... Bingo!
I know this isn't very helpful but one of the critical files was inc_profile and I dont think the other one was post but I can't remember the other, could you point to your Brinkster files please, if I look through it "might" jog my memory.
Thanks, Robin.
............................................... Snitz 3.3.03, hosted by 121, access 2000 database. Mods Installed: Active Users, PM, IP Ban, Hide email. Avatar2. Forum: www.carp-uk.net/forum |
 |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 05 December 2001 : 04:50:38
|
Ok, I checked the inc_functions.asp file and realized that didn't include the on error goto 0 statement so I uploaded my modified version of it.
Hey, don't apologize for doubting me!!! I'm not always right you know. I do make mistakes too, just not as frequently as others. 
Chris, check again and see if that fixed your problem.
- David |
 |
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 05 December 2001 : 05:52:27
|
 
I knew inc_profile was involved somewhere along the line!
Also I knew your Brinkster files were spot on because I've tried em, although mine were working I had much more confidence in your files so I replaced my ones with your in the Brinkster Frindly forum,,, hope you don't mind..... Can just say one more thing check for the timouts in your Brinkster files, just something I spotted 
Good Luck to chris1381 but I'm sure you've got him sorted anyway! Robin.
............................................... Snitz 3.3.03, hosted by 121, access 2000 database. Mods Installed: Active Users, PM, IP Ban, Hide email. Avatar2. Forum: www.carp-uk.net/forum |
 |
|
Topic  |
|