At this moment I'm trying Tracewatch, I looks like a great application for my web statistics.
I'm trying tracewatch using XAMPP (newest version from Sourceforge) at my local pc.
- Installation in Xampp was no problem.
- Log into Tracewatch: no problem.
- Database connection: no problem.
- Database installation: succesfull.
- I tried to connect a test website, and the counter/ statistics started succesfull.
After that I wanted to login in Tracewatch, but it fails! I can't login anymore...
If I try to login, I get a fault:
- Code: Select all
mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set [2]
File: D:\xampp\htdocs\counter_twatch\base\db\Db.php Line: 319
And below that I see a list of faults (I removed the username and password from these lines):
- Code: Select all
mysql_query( 'SELECT u.id, u.username, if( UNIX_TIMESTAMP() < exp, rnd, '' ), u.exp - UNIX_TIMESTAMP(), g.gid FROM `counter`.twatchuser__u AS u LEFT JOIN `counter`.twatchuser__g AS g ON( u.id = g.uid AND g.appid = 0 ) WHERE u.id = 100', [unknown] )
called in File: D:\xampp\htdocs\counter_twatch\base\db\Db.php Line: 319
ArdeDb->query( 'SELECT u.id, u.username, if( UNIX_TIMESTAMP() < exp, rnd, '' ), u.exp - UNIX_TIMESTAMP(), g.gid FROM `counter`.twatchuser__u AS u LEFT JOIN `counter`.twatchuser__g AS g ON( u.id = g.uid AND g.appid = 0 ) WHERE u.id = 100' )
called in File: D:\xampp\htdocs\counter_twatch\user\db\ArdeDbUser.php Line: 114
ArdeDbUsers->getUser( 100, null, null, null, 0 )
called in File: D:\xampp\htdocs\counter_twatch\user\db\ArdeDbUser.php Line: 90
ArdeDbUsers->getUserById( 100, 0 )
called in File: D:\xampp\htdocs\counter_twatch\user\lib\User.php Line: 236
ArdeUsers->getUserByUnPass( 'xxxxxxxxxxxxxxxx', 'xxxxxxxxxxxxxxxxx' )
called in File: D:\xampp\htdocs\counter_twatch\user\login.php Line: 33
LoginPage->init( )
called in File: D:\xampp\htdocs\counter_twatch\base\lib\Page.php Line: 22
ArdePage->render( object [ArdeXmlPrinter] )
called in File: D:\xampp\htdocs\counter_twatch\user\login.php Line: 100
I allready checked some PHP files and the queries, maybe there is a problem in the query because I see the text: "[unknown]" in the query...
