| Author |
 Topic  |
|
frankie
Junior Member
Vatican City
304 Posts |
 Posted - 14 March 2001 : 01:37:12
|
larango,
There is something wrong with your db driver. Check it out and try again. The mod works fine with MSAccess.
 |
 |
|
|
larango
Starting Member
Colombia
20 Posts |
Posted - 14 March 2001 : 07:29:57
|
Thans Frankie, I will double check everything. Let you know
|
|
|
|
hansie
Starting Member
Netherlands
4 Posts |
Posted - 16 March 2001 : 09:05:33
|
I got the same error as larango.
Maybe a solution could be if someone could post the used columns including definitions used for the stats table for use in an Access database, so one can add the table by hand and upload the database to the server.
Great Forum by the way!
Edited by - hansie on 16 March 2001 09:10:58 |
|
|
|
larango
Starting Member
Colombia
20 Posts |
Posted - 19 March 2001 : 22:47:49
|
Hi hansie, do you use a DSN connection to your Access DB?
I do. I have been checking everything out and still not found what the problem is. I also tried with a DSNless connection and errors messages decreased but still get some. Bottom line I can't get the Mod to work. See you.
Edited by - larango on 19 March 2001 22:50:04 |
|
|
|
hansie
Starting Member
Netherlands
4 Posts |
Posted - 20 March 2001 : 05:37:08
|
Hi larango,
Yep, I use a DSN connection
and can't figure out what the problem is.
cheers
|
|
|
|
lancepr
New Member
73 Posts |
Posted - 21 March 2001 : 20:23:23
|
I got rid of all the FORMAT commands so the Dates work, but I am not getting any stats.
What do Access Querys convert to in SQL?
I have never used Access just SQL, are they just views?
Anyone converted them?
I also just d/l the 3.1 ver from http://www.2enetworx.com
Edited by - lancepr on 21 March 2001 20:24:25 |
|
|
|
Spamajor
Starting Member
Netherlands
1 Posts |
Posted - 01 April 2001 : 13:35:59
|
Hello,
just an idea I used to get rid of the Sql problem.
Stats_config.asp includes config.asp
config.asp is configured to use Mysql or MSsql. So copy this file and rename it to config_fun.asp, configure it to use a MS Access 2000 Db. Let Stats_config.asp include config_fun.asp instead of config.asp, Et voila. No prob at all. 
(use the DB provided with snitz forum (the one in tools.zip))
typo's removed
--------------
Help me
Edited by - Spamajor on 01 April 2001 13:41:34 |
|
|
|
teddychu
Starting Member
1 Posts |
Posted - 10 April 2001 : 07:50:05
|
what is it???
|
|
|
|
sennan
Starting Member
Australia
21 Posts |
Posted - 23 April 2001 : 22:49:02
|
quote:
does anyone has problem with this one?
View detailed reports to see the statistics about Browsers, Resolutions, Colors, Operating Systems Pages and Referers
On my computer it won't show any stats obtained.
Ive also got this problem
http://forums.sennan.net
-=[ http://forums.sennan.net ]=- |
|
|
|
nonstop
Starting Member
7 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 24 April 2001 : 22:46:04
|
well I thought everything went smoothly but it appears that the only information being recorded is the page/daily hits and ip address, nothing else. I checked the database and all the tables are present, what am I doing wrong??
Here is a link to the forum, the reports image is down at the bottom. TIA
http://djh.dynamic-site.net/hooverforum/default.asp
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 27 April 2001 : 19:43:04
|
anyone have a clue about the above post?
|
|
|
|
kbhore
Starting Member
2 Posts |
Posted - 01 May 2001 : 16:57:43
|
Hi,
I integrated this MOD in my forum. It works fine when I test it on my Intranet.
But when I upload it to the net (making due necessary changes in DSN) the stats are not recorded.
But when I copy the link (stats_function?....) generated by the Javascript and open it in the browser, it works.
Help Please !!
|
|
|
|
kalak
Starting Member
13 Posts |
Posted - 04 May 2001 : 20:51:21
|
I have tried to install this stat mod without any luck.
I am using it on my own Windows 2000 server. Access 2000 mdb. Everything is working OK.
Error message is:
CREATE TABLE BROWSERS(BrowserID int IDENTITY (1, 1) NOT NULL CONSTRAINT primarykey PRIMARY KEY, BrowserName VARCHAR(100) NULL, Total INT)
424 | Object required
CREATE TABLE COLORS(ColorID int IDENTITY (1, 1) NOT NULL CONSTRAINT primarykey PRIMARY KEY, ColorName VARCHAR(20) NULL, Total INT DEFAULT 0)
424 | Object required
CREATE TABLE OSes(OsID int IDENTITY (1, 1) NOT NULL CONSTRAINT primarykey PRIMARY KEY, OsName VARCHAR(20) NULL, Total INT DEFAULT 0)
424 | Object required
CREATE TABLE PATHS(PathID int IDENTITY (1, 1) NOT NULL CONSTRAINT primarykey PRIMARY KEY, PathName VARCHAR(250) NULL, Total INT)
424 | Object required
CREATE TABLE REFS(RefID int IDENTITY (1, 1) NOT NULL CONSTRAINT primarykey PRIMARY KEY, RefName VARCHAR(250) NULL, Total INT)
424 | Object required
CREATE TABLE RESOLUTIONS(ResID int IDENTITY (1, 1) NOT NULL CONSTRAINT primarykey PRIMARY KEY, ResName VARCHAR(10) NULL, Total INT)
424 | Object required
CREATE TABLE STATS(StatID int IDENTITY (1, 1) NOT NULL CONSTRAINT primarykey PRIMARY KEY, [Date] datetime, [Time] datetime, IP VARCHAR(20) NULL, OsID INT DEFAULT 0, ColorID INT DEFAULT 0, BrowserID INT DEFAULT 0, ResID INT DEFAULT 0, PathID INT DEFAULT 0, RefID INT DEFAULT 0)
424 | Object required
3709 | Operation is not allowed on an object referencing a closed or invalid connection.
3709 | Operation is not allowed on an object referencing a closed or invalid connection.
3709 | Operation is not allowed on an object referencing a closed or invalid connection.
3709 | Operation is not allowed on an object referencing a closed or invalid connection.
Queries upgrade done!
What is wrong ?
|
|
|
|
Man[0]War
Starting Member
United Arab Emirates
40 Posts |
Posted - 08 May 2001 : 02:47:36
|
Hey Frankie!
H E L P 
I'm having trouble with this as well.. have a look :
+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
CREATE TABLE BROWSERS(BrowserID int COUNTER NOT NULL , BrowserName VARCHAR(100) NULL, Total INT)
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
CREATE TABLE COLORS(ColorID int COUNTER NOT NULL , ColorName VARCHAR(20) NULL, Total INT DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
CREATE TABLE OSes(OsID int COUNTER NOT NULL , OsName VARCHAR(20) NULL, Total INT DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
CREATE TABLE PATHS(PathID int COUNTER NOT NULL , PathName VARCHAR(250) NULL, Total INT)
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
CREATE TABLE REFS(RefID int COUNTER NOT NULL , RefName VARCHAR(250) NULL, Total INT)
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
CREATE TABLE RESOLUTIONS(ResID int COUNTER NOT NULL , ResName VARCHAR(10) NULL, Total INT)
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
CREATE TABLE STATS(StatID int COUNTER NOT NULL , [Date] datetime, [Time] datetime, IP VARCHAR(20) NULL, OsID INT DEFAULT 0, ColorID INT DEFAULT 0, BrowserID INT DEFAULT 0, ResID INT DEFAULT 0, PathID INT DEFAULT 0, RefID INT DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
424 | Object required
424 | Object required
424 | Object required
424 | Object required
Queries upgrade done!
+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
I believe it's the COUNTER NOT NULL statement that's having problems. I tried the above Creat Table statements with MS-Query .. and it gives syntax error!
|
|
|
|
Topic |
|
Topic Locked
