OC8 fails when converting sqlite3 to mysql

[ghost]

Hello,

I'm trying to migrate my OC8 (8.2.3) sqlite database to mysql.
When doing a php occ db:convert-type --all-apps --clear-schema mysql owncloud 127.0.0.1 owncloud
it fails with:

Continue with the conversion (y/n)? [n] y
oc_activity
 19/19 [============================] 100%
oc_activity_mq
  0/0 [============================]   0%
oc_appconfig
 121/121 [============================] 100%
oc_clndr_calendars
 17/17 [============================] 100%
oc_clndr_objects
 2367/2367 [============================] 100%
oc_clndr_repeat
 2148/2148 [============================] 100%
oc_clndr_share_calendar
    0/0 [============================]   0%
oc_clndr_share_event
    0/0 [============================]   0%
oc_contacts_addressbooks
 6/6 [============================] 100%
oc_contacts_cards
 4439/4439 [============================] 100%
oc_contacts_cards_properties
     1/21598 [>---------------------------]   0%


  [Doctrine\DBAL\Exception\DriverException]                     
  An exception occurred while executing 'INSERT INTO oc_contacts_cards_properties (`id`, `name`, `value  
  `, `preferred`, `userid`, `contactid`) VALUES (?, ?, ?, ?, ?, ?)' with params ["15925", "PHOTO", "\/9  
  j\/4AAQSkZJRgABAQAAAQABAAD\/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxN  
  DQ0Hyc5PTgyPC4zNDL\/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyM  
...

  SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'value' at row 1          



  [Doctrine\DBAL\Driver\PDOException]                                                            
  SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'value' at row 1  



  [PDOException]                                                                                 
  SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'value' at row 1  

Seems as if the contact-photo is to large?!
Any hints how to fix this (despite of deleting dozends of photos)?

Stefan

[MorrisJobke]

cc @DeepDiver1975

[DeepDiver1975]

We had this issue in the past ..... Have to search and look for an answer ...

[ghost]

Didn't get a real solution in the past :-(

[PVince81]

Is this still an issue with recent versions, especially considering that the contact info has moved to core ?

[PVince81]

closing due to lack of feedback. Also, the convert code is currently broken and needs to be rewritten in OC 10: #27075

[lock]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.