Two different date formats in the same sql sentence (insert into wp_posts...) (1 post)

  1. Alvaro V
    Posted 3 years ago #

    Hi. I just started with this world of wordpress and finally I made run WordPress on a Windows Server - IIS - PHP - SQL Server.
    Everything seems to work fine except errors as I introduce new posts.
    With debug mode turned on I see that the problem is that in one query is using two different date formats, so the SQL Server rejects the judgment.
    Windows Server, Sql Server and WordPress are Spanish version.

    My intention is to find the place in the source code where you set the format of dates that go wrong, to correct them and make out well.

    Any one can help me please?. Why 'post_date_gmt' has Y/d/m format? Thank you.

    This is the SQL statement that causes the error

    INSERT INTO wp_posts (post_author,post_date,post_date_gmt,post_content,post_content_filtered,post_title,post_excerpt,post_status,post_type,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_parent,menu_order,guid) VALUES (1, N'2012-10-30 11:52:56', N'2012-30-10 10:52:56', N'2012-30-10 10:52:56', N'', N'Borrador automático', N'', N'auto-draft', N'post', N'open', N'open', N'', N'', N'', N'', N'2012-10-30 11:52:56', N'2012-30-10 10:52:56',0,0, N'2012-30-10 10:52:56')

Topic Closed

This topic has been closed to new replies.

About this Topic