Forums

Moving site issues

Permalink
Hi guys,

So I followed the instructions in the Move a website Guide (http://documentation.concrete5.org/developers/installation/moving-a-site). Exported and imported the DB successfully (although had to remove the following bit from my sql export file for it to load: 
CREATE DATABASE IF NOT EXISTS `mydatabase` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `mydatabase`;


I then FTP'd all my files (empty updates and cache folders) to the webserver and changed the permissions for the files specified under "Move The Files" of the Guide so its Owner, Group and Public permissions are all Read, Write and Execute.

I then updated the application/config/database.php and /database.php file with the new DB server, username, password and name.

When I navigate to the new site via a browser, I can see concrete5 is there but get the following error:
An unexpected error occurred.
An exception occurred while executing 'select pkgID, pkgName, pkgIsInstalled, pkgDescription, pkgVersion, pkgHandle, pkgDateInstalled from Packages where pkgIsInstalled = ? order by pkgID asc' with params [1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'website.Packages' doesn't exist


What on earth does this mean? Is it an issues with the DB? From what I understand it looks like there is a table missing but I checked and all my DB tables imported - they are all there?

Any help will be much appreciated.

Thanks,
Choppie
Choppie
 
Gondwana replied on at Permalink Reply
Gondwana
This could be a caplitalisation issue. I had such problems moving from a XAMPP installation on Windows to a linux host.
MrKDilkington replied on at Permalink Best Answer Reply
MrKDilkington
Hi Choppie,

I believe Gondwana is correct and this is a database case issue.

Here is a related discussion:
https://www.concrete5.org/community/forums/5-7-discussion/database-e...

You can use the Database Migration add-on by ramonleenders to correct this:
https://www.concrete5.org/marketplace/addons/database-migration/...
Choppie replied on at Permalink Reply
Choppie
Update: I can see the "missing" DB table now. Cleared my browser cache. Not sure why this would make a difference but seemed to have worked. Weird.

------------------------------------------------------------------------------------------------------

@Gondwana and @MrKDilkington

Thank you, this is very helpful! I've started updating my DB tables to CamelCase.

And this seems to be getting concrete5 moved past the error, until I get to the next table and so forth.

The only weird thing now is that it says it can't find a table which I can't see in my list of tables in MyPHPAdmin either. Yet when I try to import the table again it says 
SQL query:
--
-- Dumping data for table `treenodetypes`
--
INSERT INTO  `treenodetypes` (  `treeNodeTypeID` ,  `treeNodeTypeHandle` ,  `pkgID` ) 
VALUES ( 1,  'group', 0 ) , ( 2,  'topic_category', 0 ) , ( 3,  'topic', 0 ) ;
MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY


Does this mean that the table already exists? If so, why can't I see all the tables on my webserver?

Thanks,
Choppie