エラー

DBIx::Class::ResultSet::slice(): DBI Exception: DBD::mysql::st execute failed: Duplicate column name 'create_date' [for Statement "SELECT me.comment_id, me.user_id, me.id, me.comment, me.status, me.create_date, me.update_date, me.create_date, me.update_date, comment_img.comment_id, comment_img.image_id, comment_img.id, comment_img.status, comment_img.create_date, comment_img.update_date, img.image_id, img.service_type, img.file_name, img.size, img.path, img.status, img.note, img.create_date, img.update_date, img.user_dir, user.user_id, user.user_name, user.mail_address, user.user_pass, user.status, user.permission, user.last_auth_time, user.hash_key, user.create_date, user.update_date, user.last_login FROM (SELECT me.comment_id, me.user_id, me.id, me.comment, me.status, me.create_date, me.update_date, DATE_FORMAT( me.create_date,'%Y/%m/%d %H:%i' ) AS create_date, DATE_FORMAT( me.update_date,'%Y/%m/%d %H:%i' ) AS update_date FROM tran_topic_comment me LEFT JOIN tran_topic_comment_image comment_img ON comment_img.comment_id = me.comment_id JOIN users user ON user.user_id = me.user_id WHERE ( ( ( comment_img.status = ? OR comment_img.status IS NULL ) AND me.id = ? AND me.status = ? ) ) GROUP BY me.comment_id, me.user_id, me.id, me.comment, me.status, me.create_date, me.update_date ORDER BY me.create_date DESC LIMIT ?) me LEFT JOIN tran_topic_comment_image comment_img ON comment_img.comment_id = me.comment_id LEFT JOIN tran_image img ON img.image_id = comment_img.image_id JOIN users user ON user.user_id = me.user_id WHERE ( ( ( comment_img.status = ? OR comment_img.status IS NULL ) AND me.id = ? AND me.status = ? ) ) ORDER BY me.create_date DESC, comment_img.comment_id" with ParamValues: 0='2601', 1='96', 2='2401', 3=11, 4='2601', 5='96', 6='2401'] at /home/e3dev/www/E3/lib/E3/Controller/Community/Topic.pm line 427

もしよろしければこちらのエラーをにご報告ください。