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: Database: MS SQL Server
 Active users problem
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Cyberstorm
Starting Member

6 Posts

Posted - 29 September 2010 :  12:16:34  Show Profile
I have converted my forum from mdb to SQL.
After this dosnīt active users work.
I can se if users are in start page or login.
But when users read topics i canīt se that.
Itīs says "Invalid Location "

What to do?

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 September 2010 :  17:56:09  Show Profile  Send ruirib a Yahoo! Message
I'd say you'd need to have a look at the database to see what info is being kept in the AU_QUERYSTRING column.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Cyberstorm
Starting Member

6 Posts

Posted - 03 October 2010 :  17:02:57  Show Profile
it says rand=6118403&TOPIC_ID=1608&whichpage=3 when user read a topic
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 03 October 2010 :  17:42:58  Show Profile  Send ruirib a Yahoo! Message
That rand part seems a bit weird, never seen it anywhere before. Does it show in your querystring when you view a topic?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts

Posted - 04 October 2010 :  09:36:35  Show Profile  Visit bobby131313's Homepage
Looks like something designed to break the users cache. LiveWorld does something similar on the eBay boards. But on a Snitz forum? Very odd indeed....

Switch the order of your title tags
Go to Top of Page

Cyberstorm
Starting Member

6 Posts

Posted - 04 October 2010 :  13:32:04  Show Profile
Yes.
When a user read a topic and i look in the database "AU_QUERYSTRING" it says rand=6118403&TOPIC_ID=1608&whichpage=3
Im usig MSQL and have converted database from access to MSQL.


quote:
Originally posted by ruirib

That rand part seems a bit weird, never seen it anywhere before. Does it show in your querystring when you view a topic?

Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 06 October 2010 :  08:23:21  Show Profile
Rui meant does it appear in your browser's address bar when viewing a topic?


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Cyberstorm
Starting Member

6 Posts

Posted - 09 October 2010 :  12:40:27  Show Profile
Yes it does.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 09 October 2010 :  16:04:54  Show Profile  Send ruirib a Yahoo! Message
Was that a result of any changes done at the same time as the database conversion, or it was always like that? If the former, then there is the cause of your problem, if the latter, then it still is the likely cause of your problem, but what you are experiencing now is likely what happened before the conversion, too.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Cyberstorm
Starting Member

6 Posts

Posted - 18 October 2010 :  16:44:45  Show Profile
Everything worked without problems before i converted the database to SQL.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 18 October 2010 :  16:54:58  Show Profile  Send ruirib a Yahoo! Message
I am sorry, I have done many conversions and database conversions do not cause this. Unless the conversion was not properly done and that caused some issue where the code does not do what it should.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Cyberstorm
Starting Member

6 Posts

Posted - 18 October 2010 :  17:19:44  Show Profile
A have converted database with Microsoft Access 2010.

Could there be something wrong in the code of active_users.asp ?

Edited by - Cyberstorm on 18 October 2010 17:26:19
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 19 October 2010 :  18:05:17  Show Profile  Send ruirib a Yahoo! Message
I think nothing is wrong. The active users code just doesn't understand that rand=xxxx part in the URL.


Snitz 3.4 Readme | Like the support? Support Snitz too
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.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07