Forum .LRN Q&A: User Tracking has some errors

Collapse
1: User Tracking has some errors
Posted by Anny Flores on 09/01/05 01:00 AM
Hi,

I wanted to let you know that User Tracking is not working properly lately and also know if anyone has the same problem and could help me.

I installed user tracking 0.1d2 in a oacs installation (without dotlrn) and it didn't work. I think that this only works with dotlrn but there are no dependencies defined.

Also, when I try to see the visits by users i get this error:

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR: pg_atoi: error in "CurriculumProgress_1299=start;_ad_user_login=491%2c1124996517%2c54B77EB53+%7b447+0+5CF04D1DBF6B4AF382011D01F3631FE97408C02E%7d;": can't parse "CurriculumProgress_1299=start;_ad_user_login=491%2c1124996517%2c54B77EB53+%7b447+0+5CF04D1DBF6B4AF382011D01F3631FE97408C02E%7d;"

SQL:
select first_names,
last_name,
last_visit
from cc_users
where user_id= 'CurriculumProgress_1299=start;_ad_user_login=491%2c1124996517%2c54B77EB53+%7b447+0+5CF04D1DBF6B4AF382011D01F3631FE97408C02E%7d;'

while executing
"ns_pg_bind 0or1row nsdb0 {
select first_names,
last_name,
last_visit
from cc_users
..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
invoked from within
"set selection [db_exec 0or1row $db $full_statement_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec 0or1row $db $full_statement_name $sql]
}"
(procedure "db_0or1row" line 23)
invoked from within
"db_0or1row select_user_data {} "
("while" body line 5)
invoked from within
"while { $i > 0} {
set linea [gets $dataFile]
set campos [split $linea]
set user_id [lindex $campos 0]
if { [db_0or1row select_user_data {} ] } {
..."
("uplevel" body line 129)
invoked from within
"uplevel {
ad_page_contract {
@author sergiog (mailto:sergiog@tid.es)
@author doa (mailto:doa@tid.es)
@creation-date 2005-01-10
} -query { .....

And when I try to see one class statistics i get this error:

divide by zero
while executing
"expr $TotalVisits/$TotalUnique"
invoked from within
"if {$asked_date <= $today } {

set nodata_p 0

if {[file exists $DataFileName]} {

set nodata_p 1
set dataFile [open "$Data..."
("uplevel" body line 116)
invoked from within
"uplevel {

ad_page_contract {
@author doa (mailto:doa@tid.es)
@author sergiog (mailto:sergiog@tid.es)
@creation-date 2005-03-01
} -query {
{type "g..."
(procedure "code::tcl::/web/viaro-demo2/packages/user-tracking/www/commu..." line 2)
invoked from within
"code::tcl::$__adp_stub"
invoked from within
"if { [file exists $__adp_stub.tcl] } {

# ensure that data source preparation procedure exists and is up-to-date
adp_init tcl $__adp_stub
..."
("uplevel" body line 3)
invoked from within
"uplevel {

if { [file exists $__adp_stub.tcl] } {

# ensure that data source preparation procedure exists and is up-to-date
adp_init t..."
(procedure "adp_prepare" line 2)
invoked from within

And the "Info about visits" and "Info about consulted Material" sections in the Users Statistics do not show anything even when a user has created forums, has uploaded files and made several actions in the server.

My copy is a checkout from cvs.openacs HEAD from last week.

Thanks