move from windows to linux host
Permalink
i've moved a concrete 5 installation from windows to linux. got it all connected, db working, ran a script to convert the names to mixed case and now i get the following error when going to the site:
i honestly know nothing about concrete5, just got asked to move the website from a windows based server (that we have shutdown) to a linux host.
any help is greatly appreciated.
thank you.
mysql error: [1054: Unknown column 'Pages.cIsActive' in 'field list'] in EXECUTE("select Pages.cID, Pages.pkgID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cIsActive, Pages.cIsSystemPage, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cPendingAction, cPendingActionUID, cPendingActionTargetCID, cPendingActionDatetime, cCheckedOutUID, cIsTemplate, uID, cPath, Pages.ctID, ctHandle, ctIcon, ptID, cParentID, cChildren, ctName, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PageTypes on (PageTypes.ctID = Pages.ctID) left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = 1")
i honestly know nothing about concrete5, just got asked to move the website from a windows based server (that we have shutdown) to a linux host.
any help is greatly appreciated.
thank you.
Check in your database table Pages for the cIsActive column. See attached.
doesn't exist. should i create it or is it something else ?
what's your current c5 version?
honestly, all i did was copy the files from the windows server and dump the mysql database.
what's the easiest way to find out the version ?
what's the easiest way to find out the version ?
in the updates directory there is 2 directories. 5.4.2.2 and 5.5.1
I can think of 2 possibilities:
a) The database case conversion was not quite complete.
b) The c5 version on Linux was not the same as the version on windows.
a) The database case conversion was not quite complete.
b) The c5 version on Linux was not the same as the version on windows.
a) The database case conversion was not quite complete.
i did an export of the database from the windows mysql server and then imported the file directly into the linux mysql server.
b) The c5 version on Linux was not the same as the version on windows.
as administrator, i copied the files from the windows server to the linux server. everything validated from one server to another, so nothing is missing.
i did an export of the database from the windows mysql server and then imported the file directly into the linux mysql server.
b) The c5 version on Linux was not the same as the version on windows.
as administrator, i copied the files from the windows server to the linux server. everything validated from one server to another, so nothing is missing.
What John was probably referring to is that you need to run case sensitivity migration because the MySQL server on the Windows machine has probably been running in the case insensitive mode.
Please check out this tool:
http://www.concrete5.org/marketplace/addons/database-case-sensitivi...
More about the topic:
http://www.concrete5.org/documentation/how-tos/developers/mysql-dat...
Please check out this tool:
http://www.concrete5.org/marketplace/addons/database-case-sensitivi...
More about the topic:
http://www.concrete5.org/documentation/how-tos/developers/mysql-dat...
