Projects ⇒ Bugs ⇒ #796: Out of range value adjusted for column ... ⇒ CPG Dragonfly™ CMS
Bug #796 Out of range value adjusted for column ...
Project: Dragonfly 9.0.3 -> 9.3 Category: SQL
Submitted: Saturday, May 13, 2006 (14:24:55) Modified: Monday, May 15, 2006 (07:40:39)
Status: Closed Assigned to:
PHP Version: 5.0.3 HTTPD Server: Apache 1.3

View/Vote Add Comment

by: NanoCaiordo
Description:
------------
Database version: MySQL 5.0.21 with strict mode on ###

While edit/save blocks you will getOn /admin.php?op=blocks&save=5 While executing query "UPDATE cvs_blocks SET title='_SELECTLANGUAGE', content='', url='', bposition='r', active='1', refresh='', time=0, blanguage='', blockfile='block-Languages.php', view='0' where bid='5'" the following error occured: Out of range value adjusted for column 'refresh' at row 1 In: includes/db/db.php on line: 67

This is caused becouse we are updating the "refresh" column with an empty value.

A possible fix could be done in admin/modules/blocks.php#360

$refresh = is_int($_POST['refresh']) ? $_POST['refresh'] : 0;
by: NanoCaiordo
This bug has been fixed in the CVS.

Snapshots of the sources are packaged every 6 hours; this change
will be in the next snapshot. You can grab the snapshot at the
Downloads section.

Thank you for the report, and for helping us to make Dragonfly 9.0.3 -> 9.1 better.

This bug has been fixed in the CVS.

Snapshots of the sources are packaged every 6 hours; this change
will be in the next snapshot. You can grab the snapshot at the
Downloads section.

Thank you for the report, and for helping us to make Dragonfly 9.0.3 -> 9.1 better.
User Info

Welcome Anonymous



(Register)
Community

Support for DragonflyCMS in a other languages:

Deutsch
Español