Page 5 of 7

Posted: Fri 7. May 2004, 23:08
by sporto
Actually I just looked again at the database and the tables are getting populated with the data so the tracking is working. But I'm getting the "can't connect" error on the admin backend. :?: :?:

Posted: Fri 7. May 2004, 23:45
by frold

Code: Select all

#
#-----[ Open ]------------------------------------------
#
phpOpenTracker\phpOpenTracker\conf\phpOpenTracker.php
try manually to put in your database settings here
// Database Type
// Available values: 'mssql', 'mysql', 'oci8', 'pgsql'
$PHPOPENTRACKER_CONFIGURATION['db_type'] = 'mysql';

// The host of your database server
$PHPOPENTRACKER_CONFIGURATION['db_host'] = $phpwcms["db_host"];

// The port your database server listens on
$PHPOPENTRACKER_CONFIGURATION['db_port'] = 'default';

// The socket your database server uses
$PHPOPENTRACKER_CONFIGURATION['db_socket'] = 'default';

// Username to connect with to your database server
$PHPOPENTRACKER_CONFIGURATION['db_user'] = $phpwcms["db_user"];

// Password to connect with to your database server
$PHPOPENTRACKER_CONFIGURATION['db_password'] = $phpwcms["db_pass"];

// Name of the database to use.
$PHPOPENTRACKER_CONFIGURATION['db_database'] = $phpwcms["db_table"];

Posted: Fri 7. May 2004, 23:47
by frold
oooops, sorry

you need to change the prefixes used in the database tables
// Name of the Additional Data Table
// Default: 'pot_add_data'
$PHPOPENTRACKER_CONFIGURATION['additional_data_table'] = 'pot_add_data';

// Name of the Access Log Table
// Default: 'pot_accesslog'
$PHPOPENTRACKER_CONFIGURATION['accesslog_table'] = 'pot_accesslog';

// Name of the Documents Table
// Default: 'pot_documents'
$PHPOPENTRACKER_CONFIGURATION['documents_table'] = 'pot_documents';

// Name of the Exit Targets Table
// Default: 'pot_exit_targets'
$PHPOPENTRACKER_CONFIGURATION['exit_targets_table'] = 'pot_exit_targets';

// Name of the Hostnames Table
// Default: 'pot_hostnames'
$PHPOPENTRACKER_CONFIGURATION['hostnames_table'] = 'pot_hostnames';

// Name of the Operating Systems Table
// Default: 'pot_operating_systems'
$PHPOPENTRACKER_CONFIGURATION['operating_systems_table'] = 'pot_operating_systems';

// Name of the Referers Table
// Default: 'pot_referers'
$PHPOPENTRACKER_CONFIGURATION['referers_table'] = 'pot_referers';

// Name of the User Agents Table
// Default: 'pot_user_agents'
$PHPOPENTRACKER_CONFIGURATION['user_agents_table'] = 'pot_user_agents';

// Name of the Visitors Table
// Default: 'pot_visitors'
$PHPOPENTRACKER_CONFIGURATION['visitors_table'] = 'pot_visitors';
change pot_ to your prefix

Posted: Sat 8. May 2004, 00:40
by sporto
I'll try this later tonight and see how it goes, but first help me understand...

I installed the default SQL file via PHPMyAdmin which includes pot_ as a prefix. My database happens to use cms_ as a prefix for all tables.

Now, the tracking is already working - data is being entered into the tables just fine. It's only on the backend admin where I can't access the information. So if I change the prefix on the data, aren't I going to mess up getting the data into the database?

Sorry I'm taking up so much time on this. THanks for your help!

Posted: Sat 8. May 2004, 09:28
by frold
sporto wrote: Now, the tracking is already working - data is being entered into the tables just fine. It's only on the backend admin where I can't access the information. So if I change the prefix on the data, aren't I going to mess up getting the data into the database?
Then you don´t need to change prefixes..... But why I will not work - I can´t answer right now, sry....

I will take a look on it tonight...

Posted: Sat 8. May 2004, 15:21
by sporto
Thanks for your help Frold.

Could it help if I upgrade from RC3 to RC4?

Posted: Sat 8. May 2004, 15:36
by frold
sporto wrote:Thanks for your help Frold.

Could it help if I upgrade from RC3 to RC4?
Well I don´t think so... but it will fix some bugs in phpwcms and add some new features... :lol:

Posted: Mon 10. May 2004, 00:05
by jmeyknecht
hi everybody.

because i read some people did claim about a non working vts + RC4, i did a fresh install of RC4 and the vts package from eMediaFabrik.
and, sorry guys, it was working alright. no error. it tracks visitors and viewing in backend is also working.

i have no clue at the mom, why it isn't working at some ppls sites :-/

Posted: Fri 4. Jun 2004, 23:17
by Mario670
When I use this Tool, my URLs look like this:

Code: Select all

www.content.shoppic.de/homepageerstellung.html?PHPSESSID=87ec2bd6fc7f116de6651a5883e94a2b 
normaly:

Code: Select all

www.content.shoppic.de/homepageerstellung.html
Where is the problem?

Mario

