FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Out of range value adjusted for column icq
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Out of range value adjusted for column icq [message #32440] Wed, 28 June 2006 15:54 Go to next message
aigumnov   Russian Federation
Messages: 2
Registered: June 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
"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. Confused Rolling Eyes

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.
Re: Out of range value adjusted for column icq [message #32450 is a reply to message #32440] Thu, 29 June 2006 19:19 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Fixed in CVS, here is the patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=11507


FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: windows-1251 (Cyr) & MySQL 4.1
Next Topic: loosing lang parameters in wikipedia tag
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 10:51:42 EDT 2019

Total time taken to generate the page: 0.00599 seconds