0000662: MySQL Query Error Incorrect date value: '' for column 'user_startdate' at row 1 in user_profile_edit.php @ line 454 - SiT! Bugs

SiT! Bugs

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

ID

Project

Category

View Status

Date Submitted

Last Update

0000662

SiT!

profiles

public

2009-04-23 09:13

2009-08-16 14:38

Reporter

DimKir

Assigned To

ivan

Priority

normal

Severity

crash

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS

OS Version

Product Version

3.45

Target Version

3.50

Fixed in Version

3.50

Summary

0000662: MySQL Query Error Incorrect date value: '' for column 'user_startdate' at row 1 in user_profile_edit.php @ line 454

Description

Application Error [256]
MySQL Query Error Incorrect date value: '' for column 'user_startdate' at row 1 in user_profile_edit.php @ line 454 trigger_error()

Application Warning [512]
!Error while updating users table in user_profile_edit.php @ line 480 trigger_error()

Additional Information

I change code in user_profile_edit.php (line 340):
Before change:
else $startdate = '';
After change:
else $startdate = date('Y-m-d',0);

Tags

No tags attached.

Relationships

Notes
(0000975) ivan (administrator) 2009-04-23 12:19	Thanks once again! Fix committed in trunk svn r5348

(0001574) ivan (administrator) 2009-08-16 14:38	Released in 3.50rc1

Issue History
Date Modified	Username	Field	Change
2009-04-23 09:13	DimKir	New Issue
2009-04-23 12:19	ivan	Note Added: 0000975
2009-04-23 12:19	ivan	Assigned To	=> ivan
2009-04-23 12:19	ivan	Status	new => resolved
2009-04-23 12:19	ivan	Resolution	open => fixed
2009-04-23 12:19	ivan	Fixed in Version	=> Current SVN
2009-04-23 12:19	ivan	Target Version	=> 3.50
2009-08-16 13:17	ivan	Fixed in Version	Current SVN => 3.50
2009-08-16 14:38	ivan	Note Added: 0001574
2009-08-16 14:38	ivan	Status	resolved => closed

Copyright © 2000 - 2021 MantisBT Team