• 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.