Out of range value adjusted for column icq [message #32440] |
Wed, 28 June 2006 19:54 |
aigumnov
Messages: 2 Registered: June 2006
Karma:
|
Junior Member |
|
|
"Out of range value adjusted for column icq" message appears during forum data export/import.
Source system: FUDForum 2.7.5, MySQL 4.1.11 on Debian Linux
Destination system: FUDForum 2.7.5, MySQL 5.0.22 on Windows 2000.
I made the forum datadump on source system, then tried to import it on another box. The CREATE TABLE statement for <fud-prefix>users contains "icq bigint" field definition. That is nullable big integer value, default is null. However, the insert statement generated during datadump looks like "insert into ... (...icq...) values (..., '', ...)". Here, the FUDForum tries to insert the NULL (empty) value for bigint column as empty string.
I have not tried, does this work on MySQL 4.1.11 or not, but the import statement fails on MySQL 5.0.22 on Windows system with the above specified error, so the 'users' table stays empty. Maybe I'm doing something wrong.
Personally, I solved this by patching the sql-structure in datadump (defined column 'icq' as varchar instead of bigint) and then reverting changes in database directly.
|
|
|