Upgrade from PC 7.0.1 gives error

[espaan]

Hi, I just went from the update of 6.2.0 to 7.0.1, which went flawless, but then upgrading to 8.0.1 gives:

Foutmelding! Kon de 'extensions' module niet laden bij 'upgrade'.
Unknown database type longblob requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it.

Details:

#0 Er heeft zich een uitzondering voorgedaan in C:\Apps\xampp\htdocs\zk136\plugins\Doctrine\lib\vendor\Doctrine\DBAL\Platforms\AbstractPlatform.php, regel 220.
#1 C:\Apps\xampp\htdocs\zk136\plugins\Doctrine\lib\vendor\Doctrine\DBAL\Schema\AbstractSchemaManager.php(628): Doctrine\DBAL\Schema\MySqlSchemaManager->_getPortableTableColumnDefinition(Array)
#2 C:\Apps\xampp\htdocs\zk136\plugins\Doctrine\lib\vendor\Doctrine\DBAL\Schema\AbstractSchemaManager.php(156): Doctrine\DBAL\Schema\AbstractSchemaManager->_getPortableTableColumnList(Array)
#3 C:\Apps\xampp\htdocs\zk136\plugins\Doctrine\lib\vendor\Doctrine\DBAL\Schema\AbstractSchemaManager.php(226): Doctrine\DBAL\Schema\AbstractSchemaManager->listTableColumns('z_mediashare_me...')
#4 C:\Apps\xampp\htdocs\zk136\plugins\Doctrine\lib\vendor\Doctrine\DBAL\Schema\AbstractSchemaManager.php(214): Doctrine\DBAL\Schema\AbstractSchemaManager->listTableDetails('z_mediashare_me...')
#5 C:\Apps\xampp\htdocs\zk136\plugins\Doctrine\lib\vendor\Doctrine\DBAL\Schema\AbstractSchemaManager.php(764): Doctrine\DBAL\Schema\AbstractSchemaManager->listTables()
#6 C:\Apps\xampp\htdocs\zk136\plugins\Doctrine\lib\vendor\Doctrine\ORM\Tools\SchemaTool.php(677): Doctrine\DBAL\Schema\AbstractSchemaManager->createSchema()
#7 C:\Apps\xampp\htdocs\zk136\plugins\Doctrine\lib\vendor\Doctrine\ORM\Tools\SchemaTool.php(655): Doctrine\ORM\Tools\SchemaTool->getUpdateSchemaSql(Array, true)
#8 C:\Apps\xampp\htdocs\zk136\plugins\Doctrine\lib\DoctrineHelper.php(55): Doctrine\ORM\Tools\SchemaTool->updateSchema(Array, true)
#9 C:\Apps\xampp\htdocs\zk136\modules\PostCalendar\lib\PostCalendar\Installer.php(106): DoctrineHelper::updateSchema(Object(Doctrine\ORM\EntityManager), Array)
#10 [internal function]: PostCalendar_Installer->upgrade('7.0.1')
#11 C:\Apps\xampp\htdocs\zk136\system\Extensions\lib\Extensions\Api\Admin.php(1024): call_user_func(Array, '7.0.1')
#12 [internal function]: Extensions_Api_Admin->upgrade(Array)
#13 C:\Apps\xampp\htdocs\zk136\lib\util\ModUtil.php(1091): call_user_func(Array, Array)
#14 C:\Apps\xampp\htdocs\zk136\lib\util\ModUtil.php(1199): ModUtil::exec('Extensions', 'admin', 'upgrade', Array, true, NULL)
#15 C:\Apps\xampp\htdocs\zk136\system\Extensions\lib\Extensions\Controller\Admin.php(721): ModUtil::apiFunc('Extensions', 'admin', 'upgrade', Array)
#16 [internal function]: Extensions_Controller_Admin->upgrade(Array)
#17 C:\Apps\xampp\htdocs\zk136\lib\util\ModUtil.php(1091): call_user_func(Array, Array)
#18 C:\Apps\xampp\htdocs\zk136\lib\util\ModUtil.php(1173): ModUtil::exec('Extensions', 'admin', 'upgrade', Array, false, NULL)
#19 C:\Apps\xampp\htdocs\zk136\index.php(78): ModUtil::func('Extensions', 'admin', 'upgrade', Array)
#20 {main}

Can I do something manual or is there something specific in the upgrade script ?

[craigh]

lol - can you tell me what that says in English?

longblob should not be there. they maybe need to be manually converted to longetxt, I cannot remember. I know Doctrine totally blows up if there are blobs.

[espaan]

:-) you can read to the dutch mambo jambo can't you ?

I don't see any longblobs in the db after upgrade to 701, and I don't see any reference to longblobs in 801, so where it comes from. Don't know. I will try on the server, this was locally on 'a' version of xampp. Maybe MAMP at home will do different or the server ? I'll let you know.

Oh and BTW from 620 to 701 went perfect :+1:

[craigh]

remember the blob can be in ANY table (not just PC). look everywhere.

[espaan]

Hi, it was indeed the longblob in another table (old mediashare table). I did the upgrade once again on the server from 6.2 to 7.0.1 and then to 8.0.1. Now it works fine (after updating the long blob of course)

[craigh]

great!