Beta2: Webstat mod - RC4 valid

[jmeyknecht]

hehe, of course your exit visitors will not be tracked, if you moved this part out ;-)

but, well done, now i know where i have to look for a fix to patch this. this makes it easier to find a solution ;-)

[Nik2004]

Hi,

I am using phpwcms_1.1-RC4_2004-06-22 and I am trying to setup MOD_phpwcms_VTS_v1.3.4RC1.

I have followed instructions in howto.txt and edited include/inc_ext/phpOpenTracker/phpOpenTracker/Config.php where I entered db name, username, password (host is localhost, and port/socket: default).

However, in my site's pages I now get (at the end of HTML) the following error: phpOpenTracker Error: Could not connect to database.

I can't understand why this happens. Any ideas? How can I trace the source of the problem? As far as I can see, there is nothing more I can edit to help connect to the database.

Note: I have placed the tables of the OpenTracker system into the same database with phpwcms, which is called "phpwcms". Phpwcms tables have phpwcms_prepended, while OpenTracker tables have the default pot_ prepended.

So, please help.

[jmeyknecht]

try to add your mysql connection data (login, password, db, etc.) in /include/inc_ext/phpOpenTracker/phpOpenTracker/conf/phpOpenTracker.php

[Nik2004]

Thanks for the reply jmeyknecht, but please can you be more specific? Please explain me how I should do it. Can you give me an example?

Can the problem be due to my host using PHP version 4.2.3? What version of PHP needs phpOpenTracker?

MySQL client API version on my host is: 3.23.39

[jmeyknecht]

ok, if you have mysql 3.x running, it could be also another problem.

mysql 3.x doesn't support temporary tables...

so check

/include/inc_ext/phpOpenTracker/phpOpenTracker/API/plugins/top.php line: 262

/include/inc_ext/phpOpenTracker/phpOpenTracker/API/plugins/search_engines.php line: 180

and change "CREATE TEMPORARY TABLE" to "CREATE TABLE"

if this doesn't help, set

Code: Select all

$PHPOPENTRACKER_CONFIGURATION['debug_level'] = 2;

and post the errors or send me your URL.

[Nik2004]

I found that mostly it was my own fault, because I mixed up the phpOpenTracker.php files (there are many of them) and I put the $phpwcms["db_host"] = 'xxxx'; values in the wrong one.

But, I changed the CREATE TEMPORARY TABLE as well, based on your advice. Everything works fine now.

It looks great.

Thank you very much for your time and effort.

Nick

[Kvist]

I just installed the webstat mod exactly as described. It does appear in the admin part, but the links (total, today, yesterday etc.) all lead to the frontpage of the admin section - the page I get immediately after logging in.

It's probably not webstats fault, cause I have the same problem with other mods. GT never shows up in the admin section and the calendar mod just gives me dead links as I described in the above text.

Would you have an idea how to resolve this because I am blank!?

NB - UPDATE: My database is receiving the data from webstat but on my homepage I get the following error message:

Code: Select all

Warning: session_register(): Cannot send session cache limiter - headers already sent (output started at /customers/kvistnet.dk/kvistnet.dk/httpd.www/phpwcms_template/inc_script/frontend_init/sample.php:4) in /customers/kvistnet.dk/kvistnet.dk/httpd.www/include/inc_ext/phpOpenTracker/phpOpenTracker/Container.php on line 66

The results from the database are still not accessible from the admin backend.

DANISH

Jeg har netop installeret webstat mod nøjagtigt som beskrevet, og den dukker da også op i admin. Problemet er, at uanset hvilket af linkene (Total, i går, i dag etc) jeg trykker på, får jeg blot forsiden. Altså den forside jeg nårmalt får lige efter jeg har logget ind.

Det er sikkert ikke webstats skyld, for det samme sker for mine andre mods. GT dukker aldrig op i admin og calendar mods link fører også bare til forsiden.

Har du/I en ide til hvad fejlen kan være?

NB - UPDATE: Min database modtager data fra webstat, men på min side får jeg nu følgende fejl:

Code: Select all

Warning: session_register(): Cannot send session cache limiter - headers already sent (output started at /customers/kvistnet.dk/kvistnet.dk/httpd.www/phpwcms_template/inc_script/frontend_init/sample.php:4) in /customers/kvistnet.dk/kvistnet.dk/httpd.www/include/inc_ext/phpOpenTracker/phpOpenTracker/Container.php on line 66

Jeg kan stadig ikke se resultaterne fra databasen i admin.
Tak/Thanks!

Kvist
http://www.kvistnet.dk

[Kvist]

My mods aren't functioning properly yet, but I have gotten rid of the errors by upgrading with the five patches, which I had no idea existed. (Thanks Pappnase).

So webstat is working and that is the most important thing right now.

Thanks!

Kvist