Error: SQLSTATE[22003]: Numeric value out of range: 1264
Development and Programming
Trying to update an old website from EE 4.3.1 to latest 6.x and getting the following error.
Done some Googling but haven’t found anything that matches this issue. Any ideas/advice appreciated.
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'edit_date' at row 1:
ALTER TABLE `exp_comments` CHANGE `edit_date` `edit_date` int(10)
ee/legacy/database/drivers/mysqli/mysqli_connection.php:114
Stack Trace: Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query('ALTER TABLE `ex...')
#1 ee/legacy/database/DB_driver.php(261): CI_DB_mysqli_driver->_execute('ALTER TABLE `ex...')
#2 ee/legacy/database/DB_driver.php(176): CI_DB_driver->simple_query('ALTER TABLE `ex...')
#3 ee/legacy/database/DB_forge.php(332): CI_DB_driver->query('ALTER TABLE `ex...')
#4 ee/legacy/libraries/Smartforge.php(236): CI_DB_forge->modify_column('comments', Array, Array)
#5 ee/ExpressionEngine/Addons/comment/upd.comment.php(266): Smartforge->modify_column('comments', Array)
#6 ee/installer/controllers/wizard.php(1892): Comment_upd->update('2.1')
#7 ee/installer/controllers/wizard.php(1259): Wizard->update_modules()
#8 ee/installer/controllers/wizard.php(283): Wizard->do_update()
#9 [internal function]: Wizard->_remap('do_update', Array)
#10 ee/ExpressionEngine/Core/Core.php(266): call_user_func_array(Array, Array)
#11 ee/ExpressionEngine/Core/Core.php(122): ExpressionEngine\Core\Core->runController(Array)
#12 ee/ExpressionEngine/Boot/boot.php(161): ExpressionEngine\Core\Core->run(Object(ExpressionEngine\Core\Request))
#13 public_html/system/index.php(144): require_once('...')
#13 public_html/system/index.php(144): require_once('...')
I think the edit_date column would be expecting a UNIX timestamp, e.g. 1731361991. Your error makes it seem like the edit_date column literally has ‘1264’, when it should be may more digits. “Out of range” could mean just that!
Are you able to show an example of the time of data you have in your edit_date table?
Thanks for the reply. I ended up deleting the offending row and it worked.
Good catch on deleting the problematic row! That’s often a quick fix when you’re mid-upgrade.
At https://nocramming.com/review/trustmypaper you can learn more about the popular service for completing academic assignments. The review helps to understand how convenient it is for students, what types of assignments can be ordered, and how the selection of an author for a specific topic is carried out. Prices, the discount system, and the privacy policy are analyzed in detail, which makes the review useful for anyone who wants to protect themselves from unscrupulous performers.