Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 ASP Error On Main Page - Confused....
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ArcanePathos
Starting Member

2 Posts

Posted - 01 May 2006 :  01:52:04  Show Profile  Send ArcanePathos an AOL message
Hello all!!

I had to make a couple very small modifications to the original script to make it "work" originally (specifically, I found a line in a crucial end/if statement that was COMMENTED out... wtf?), and then I finally ran into the "must contain an updateable query" error. Found that my own server permissions weren't set right for the folder/database, so I fixed that, and finally was able to proceed. I have been able to create users and all that so far, but the main forum itself will not work. The following error is generated just by accessing the main page:

Microsoft JET Database Engine error '80040e14'
Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

/forums/Default.asp, line 795


I looked at it, but my ASP knowledge only goes so far - is this a problem with the script that can be easily fixed, or is this an issue with my server itself? Please help! >.>

The forum is currently in a seperate folder until I can prove it works and thus implement it into my own page. Here's the link:
http://www.arcanepathos.com/forums/

My main site is:
http://www.arcanepathos.com/

laser
Advanced Member

Australia
3859 Posts

Posted - 01 May 2006 :  05:31:33  Show Profile
quote:
specifically, I found a line in a crucial end/if statement that was COMMENTED out... wtf?
I would go back to the original files in the ZIP, it sounds like you have just installed the forum and uncommenting code will just lead to problems.
Go to Top of Page

ArcanePathos
Starting Member

2 Posts

Posted - 01 May 2006 :  16:28:43  Show Profile  Send ArcanePathos an AOL message
Yes, I did just install it, but I was receiving another ASP error that when I checked the line number, I found just a few lines up what appeared to be a commented-out ending of an end-if statement. As if I wrote:

<% If Session("MakeMyForumsWorkPlz") = 1 Then %>

Do Whatever

'<% End If %>

And obviously that would not work, but that seemed to be the gyst of the problem.

I am at work right now, however, so I'll reply again to this thread and show you the exact error after updating my pages with the original code again. I do know that I was receiving the error BEFORE I fixed my permissions error... I fixed this problem, then started getting "must contain an updateable query," fixed my permissions, and now I get the error you see on my page.

Anyway, just wait for my reply... and thank you for your help!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.38 seconds. Powered By: Snitz Forums 2000 Version 3.4.07