### Board mmajunke.de ###

Board zu Themen der Website www.mmajunke.de
Aktuelle Zeit: Mo 20. Nov 2017, 14:47

Alle Zeiten sind UTC + 1 Stunde




Ein neues Thema erstellen Auf das Thema antworten  [ 9 Beiträge ] 
Autor Nachricht
 Betreff des Beitrags: most visitors
Ungelesener BeitragVerfasst: Di 7. Jul 2015, 21:20 
Offline
Beobachter
Beobachter

Registriert: Di 7. Jul 2015, 11:39
Beiträge: 5
I have installed visitorcounter in Joomla!3.4.3 and installing worked well. The counter also works well except for the day with the highest number of visitors. When I set "Show Day with highest Visitors" to yes I get the following message: "1146 - Table 'DBxxxxx.bsbk_mod_vvisit_counter_memo' doesn't exist SQL=select valMaxVisits val, valMaxVisitsDay day FROM bsbk_mod_vvisit_counter_memo where counter = 'viscntr'" (I shortened the name of the dbbase table "vvisitorcounter" to "viscntr" in a second install). I looked into my database and could only find the tables "bsbk_viscntr" and "jos_mvc_iptocountry". So the table "bsbk_mod_vvisit_counter_memo" was not made.

For the rest the module works fine. But should like to use "Show Day with highest Visitors" also. Is there a solution for this problem? I found to threads but thse did not help me solving the prblem.

Kind regards,

Bert S


Nach oben
 Profil  
Mit Zitat antworten  
 Betreff des Beitrags: Re: most visitors
Ungelesener BeitragVerfasst: Mi 8. Jul 2015, 16:46 
Offline
Moderator
Moderator
Benutzeravatar

Registriert: Di 4. Mai 2010, 18:44
Beiträge: 639
Wohnort: Hennigsdorf
Hi Bert,

the tables you find:
- "bsbk_viscntr" -> the name "viscntr" comes from modul parameter "table-name" ( each counter-modul can have own data-table , you can have more than one counter modul )
- "jos_mvc_iptocountry" -> the Ip to Country 'Database', is created first time if you use IP2Country-Feature

Have you changed the DB-Joomla-Prefix from jos_ to bsbk_ ?

The memory table have allways this name:
"Modulname" + "_memo"
( e.g. "jos_mod_vvisit_counter_memo" )

I not know about a problem with this name, it works without problems on my systems.


Which MySQL-Version you have ? Can be MySQL changed again some things in newer version ;)

Best Regards,
Michael


Nach oben
 Profil  
Mit Zitat antworten  
 Betreff des Beitrags: Re: most visitors
Ungelesener BeitragVerfasst: Mi 8. Jul 2015, 20:25 
Offline
Beobachter
Beobachter

Registriert: Di 7. Jul 2015, 11:39
Beiträge: 5
Dear Michael,

Thank you for your quick response. Yes, I have changed the prefix from jos_ to bsbk_ when installing Joomla! 3. The first time I installed the visitorcounter module I did not change the name, the second time I did, because I misunderstood a thread on a topic concerning the missing table. But both times there were only two tables installed (first time bsbk_vvisitor_counter, second time bsbk_viscntr and both times the jos_mvc_iptocountry). Both times I did not see a bsbk_mod_vvisit_counter_memo in my database. The mysql version is 5.5.44-log , php version 5.3.29.

I shortened the name from vvisitor_counter to viscntr because from a thread (sorry, I cannot find which one it was) I understood the name of the table became too long.

Kind regards,

Bert S


Nach oben
 Profil  
Mit Zitat antworten  
 Betreff des Beitrags: Re: most visitors
Ungelesener BeitragVerfasst: Do 9. Jul 2015, 16:47 
Offline
Moderator
Moderator
Benutzeravatar

Registriert: Di 4. Mai 2010, 18:44
Beiträge: 639
Wohnort: Hennigsdorf
Hi Bert,

hmmm.. this versions should works without problems.

To ensure that we not have a database problem, can you please try to create the table manually ?

