Posted: Fri 7. May 2004, 23:08
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.



The phpwcms support forum will help to find answers to your questions. The small but strong community is here since more than 10 years.
https://forum.phpwcms.org/
Code: Select all
#
#-----[ Open ]------------------------------------------
#
phpOpenTracker\phpOpenTracker\conf\phpOpenTracker.php
// 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"];
change pot_ to your prefix// 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';
Then you don´t need to change prefixes..... But why I will not work - I can´t answer right now, sry....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?
Well I don´t think so... but it will fix some bugs in phpwcms and add some new features...sporto wrote:Thanks for your help Frold.
Could it help if I upgrade from RC3 to RC4?
Code: Select all
www.content.shoppic.de/homepageerstellung.html?PHPSESSID=87ec2bd6fc7f116de6651a5883e94a2b
Code: Select all
www.content.shoppic.de/homepageerstellung.html
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'] = 'éé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';
?>
Code: Select all
phpOpenTracker Error: Access denied for user
Thanks for this info. How did you figure out that it was your ISP? And what did they do to correct the situation? Thankscaptaincrash 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.