Snitz Forums 2000 - pending members error

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: General / Classic ASP versions(v3.4.XX)

pending members error

New Topic

Topic Locked

Printer Friendly

Author

Topic

Brett Alcock
New Member

65 Posts

Posted - 24 September 2004 : 08:39:55

Snitz 3.4.02, apachi, linux, php, ChillisoftASP, mySQL, www.grsuk.com/info.php

I am getting the following error when trying to view a second page of pending members?

ADODB.Recordset.1 error '80004005'

SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near '; LIMIT 15, 15' at line 1

/forum/admin_accounts_pending.asp, line 262

I've searched these forums for various things like '80004005 pending' but can't find anything on this. I'll try and mod it to print the SQL string out when accessing the second page, then post it here, but in the mean time if anyone has any idea please let me know.

Edited by - Brett Alcock on 24 September 2004 08:44:34

Brett Alcock
New Member

65 Posts

Posted - 24 September 2004 : 09:06:26

Ok here is the sql string that causes the error:

strSql1= SELECT COUNT(MEMBER_ID) AS PAGECOUNT
strSql2= FROM FORUM_MEMBERS_PENDING
strSql3= ORDER BY MEMBER_ID ASC;
strSql4= LIMIT 15, 15
 
strAll= SELECT M_NAME, M_EMAIL, MEMBER_ID, M_DATE, M_IP, M_KEY,
M_APPROVE FROM FORUM_MEMBERS_PENDING ORDER BY MEMBER_ID ASC; LIMIT 15, 15

I'm not sure on my SQL syntax, but can one actually have something after the terminating semicolon? the same string for page one does not have the LIMIT 15, 5 after the semicolon and works fine.

Only other odd things about this page was negative days etc, but sorted that with a fix from here a few moments ago. I can also see that date/times can have 60 seconds (rather than 59-00), which seems to force days pending to 0 (ideas on a fix for that would be useful).