Results 1 to 2 of 2

Thread: MySQL error

  1. #1
    Join Date
    Dec 2005
    Posts
    6

    Smile Unanswered: MySQL error

    I am doing a data synchronization and just before I performed a structure synch so that they would be the same. Then I get the error below 5 times in a row, it rolls back, and continues with the next table. I've checked this table on both servers for any NULL values and the query can't find any on either table.

    [Err] [Dsy] [FTargetSrvX] mysql_real_query error: Column 'custom_color_fee' cannot be null

  2. #2
    Join Date
    Oct 2003
    Posts
    13
    If you're sure there are no null values anywhere there, check to make sure that it is including that column in the synchronization. Omitting the value might assume NULL and cause that error.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •