Ticket #2175 (closed defect (bug): worksforme)

Opened 3 years ago

Last modified 2 years ago

mySQL 5, PHP5 : Cannot save a post

Reported by: Podz Assigned to: anonymous
Priority: normal Milestone:
Component: Administration Version: 2.0
Severity: normal Keywords:
Cc:

Description

Possible bug report...

Just upgraded to MySQL 5, PHP5, and WP 2.0 on an IIS 6 box. So far so good, however, when I try and create a new entry in WP, I must click "post" before I can click "save". If I click "save", I get this:

WordPress database error: [Incorrect datetime value: for column 'post_date' at row 1]

Should I be able to save here? Should the save button maybe be disabled until the post has actually been submitted?

http://wordpress.org/support/topic/53655?replies=1

Attachments

ignore.diff (1.1 kB) - added by ryan on 12/31/05 21:44:56.
Now with IGNORE

Change History

12/31/05 21:27:22 changed by ryan

I think this is due to strict mode enforcing NO_ZERO_DATE.

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

12/31/05 21:35:33 changed by ryan

MAybe use INSERT IGNORE and UPDATE IGNORE for posts since we really do want a zero date.

12/31/05 21:44:56 changed by ryan

  • attachment ignore.diff added.

Now with IGNORE

12/31/05 22:36:13 changed by ryan

[3386]

01/06/06 01:31:16 changed by ryan

  • milestone changed from 2.1 to 2.0.1.

01/13/06 22:17:55 changed by ryan

I think we nailed this one, but we need confirmation. Resolving for now. Reopen if it's still a problem.

01/13/06 22:18:42 changed by ryan

  • status changed from new to closed.
  • resolution set to fixed.

02/04/06 03:05:45 changed by JamesP

  • status changed from closed to reopened.
  • resolution deleted.

I tried numerous times to get this working on the new version and I have had absolutley no luck. The situation is the same, MySQL 5 on IIS 6 / Windows Server 2003 Standard. I also don't get an error message.

I was upgrading from an older version of the backend database (I think it was Wordpress version 1.2 or 1.5). I followed the instructions for upgrading and then some to no avail. I download the brand new Wordpress 2.0.1 version, and used the upgrade function from that; however, it still didn't work.

Not sure if this is the same issue, or an issue with the actual upgrade script.

09/20/06 20:53:12 changed by foolswisdom

  • status changed from reopened to closed.
  • resolution set to worksforme.
  • milestone deleted.

Hi JamesP,

This ticket has not been updated in 7 months. Is there still an issue? How did you resolve the issue?

Marking WORKSFORME without testing for now, but please do update if there is more details to this story.

Thank you, Lloyd

09/21/06 11:20:30 changed by Viper007Bond

Confirmed "works for me". Running both MySQL 5 and PHP 5 on my sit and local machine and WP 1.5.2, WP 2.0.4, and latest SVN all work for me just fine.