Execute following SQL Statement e.g. with phpmyadmin :
( Replace "jos" with your prefix )
Code:
CREATE TABLE IF NOT EXISTS jos_mod_vvisit_counter_memo (
    counter varchar(240) NOT NULL, lastMaxPerDay DATE NULL DEFAULT NULL ,
    valMaxVisits INT NULL DEFAULT NULL, valMaxVisitsDay int NULL DEFAULT NULL, lastMaxVisits DATETIME NULL ,
    PRIMARY KEY (counter) ) ENGINE=MEMORY;


Hint:
the counter should create this _memo table first time if he is called with enabled parameter "show_highest_visitors..". If the mysql-server is restarted the table will automatictly deleted. The counter re-create it like before..

Greetings
Micha

Ps.: you used counter version : mod_vvisit_counter_2_0_4_j3.zip ?


Nach oben
 Profil  
Mit Zitat antworten  
 Betreff des Beitrags: Re: most visitors
Ungelesener BeitragVerfasst: Mi 15. Jul 2015, 12:20 
Offline
Beobachter
Beobachter

Registriert: Di 7. Jul 2015, 11:39
Beiträge: 5
Hallo Michael,

Sorry for not reacting, have had a little bike incident, so was away for few days. I am not too familiar with mysql. Don't know where to implement the "CREATE TABLE ..."code. In a php-page or somewhere in the code of the Visitor Counter module?

Kind regards


Nach oben
 Profil  
Mit Zitat antworten  
 Betreff des Beitrags: Re: most visitors
Ungelesener BeitragVerfasst: Mi 15. Jul 2015, 17:21 
Offline
Moderator
Moderator
Benutzeravatar

Registriert: Di 4. Mai 2010, 18:44
Beiträge: 639
Wohnort: Hennigsdorf
Hi Bert,

no problem :)

Wich tools you used for looking into database ? PHPMYADMIN ?.. Inside this Tool you should can find a Tab "SQL" - this is the place where you can execute some SQL-Statements.

Greetings
Micha


Nach oben
 Profil  
Mit Zitat antworten  
 Betreff des Beitrags: Re: most visitors
Ungelesener BeitragVerfasst: Do 16. Jul 2015, 00:10 
Offline
Beobachter
Beobachter

Registriert: Di 7. Jul 2015, 11:39
Beiträge: 5
Hello Michael,

Thank you for your great help and the splendid Visitor Counter! Your advise solved the problem!

Kind regards,

Bert


Nach oben
 Profil  
Mit Zitat antworten  
 Betreff des Beitrags: Re: most visitors
Ungelesener BeitragVerfasst: Do 16. Jul 2015, 15:32 
Offline
Moderator
Moderator
Benutzeravatar

Registriert: Di 4. Mai 2010, 18:44
Beiträge: 639
Wohnort: Hennigsdorf
Hi Bert,

not so fast :D

These type of table is allways deleted if your server restart. The question is: why you can create a memory-table with help of a sql-tool, but not with the php-code ?

The easiest solution will be to create the table manualy but not as type "memory". So the problem is fixed.

Hmmm.. please inform me whether you have some trouble after a restart. If so, then we make the fix. If no problems after restart it seems you had a temporary problem, what ever ;)

Greetings,
Micha


Nach oben
 Profil  
Mit Zitat antworten  
 Betreff des Beitrags: Re: most visitors
Ungelesener BeitragVerfasst: Fr 17. Jul 2015, 09:56 
Offline
Beobachter
Beobachter

Registriert: Di 7. Jul 2015, 11:39
Beiträge: 5
Hello Michael,

I waited with an answer, so I could see if it still worked. It does! So far it looks like the problem has been solved.

So thank you again!

Kind regards,

Bert


Nach oben
 Profil  
Mit Zitat antworten  
Beiträge der letzten Zeit anzeigen:  Sortiere nach  
Ein neues Thema erstellen Auf das Thema antworten  [ 9 Beiträge ] 

Alle Zeiten sind UTC + 1 Stunde


Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 3 Gäste


Du darfst keine neuen Themen in diesem Forum erstellen.
Du darfst keine Antworten zu Themen in diesem Forum erstellen.
Du darfst deine Beiträge in diesem Forum nicht ändern.
Du darfst deine Beiträge in diesem Forum nicht löschen.
Du darfst keine Dateianhänge in diesem Forum erstellen.

Suche nach:
Gehe zu:  
cron
Impressum
Powered by phpBB

Deutsche Übersetzung durch phpBB.de