| Author |
 Topic  |
|
|
steverrific
Starting Member
USA
16 Posts |
 Posted - 30 January 2001 : 11:43:59
|
Greetings. I don't know if anyone is having or has had a similar problem, but if so, please share. When I go into my moderator options everything loads correctly except the table with all of the option. Instead I get the following error message. I'm running SQL 6.5.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/board/inc_functions.asp, line 1089
Thanks in advance if you are able help. I really appreciate it. :) |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 30 January 2001 : 12:39:45
|
Have you assigned any users as mederators, by editing their status in their profile?
'Resistance is futile' |
 |
|
|
steverrific
Starting Member
USA
16 Posts |
Posted - 30 January 2001 : 14:57:03
|
HuwR, you are a support maniac! Nice job! (this in regards to all of your expediant replies)
Unfortunately, I still get the error, even after I have assigned one person as a moderator, but I'm going to do a new installation tonight upgrading 6.5 to 7.0, so don't bother responding unless I post again.
Thanks again, though, for helping all us implement this very excellent board. :D |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 30 January 2001 : 16:11:11
|
Even with you upgrading to version 7 it might be a good idea to change that sql-statement to:
'## Forum_SQL
strSql = "SELECT MEMBER_ID "
strSql = strSql & " FROM " & strTablePrefix & "MODERATOR "
strSql = strSql & " WHERE FORUM_ID = " & fForum_ID & " "
strSql = strSql & " AND MEMBER_ID = " & MEMBER_ID
(you can find it at line 1083)
Pierre |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 30 January 2001 : 16:14:44
|
should this go into bugfix?
Reinsnitz (Mike)
><)))'>
"The glory of young men is their strength, and the honor of old men is their gray hair." - Proverbs 20:29
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 30 January 2001 : 16:56:54
|
It won't hurt to fix it.
Pierre |
|
|
|
steverrific
Starting Member
USA
16 Posts |
Posted - 30 January 2001 : 20:00:22
|
Thanks for your response. I upgraded my server and it seemed to fix my speed problem. I implented your solution, but it still has the same problem. I also noticed another spot 15 or 20 lines down which had a similar *. I substituted "MEMBER_ID" there, too, just to see if it would help.
Any other ideas? Here is the error code again:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/forum/inc_functions.asp, line 1089
Thanks again.
Steve
|
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 01 February 2001 : 15:32:26
|
Can you put a response.write "SQL = " & strSQL right BEFORE line 1089 and then let us know what it says? That might help us determine what is happening.
Dave Maxwell
--------------
When's the next meeting of Snitzaholics Anonymous |
|
|
|
steverrific
Starting Member
USA
16 Posts |
Posted - 09 February 2001 : 12:13:25
|
I'd love to do this, but could you clarify just a bit? I need to know if you want me to create a new line before 1089, and what "exactly" to type in. I'm not SQL literate, so I falter on doing some these tweaks.
Thanks so much.
Steverrific |
|
|
|
steverrific
Starting Member
USA
16 Posts |
Posted - 09 February 2001 : 12:34:21
|
Hold on there. Now the function is working. When I was posting this bug initially, I had no more than 20 or 30 posts and few members. Now that I'm bulking up a bit, it seems to work. Very strange.
Thanks for you all your input!
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 09 February 2001 : 13:46:32
|
quote:
I'd love to do this, but could you clarify just a bit? I need to know if you want me to create a new line before 1089, and what "exactly" to type in. I'm not SQL literate, so I falter on doing some these tweaks.
What Doug wanted you to do (and I guess it won't hurt to do it anyway and post the result here) was:
goto line 1088 (or create a new empty line there) and type:
Response.Write "SQL = " & strSQL
Response.End
Then post the output you get on your screen here please.
Pierre |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 11 February 2001 : 20:49:46
|
fixed in source of sf2k_31sr5a3.zip...
Reinsnitz (Mike)
><)))'>
"Blessed are those who hear the word of God and obey it." - Luke 11:28
|
|
|
| |
Topic |
|
Forum Locked
Topic Locked
