| Author |
 Topic  |
|
|
abercrombie
Starting Member
48 Posts |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
 Posted - 01 January 2003 : 15:53:53
|
| Can you tell us the error, we can not see your members page unless we log in... |
 |
|
|
abercrombie
Starting Member
48 Posts |
Posted - 01 January 2003 : 15:55:24
|
Oh whoops that would be good.. LOL.. it says:
Microsoft JET Database Engine error '80040e14'
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
/cgi-bin/forum/members.asp, line 233
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 01 January 2003 : 15:59:24
|
Above line 233 can you add this code, and then post the SELECT statement that appears on the page
response.write strSql & strSql2 & strSql3 & strSql4
response.end
EDIT - Can you also provide a link to a text version of your members.asp file please. |
Edited by - Hamlin on 01 January 2003 16:06:53 |
|
|
|
abercrombie
Starting Member
48 Posts |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 01 January 2003 : 16:15:25
|
Above line 233 which will look like this...
rs.open strSql & strSql2 & strSql3 & strSql4, my_Conn, adOpenStatic
EDIT - I cant seem to get to the members.txt file either... |
Edited by - Hamlin on 01 January 2003 16:17:59 |
|
|
|
abercrombie
Starting Member
48 Posts |
Posted - 01 January 2003 : 16:22:09
|
okay it just gives me this now:
SELECT MEMBER_ID, M_STATUS, M_NAME, M_LEVEL, M_EMAIL, M_COUNTRY, M_HOMEPAGE, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_TITLE, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, FROM FORUM_MEMBERS WHERE M_NAME <> 'n/a' ORDER BY M_POSTS DESC, M_NAME ASC
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 01 January 2003 : 16:27:28
|
Ok you can remove that now.
The problem is Incorrect syntax near the keyword 'FROM'.
This little bit in the middle here
M_LASTHEREDATE, M_DATE, FROM FORUM_MEMBERS
Does not need the end , character I have tried to highlight in red. I suggest you check the PM mod code you added to members.asp
EDIT - looking at the PM readme it looks like you may have made the mistake when adding the code to line 148... |
Edited by - Hamlin on 01 January 2003 16:29:11 |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 01 January 2003 : 16:31:25
|
I can get to your members.txt now so..
Line 151
strSql = strSql & "M_AIM, M_ICQ, M_MSN, M_YAHOO, M_TITLE, M_POSTS, M_LASTPOSTDATE, M_LASTHEREDATE, M_DATE, M_PMRECEIVE "
Add the red text and see if that solves the problem.. |
|
|
|
abercrombie
Starting Member
48 Posts |
Posted - 01 January 2003 : 16:39:50
|
Yes it works! Thank you very much!!
Now I had a hard time trying to install the PM mod, I wonder if the person who did the readme file can update it so he can post what lines to look for when adding that code. He did it to some of them but not all. |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 01 January 2003 : 16:45:49
|
quote:
Originally posted by abercrombie
Yes it works! Thank you very much!!
Your welcome  |
|
|
| |
Topic |
|
Topic Locked
