[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/session.php on line 1056: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4762: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4764: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4765: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4766: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
### Board mmajunke.de ### :: Thema anzeigen - most visitors
### Board mmajunke.de ###
http://forum.mmajunke.de/

most visitors
http://forum.mmajunke.de/viewtopic.php?f=2&t=249
Seite 1 von 1

Autor:  Bert S [ Di 7. Jul 2015, 21:20 ]
Betreff des Beitrags:  most visitors

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

Autor:  micha [ Mi 8. Jul 2015, 16:46 ]
Betreff des Beitrags:  Re: most visitors

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

Autor:  Bert S [ Mi 8. Jul 2015, 20:25 ]
Betreff des Beitrags:  Re: most visitors

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

Autor:  micha [ Do 9. Jul 2015, 16:47 ]
Betreff des Beitrags:  Re: most visitors


Autor:  Bert S [ Mi 15. Jul 2015, 12:20 ]
Betreff des Beitrags:  Re: most visitors

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

Autor:  micha [ Mi 15. Jul 2015, 17:21 ]
Betreff des Beitrags:  Re: most visitors

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

Autor:  Bert S [ Do 16. Jul 2015, 00:10 ]
Betreff des Beitrags:  Re: most visitors

Hello Michael,

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

Kind regards,

Bert

Autor:  micha [ Do 16. Jul 2015, 15:32 ]
Betreff des Beitrags:  Re: most visitors

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

Autor:  Bert S [ Fr 17. Jul 2015, 09:56 ]
Betreff des Beitrags:  Re: most visitors

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

Seite 1 von 1 Alle Zeiten sind UTC + 1 Stunde
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/