### Board mmajunke.de ###

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

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

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

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 )


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 ?

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

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

Hello Michael,

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

Kind regards,

Bert

Hi Bert,

not so fast

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

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