Hi Garvin,
I am using postgresql and I get many errors in the log like this one:
Jul 22 11:01:27 servix postgres[26074]: [2-1] ERROR: value too long for type character varying(15)
Jul 22 11:01:27 servix postgres[26074]: [2-2] STATEMENT: INSERT INTO serendipity_visitors (sessID,day,time,ref,browser ...
Search found 10 matches
- Tue Jul 22, 2014 11:09 am
- Forum: Plugins
- Topic: serendipity_event_spamblock error
- Replies: 3
- Views: 6057
- Fri Jul 18, 2014 11:05 am
- Forum: Plugins
- Topic: serendipity_event_spamblock error
- Replies: 3
- Views: 6057
serendipity_event_spamblock error
Hello,
In file plugins/serendipity_event_spamblock/serendipity_event_spamblock.php contains the following code:
$q = "CREATE TABLE {$serendipity['dbPrefix']}spamblock_htaccess (
timestamp int(10) {UNSIGNED} default null,
ip varchar(15))";
The declaration ip varchar(15) fails in case IPv6 is ...
In file plugins/serendipity_event_spamblock/serendipity_event_spamblock.php contains the following code:
$q = "CREATE TABLE {$serendipity['dbPrefix']}spamblock_htaccess (
timestamp int(10) {UNSIGNED} default null,
ip varchar(15))";
The declaration ip varchar(15) fails in case IPv6 is ...
- Mon May 13, 2013 7:41 pm
- Forum: Plugins
- Topic: Statistics: number of visitors per week is missing
- Replies: 14
- Views: 21167
Re: Statistics: number of visitors per week is missing
Hi Ian,
I switched day and week visitors around. Week visitors come in my code before day visitors. That seems more logical. That's it.
Code itself is identical.
Regards
Jos
I switched day and week visitors around. Week visitors come in my code before day visitors. That seems more logical. That's it.
Code itself is identical.
Regards
Jos
- Mon May 13, 2013 7:11 pm
- Forum: Plugins
- Topic: Statistics: number of visitors per week is missing
- Replies: 14
- Views: 21167
Re: Statistics: number of visitors per week is missing
Hi all,
See Dif attached.
See Dif attached.
- Mon May 13, 2013 7:17 am
- Forum: Plugins
- Topic: Statistics: number of visitors per week is missing
- Replies: 14
- Views: 21167
Re: Statistics: number of visitors per week is missing
Hi Ian,
Guess what, this morning I looked and the count of weekly visitors is working!
Obviously, it was reset last night (Sunday), so I didn't notice it.
The number of visitors online is also shown now. I did not realize it was there until I loooked at the source code, added a cast necessary for ...
Guess what, this morning I looked and the count of weekly visitors is working!
Obviously, it was reset last night (Sunday), so I didn't notice it.
The number of visitors online is also shown now. I did not realize it was there until I loooked at the source code, added a cast necessary for ...
- Sun May 12, 2013 9:23 pm
- Forum: Plugins
- Topic: Statistics: number of visitors per week is missing
- Replies: 14
- Views: 21167
Re: Statistics: number of visitors per week is missing
Hi Ian,
Sorry, our last posts crossed. I have now tried the Ynj variation with a fresh copy of the original source file, cleared the cache and reloaded.
Sorry to say that the week entry remains blank!
Regards
Jos
Sorry, our last posts crossed. I have now tried the Ynj variation with a fresh copy of the original source file, cleared the cache and reloaded.
Sorry to say that the week entry remains blank!
Regards
Jos
- Sun May 12, 2013 9:01 pm
- Forum: Plugins
- Topic: Statistics: number of visitors per week is missing
- Replies: 14
- Views: 21167
Re: Statistics: number of visitors per week is missing
Hi Ian,
I grepped <div class="stat_weekhvisitors"> and only found it referenced in the statistics_cache.html and serendipity_plugin_statistics.php files, nowhere else.
Same goes for <div class="stat_dayhvisitors"> and that works ok. So I am not sure if this is meaningful.
I tired the two ...
I grepped <div class="stat_weekhvisitors"> and only found it referenced in the statistics_cache.html and serendipity_plugin_statistics.php files, nowhere else.
Same goes for <div class="stat_dayhvisitors"> and that works ok. So I am not sure if this is meaningful.
I tired the two ...
- Sun May 12, 2013 7:00 pm
- Forum: Plugins
- Topic: Statistics: number of visitors per week is missing
- Replies: 14
- Views: 21167
Re: Statistics: number of visitors per week is missing
Hi Ian,
Yes, I already deleted the cache file, it did not work.
For good measure, I also deleted the entire mod_pagespeed cache, it did not work.
See attached picture. (I commented out the conditional if so that you can see the visitor(s) this week line)
I will look at the source code later ...
Yes, I already deleted the cache file, it did not work.
For good measure, I also deleted the entire mod_pagespeed cache, it did not work.
See attached picture. (I commented out the conditional if so that you can see the visitor(s) this week line)
I will look at the source code later ...
- Sun May 12, 2013 6:03 pm
- Forum: Plugins
- Topic: Statistics: number of visitors per week is missing
- Replies: 14
- Views: 21167
Re: Statistics: number of visitors per week is missing
Hi Ian,
I am using PostgreSQL 9.1.9, so CONCAT is not the problem. I did try the || option you suggested, but it did not work. And yes, I am talking about the frontend sidebar.
Visitors in this week is enabled, just as visitors this month and today. Only the last two show up.
Regards,
Jos
I am using PostgreSQL 9.1.9, so CONCAT is not the problem. I did try the || option you suggested, but it did not work. And yes, I am talking about the frontend sidebar.
Visitors in this week is enabled, just as visitors this month and today. Only the last two show up.
Regards,
Jos
- Sun May 12, 2013 3:39 pm
- Forum: Plugins
- Topic: Statistics: number of visitors per week is missing
- Replies: 14
- Views: 21167
Statistics: number of visitors per week is missing
Hi all,
Today I upgraded from 1.6.2 to 1.7.
All is fine, no upgrade problems. :D
However, I have a little issue with the statistics plugin which is still not working in 1.7 (did not work in 1.6.2 either).
So I am reporting it now:
The number of visitors per week is not showing at all. I am ...
Today I upgraded from 1.6.2 to 1.7.
All is fine, no upgrade problems. :D
However, I have a little issue with the statistics plugin which is still not working in 1.7 (did not work in 1.6.2 either).
So I am reporting it now:
The number of visitors per week is not showing at all. I am ...