Snitz Forums 2000 - Config Order

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)

Config Order - Not working

New Topic

Topic Locked

Printer Friendly

Author

Topic

Page: of 2

TheBigSnake
Junior Member

154 Posts

Posted - 17 June 2004 : 13:49:46

Any know why i can't change the order?

I tryed to upload a new clean admin_config_order.asp
That didn't help

I use: strDBType = "mysql"

Edited by - TheBigSnake on 17 June 2004 15:58:55

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 June 2004 : 18:33:50

Did you try the fix recommended here: http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=41978&whichpage=2&SearchTerms=category,order,configuration

Snitz 3.4 Readme | Like the support? Support Snitz too

TheBigSnake
Junior Member

154 Posts

Posted - 17 June 2004 : 18:36:30

I din't know how to insert it.. I have read the tread you are refering to..

My file look like this:

if strDBType = "mysql" then
'## Forum_SQL
strSql2 = "SELECT COUNT(CAT_ID) AS PAGECOUNT "
strSql2 = strSql2 & " FROM " & strTablePrefix & "CATEGORY"
set rsCount = my_Conn.Execute(strSql2)
categorycount = rsCount("PAGECOUNT")
rsCount.close

rs.open strSql, my_Conn, adOpenStatic
else
rs.cachesize = 20
rs.open strSql, my_Conn, adOpenStatic

if not (rs.EOF or rs.BOF) then
rs.movefirst
rs.pagesize = 1
categorycount = cLng(rs.pagecount)
end if

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 June 2004 : 18:44:17

Are you using Snitz 3.4.04?

Snitz 3.4 Readme | Like the support? Support Snitz too

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 June 2004 : 18:46:20

Also, isn't there any code missing? Is that a contiguous part of the file?

Snitz 3.4 Readme | Like the support? Support Snitz too

TheBigSnake
Junior Member

154 Posts

Posted - 17 June 2004 : 18:48:50

Its just a part of the file yes..

It is a clean file from: sf2k_v34_04

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 June 2004 : 19:04:45

Quite likely the problem is not there. The file now includes the code just as I posted previously. Add this


Response.Write categorycount
Response.End

just below the line where you have


rsCount.close

Let me know what is shown.

Snitz 3.4 Readme | Like the support? Support Snitz too

Edited by - ruirib on 17 June 2004 19:05:48

TheBigSnake
Junior Member

154 Posts

Posted - 17 June 2004 : 19:09:42

Now it will only write this:

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 June 2004 : 19:20:30

Looks like the count is not being performed correctly. Do you have any other problems with the forum. Do posts and replies show correctly, nothing missing?

(you can remove the lines I asked you to add)

Snitz 3.4 Readme | Like the support? Support Snitz too

TheBigSnake
Junior Member

154 Posts

Posted - 17 June 2004 : 19:24:56

yes i have another problem at the moment...

I cant view any posts...
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=53453

I just made the forum today...

I made the changes about SUN:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=53152

An have installed 3 mods, Private Messeges, POLL & Active Users

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 June 2004 : 19:36:54

Well I simply don't understand how is it possible for the count SQL statements not to work! I have no explanation for that. And you wrote that uploading a new admin_order_config.asp doesn't change it, right?

Snitz 3.4 Readme | Like the support? Support Snitz too

TheBigSnake
Junior Member

154 Posts

Posted - 17 June 2004 : 19:40:48

Yes. Downloaded a new copy an uploaded the admin_config_order.asp

No change at all....

Don't guess a Admin login would make any changes?

Any files i can show ?

TheBigSnake
Junior Member

154 Posts

Posted - 17 June 2004 : 20:40:26

Access to my ftp ?! Anything ?

OneWayMule
Dev. Team Member & Support Moderator