Page 1 of 1
VTS Backend Probs
Posted: Tue 1. Jun 2004, 12:11
by 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?
Re: VTS Backend Probs
Posted: Tue 1. Jun 2004, 12:38
by rk
DrubusCulubus wrote:
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
Posted: Tue 1. Jun 2004, 14:32
by 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);
Posted: Wed 30. Jun 2004, 17:07
by 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?!
VTS - problems
Posted: Thu 8. Jul 2004, 14:29
by roliko
I have this problem too ...
Does nobody have a solution for this problem.
Roland
Posted: Thu 8. Jul 2004, 14:33
by Pappnase
hello
maybe drop a pm to frold!
sorry i had no other idea for that!
Re: VTS - problems
Posted: Sat 11. Sep 2004, 16:34
by 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.
Posted: Tue 14. Sep 2004, 12:36
by jkn
hey mironas,
thx for your help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! this solve all my problems!
jk
Re: VTS Backend Probs
Posted: Wed 22. Sep 2004, 21:27
by nmd_inc
had same problem as "DrubusCulubus"
DrubusCulubus wrote: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"
Re: VTS - problems
Posted: Sun 8. May 2005, 15:09
by CodexX
Mironas wrote: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!
Hier ist die ECHTE Lösung des Problems
Posted: Fri 7. Oct 2005, 16:46
by 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