issue with migrateto21.php

[ma2thieu]

I run into multiple issues with migrateto21.php

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? WHERE id = ?' at line 1' in /var/www/dav/vendor/sabre/dav/bin/migrateto21.php:116

I think $stmt = $pdo->query('UPDATE calendarobjects SET uid = ? WHERE id = ?'); should be $stmt = $pdo->prepare('UPDATE calendarobjects SET uid = ? WHERE id = ?');

Also :
PHP Warning: Missing argument 1 for Sabre\VObject\Component::select()
PHP Notice: Undefined variable: name in /var/www/dav/vendor/sabre/vobject/lib/Component.php on line 219

And anyway isn't $uid always null ?
line 139 : maybe $uid = (string)$uid; should be $uid = (string)$item->UID; ?

[evert]

Hi @ma2thieu ,

I'm going through the full migration process again... this doesn't look too good. Thanks for the report.

[ma2thieu]

Hi @evert
Thank you but I think there is still the issue with $uid being always null
(line 139) $uid = (string) $item->UID;

[evert]

Shit you are right :(

Will have to do another release. Good thing this is not as much of an issue. For now it just means that scheduling will not work well for events that were created before the migration, but it won't break anything.