MySQL Error
-
Hi π
I have a little problem inserting comments by users(or bots ?:>).
I have mysql set to STRICT. When cx inserting comment with very long “Website” like “http://wordpress.comhttp://wordpress.comhttp://wordpress.comhttp://wordpress.comhttp://wordpress.comhttp://wordpress.com” The mysql crash and I got error in logs
WordPress database error Data too long for column ‘comment_author_url’ at row 1 for query INSERT INTO
wp_comments(comment_post_ID,comment_author,comment_author_email,comment_author_url,comment_author_IP,comment_date,comment_date_gmt,comment_content,comment_karma,comment_approved,comment_agent,comment_type,comment_parent,user_id) VALUES …..My wp_comments table have varchar(200) type but this shoudl be check by regexp {0,200}(?).
I hope this will be fixed in new release. Tx!
(sorry if wrong category or duplicated :\)
The topic ‘MySQL Error’ is closed to new replies.