SQLSTATE[22003] error when installing Commerce Kickstart [#1997946]

After all of the requirements have been met by the installation I am constantly getting the following error message (screenshot attached).

SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'created' at row 1

This is on Linux Debian 7.

Comment	File	Size	Author
	installError.png	24.58 KB	paulricco

Comments

Comment #1

jsacksick commented 19 May 2013 at 08:28

Status:

Active

» Postponed (maintainer needs more info)

http://demo.commerceguys.com/ck/ is using the 2.7 and has been installed successfully, which database management system are you using ?

Comment #2

bailey86 commented 20 May 2013 at 11:27

This looks like it could be related to a bug in the Debian package libapache2-mod-php5filter. I've reported it here:

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=709023

My fix was to install the package libapache2-mod-php5 which then replaced libapache2-mod-php5filter.

In fact the package libapache2-mod-php5 should be used in preference to libapache2-mod-php5filter as on the package page for libapache2-mod-php5filter it even says 'Unless you specifically need filter-module support, you most likely should instead install libapache2-mod-php5.'

This has also been reported as a bug - http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=709027

It could also be related to https://bugs.php.net/bug.php?id=62507