#318 Error during migration to MySQL

v2.0.4
closed-fixed
Andrew Veitch
Migration (40)
8
2005-12-11
2005-11-23
Ron Goodwin
No

I have installed MySQL server 4.1.11. When I select
migrate the tables are created then I get a blank
screen with the following line:

Invalid integer value for id

When I look at the tables, only the mm_ticket_index
table has an entry (one single entry with an id and
null for the other 2 fields).

Any ideas?

Discussion

  • Kevin Campbell
    Kevin Campbell
    2005-11-23

    Logged In: YES
    user_id=1241761

    Ron,

    Could you give me a a copy of the traceback from the error
    log under the ZMI? That will let us see what is causing the
    issue. This might be a dataset issue - there were some
    relatively unconstrained values in the zodb in 1.1, which
    are occasionally causing issues migrating to 2.0.

    Regards,
    Kevin

     
  • Kevin Campbell
    Kevin Campbell
    2005-11-23

    • priority: 5 --> 8
    • assigned_to: nobody --> kevca
     
  • Ron Goodwin
    Ron Goodwin
    2005-11-24

    Logged In: YES
    user_id=838577

    Traceback as requested:

    Traceback (innermost last):
    Module ZPublisher.Publish, line 101, in publish
    Module ZPublisher.mapply, line 88, in mapply
    Module ZPublisher.Publish, line 39, in call_object
    Module Products.MailManager.migration, line 319, in migrate
    Module Shared.DC.ZRDB.DA, line 441, in __call__
    - <FSZSQLMethod instance at 411b7b30>
    Module DocumentTemplate.DT_String, line 474, in __call__
    Module Shared.DC.ZRDB.sqlvar, line 111, in render
    ValueError: Invalid integer value for <em>id</em>

     
  • Logged In: YES
    user_id=12789

    Hi,

    I'm afraid the fix for this bug has not made it into the latest
    release. This ticket is being updated to indicate that it's
    still an open problem with the the current version.

    We will get around to fixing it soon, though!

    Regards,

    MailManager Development Team.

     
    • milestone: 539458 --> v2.0.4
     
  • Ron Goodwin
    Ron Goodwin
    2005-12-06

    Logged In: YES
    user_id=838577

    Well, I am very disappointed, considering I have been
    waiting since being promised a MySQL version in May 2005.

    The latest 2.0.4 release announcement would indicate nothing
    is going to happen before Xmas.

     
  • Andrew Veitch
    Andrew Veitch
    2005-12-11

    Logged In: YES
    user_id=753066

    Fixed.

    This was an issue were getNextMessageId.zsql returned a 'null' under MySQL
    instead of a 0.

     
  • Andrew Veitch
    Andrew Veitch
    2005-12-11

    • assigned_to: kevca --> aveitch
    • status: open --> closed-fixed