Posted: Sat 5. Jun 2004, 12:42
by taurentius
Not sure if this is the right place to post, but I did not think it was worth a separate thread. At any rate, I've made a Dutch translation of the WEBSTATS add-on.

--- CREATE ---
include/inc_ext/phpOpenTracker/lang/nl/
include/inc_ext/phpOpenTracker/lang/nl/lang.inc.php

--- OPEN ---
include/inc_ext/phpOpenTracker/lang/nl/lang.inc.php

--- ADD ---

Code: Select all

<?php

// added by Christian Günther (guenther@emediafabrik.de)
// and Johannes Meyknecht (meyknecht@emediafabrik.de) for VTS phpOpenTracker
// translated by Tim van Pelt (taurentius@hotmail.com)
$BL['be_nav_vts']                       = 'WEBSTATS';
$BL['be_subnav_vts_total']              = 'Totaal';
$BL['be_subnav_vts_currhour']           = 'Dit uur';
$BL['be_subnav_vts_lasthour']           = 'Vorig uur';
$BL['be_subnav_vts_today']              = 'Vandaag';
$BL['be_subnav_vts_yesterday']          = 'Gisteren';
$BL['be_subnav_vts_currweek']           = 'Deze week';
$BL['be_subnav_vts_lastweek']           = 'Vorige week';
$BL['be_subnav_vts_curryear']           = 'Dit jaar';
$BL['be_subnav_vts_lastyear']           = 'Vorig jaar';

$BL['be_vts_currhour']                  = 'Dit uur';
$BL['be_vts_lasthour']                  = 'Vorig uur';
$BL['be_vts_today']                     = 'Vandaag';
$BL['be_vts_yesterday']                 = 'Gisteren';
$BL['be_vts_currweek']                  = 'Deze week';
$BL['be_vts_lastweek']                  = 'Vorige week';
$BL['be_vts_currmonth']                 = 'Deze maand';
$BL['be_vts_lastmonth']                 = 'Vorige maand';
$BL['be_vts_curryear']                  = 'Dit jaar';
$BL['be_vts_lastyear']                  = 'Vorig jaar';

$BL['be_vts_total']                     = 'totaal';
$BL['be_vts_one_time_visitors']         = '&eacute;&eacute;n keer';
$BL['be_vts_returning_visitors']        = 'terugkerend';
$BL['be_vts_unique_visitors']           = 'uniek';
$BL['be_vts_return_visits']             = 'teruggekeerd';
$BL['be_vts_visitors_online']           = 'online';

$BL['be_vts_visits']                    = 'Bezoeken';
$BL['be_vts_visitor']                   = 'Bezoekers';
$BL['be_vts_browser']                   = 'Browser';
$BL['be_vts_os']                        = 'Besturingssysteem';
$BL['be_vts_host']                      = 'Host';
$BL['be_vts_document']                  = 'Document';
$BL['be_vts_referer']                   = 'Verwijzers';

//added by frold
$BL['be_vts_name']                      = 'Naam';
$BL['be_vts_times']                     = 'Totaal';
$BL['be_vts_procent']                   = 'Procent';
$BL['be_vts_search_engines']            = 'Zoekmachines';
$BL['be_vts_search_keywords']           = 'Zoekwoorden';
$BL['be_vts_search_combi']              = 'Gecombineerde statistieken';

?>
Hopefully this will be useful to someone.

Posted: Sat 5. Jun 2004, 17:20
by jmeyknecht
cool taurentius.
can we include this into the our VTS-Mod?
if, we would have (de, en, nl support now)
other languages are welcome too...

Posted: Sat 5. Jun 2004, 18:50
by taurentius
Sure you can :) It's a pleasure to be of assistance.

I was thinking that the functionality of the VTS/WebStats plug-in could be enhanced by making use of an IP-to-Country database such as the free one at http://ip-to-country.webhosting.info. That way you could rank users on their country of origin as well.

Also, an I have no idea how feasible this would be, it would be nice to include statistics on screen resolution and installed plugins (Flash etc.).

Just some suggestions. Must say I'm impressed by the simple and clean interface to the statistics, nice work!

Access Denied Error

Posted: Sat 12. Jun 2004, 12:26
by captaincrash
I was also experiencing the...

Code: Select all

phpOpenTracker Error: Access denied for user
...error some of you guys had. I eventually figured it out to be my ISP (Plus.Net) not setting permissions correctly on my MySQL account so the CREATE TEMPORARY TABLE query was failing.

Hope this helps someone.

Re: Access Denied Error

Posted: Tue 15. Jun 2004, 21:31
by sporto
captaincrash wrote:I eventually figured it out to be my ISP (Plus.Net) not setting permissions correctly on my MySQL account so the CREATE TEMPORARY TABLE query was failing.
Thanks for this info. How did you figure out that it was your ISP? And what did they do to correct the situation? Thanks

Mark

Posted: Tue 15. Jun 2004, 23:22
by captaincrash
I switched on extended logging in the config file and traced the exact query that was failing and recreated this in phpMyAdmin which also produced the access denied message.

In MySQL their is a specific role CREATE TEMPORARY TABLES so the guys at plus net have just run a GRANT CREATE TEMPORARY TABLES to resolve this.

Happy to help,