installed new core version - mysql doesn't match (and upgrading manually doesn't fix it?)

Permalink
Hi guys,

I have a website running 5.2.2.1 which is getting broken. So I did a clean install of 5.6.2.1 on a new server and moved the blocks, themes, etc.

I then cleared out the new MySQL data and put in my old sql file form the old version.

However, when doing so I get the following error:

mysqlt error: [1054: Unknown column 'Blocks.btCachedBlockRecord' in 'field list'] in EXECUTE("select CollectionVersionBlocks.isOriginal, Blocks.btCachedBlockRecord, BlockTypes.pkgID, CollectionVersionBlocks.cbOverrideAreaPermissions, CollectionVersionBlocks.cbDisplayOrder, Blocks.bIsActive, Blocks.bID, Blocks.btID, bName, bDateAdded, bDateModified, bFilename, btHandle, Blocks.uID from CollectionVersionBlocks inner join Blocks on (CollectionVersionBlocks.bID = Blocks.bID) inner join BlockTypes on (Blocks.btID = BlockTypes.btID) where CollectionVersionBlocks.arHandle = 'Main' and CollectionVersionBlocks.cID = '1' and (CollectionVersionBlocks.cvID = '27' or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = '87'")

I then tried to run the upgrade script manually as suggested elsewhere, which seems to complete - but it doesn't do any changes to the mysql, so the error is still there?

Help? :)

Thanks,

Jesper

 
JesperDK replied on at Permalink Reply
Actually I got it wrong. When doing the update script I get the following error:

Warning: require_once(/home/l/i/ftp_lindhardtorg/concrete/libraries/datetime_compat.php): failed to open stream: No such file or directory in /home/l/i/ftp_lindhardtorg/concrete/core/libraries/loader.php on line 30

Fatal error: require_once(): Failed opening required '/home/l/i/ftp_lindhardtorg/concrete/libraries/datetime_compat.php' (include_path='/home/l/i/ftp_lindhardtorg/libraries/3rdparty:/home/l/i/ftp_lindhardtorg/concrete/libraries/3rdparty:/usr/local/phpbin/PEAR/:./') in /home/l/i/ftp_lindhardtorg/concrete/core/libraries/loader.php on line 30