VTS Backend Probs

[DrubusCulubus]

I installed VTS Mod but I can not use the backend. The dBase is filling up but that is it.

Top Operating System
Name Total Percents
phpOpenTracker Error: Access denied for user: 'snl23019@%' to database 'snl23019'

Remark: The user name is NOT snl23019@% but snl23019 so where the @% is coming from....?

Anyone?

[rk]

phpOpenTracker Error: Access denied for user: 'xxx@%' to database 'xxx'

Sorry, no help, but i have the same problem. I think it doesn't work after update to RC4

[DeXXus]

I have not messed with that mod but...
The only place I find that character combination (@%) is in the "/include/inc_ext/phpmailer/class.phpmailer.php" file:

$result .= sprintf("Message-ID: <%s@%s>%s", $uniq_id, $this->ServerHostname(), $this->LE);

[nekket]

Ich habe folgendes Problem:
Ich habe eine Homepage mit VTS installiet, da lief er ohne irgendein problem. Jetzt ist diese Homepage auf einen neuen Server gezogen, alle Einstellungen sind entsprechend geändert, die Homepage und das Backend laufen einwandfrei.
Aber:
Das VTS Modul funktioniert nicht mehr.
Es zeigt folgendes an:


Wie kann das sein?
Er liest die Gesamthits aus, aber die Details nicht mehr. Wenn ich die Datenbank-Einstellungen in der Datei 'phpOpenTracker.php' im Conf Verzeichnis des phpOpentrackers manuell verfälsche, kommt eine Meldung, dass er gar ni cht mehr zu Datenbank zugreifen kann; also funktioniert der Zugriff auf die Datenbank eigentlich schon.

Ist das ein problem mit Dateirechten oder woran kann das liegen?!

[roliko]

I have this problem too ...
Does nobody have a solution for this problem.

Roland

[Pappnase]

hello

maybe drop a pm to frold!
sorry i had no other idea for that!

[Mironas]

It was problem with mysql TEMPORARY TABLEs creation on my hosting ("CREATE TEMPORARY TABLE ..." statement)

I changed "CREATE TEMPORARY TABLE" to "CREATE TABLE"

in:

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

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

and it helped.

[jkn]

hey mironas,
thx for your help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! this solve all my problems!

jk

[nmd_inc]

had same problem as "DrubusCulubus"

phpOpenTracker Error: Access denied for user: 'XXX@YYY' to database 'ZZZ'

When I activated

Code: Select all

$PHPOPENTRACKER_CONFIGURATION['debug_level'] = 2;

in "conf/phpOpenTracker.php" it told me

Code: Select all

OpenTracker Error: Table 'ZZZ.pot_temporary_table' doesn't exist

I contacted my Host and he found out, that I didn't have sufficient privileges to use temporary tables and he changed that - now it works like a charm..

maybe an issue of different PHP versions? I use 4.3.8

sure, similar solution (is it as good?) is to change:

changed "CREATE TEMPORARY TABLE" to "CREATE TABLE"

[CodexX]

It was problem with mysql TEMPORARY TABLEs creation on my hosting ("CREATE TEMPORARY TABLE ..." statement)

I changed "CREATE TEMPORARY TABLE" to "CREATE TABLE"

in:

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

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

and it helped.

WOW!!!

never would have thought that something like that could help.

had the same problem with "access denied" without any reason (i haven't changed anything) and after trying out your tip it works again!
thanks a lot!

[sezmen]

Ist aus einem anderen Thread - ich kopiere es aber hierhin damit man es leichter findet:

Don't know if anybody already answered this problem, but it has to do with mySQL privileges. Basically, the database user does not have permission to create temporary tables. This can be solved by a GRANT statement, like:

GRANT CREATE TEMPORARY TABLES ON usr_web33_1.* TO web33@localhost; "

Kapiert? Also - in z.B. PhpMyAdmin dem user Rechte für CREATE TEMPORARY TABLES für diese Datenbank vergeben und alles funktioniert weider PRIMA !!!!!!!!


SezMen