SQLSTATE[22003] | drupal.org

Posted by Nethe on December 27, 2012 at 12:47pm

Hello,

I have a problem with installation of Drupal 7.18

What i am doing?
1. extract all drupal files to folder on my server
2. run http://filesofdrupal.eu
3. Set up the Standard installation profile, clicking next
4. Set the language, clicking next
5. Set up the connection to my database, it's all right and clicking to Save and Continue

Before 6th step, i am getting the fail: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'created' at row 1.

I tried google, Drupal forum.. I found some fixes, patches, etc. but nothing worked. Do you have some tips to fix this problem?

Version of mysql what i am using:
Apache/2.2.22 (Debian)
MySQL libmysql - 5.5.29
PHP info of my server: http://craftzone.eu/phpinfo.php

Thanks a lot, Martin.

Comments

My bet is on this PHP

Posted by Drave Robber on December 27, 2012 at 1:17pm

My bet is on this PHP bug.

Proposed solution: talk to your provider or whoever is responsible for updating PHP.

How did I got it fixed. 1. I

Posted by Ciprian Oancia on May 4, 2013 at 1:00am

How did I got it fixed.
1. I did enabled mysql.log
2. At each atempt to install Drupal I saw that query stops at user insert (due to created collumn)
3. Checked again phpinfo(); related to the time issue and I saw that _SERVER["REQUEST_TIME"] is in microseconds instead of seconds. (php 5.4.14)
4. I did a quick and dirty fix (someone please suggest a better way) by adding in php.ini auto_prepend_file=/somepath/prepend.php and inside that file:
5. restarted apache :)

$_SERVER['REQUEST_TIME_FLOAT'] = time();
$_SERVER['REQUEST_TIME'] = time();

hope this helps you :)

Hi, Is there any further news

Posted by bailey86 on May 20, 2013 at 12:44am

Hi,

Is there any further news on this issue?

Problem found - and a fix

Posted by bailey86 on May 20, 2013 at 11:18am

This looks like it is 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