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 used. This should be at least varchar(45) as specified elsewhere.
Regards
Jos
serendipity_event_spamblock error
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: serendipity_event_spamblock error
Hi!
Actually this is more due to "compatibility" or "legacy" reasons. Later on in that code you should see an ALTER TABLE statement that should change this to varchar(45)!
Did this not work in your install? Then we should check how that happens, maybe there's an SQL compatibility issue.
Regards,
Garvin
Actually this is more due to "compatibility" or "legacy" reasons. Later on in that code you should see an ALTER TABLE statement that should change this to varchar(45)!
Did this not work in your install? Then we should check how that happens, maybe there's an SQL compatibility issue.
Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Re: serendipity_event_spamblock error
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,ip) values ('9m3qafst07u04rvel1340jq2f6', '2014-07-22', '09:01', 'unknown', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:30.0) Gecko/20100101 Firefox/30.0', 'xxx:xxx:xxx:xxx:xxx:xxx:xxx:xxx').
I have some time this week and I will try to fix the postgresql errors.
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,ip) values ('9m3qafst07u04rvel1340jq2f6', '2014-07-22', '09:01', 'unknown', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:30.0) Gecko/20100101 Firefox/30.0', 'xxx:xxx:xxx:xxx:xxx:xxx:xxx:xxx').
I have some time this week and I will try to fix the postgresql errors.
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: serendipity_event_spamblock error
Hi!
Ah, I suppose then the SQL we use to alter the table was not compatible with pgsql - we have added a switch to our code recently, but maybe when you installed the plugin, that wasn't the case yet.
Try to execute this SQL:
does it work, or do you get errors?
HTH,
Garvin
Ah, I suppose then the SQL we use to alter the table was not compatible with pgsql - we have added a switch to our code recently, but maybe when you installed the plugin, that wasn't the case yet.
Try to execute this SQL:
Code: Select all
ALTER TABLE serendipity_spamblocklog ALTER COLUMN ip TYPE VARCHAR(45)
ALTER TABLE serendipity_spamblock_htaccess ALTER COLUMN ip TYPE VARCHAR(45)
HTH,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/