I am trying to move a site from my windows dev server (I used the prefab SilverStripe development package installer) to my production Linux hosting. Production hosting is with GoDaddy (don't blame me! someone else chose it!) and it is a shared linux account, typical of many big web hosting environments.
I have set up the DB and modified my SilverStripe _config.php file appropriately. I can connect to the DB from the command line mysql application using the same details as I have entered in _config.php, and I have imported the sql generated by the mysqldump command on the Windows dev server. I can even see all the tables and their content from the command line mysql app. However, I get the following error when I try and load the site:
FATAL ERROR: DATABASE ERROR: Couldn't run query: SELECT `SiteTree`.*, `UserDefinedForm`.*, `SubscribeForm`.*, `ArticlePage`.*, `StaffPage`.*, `ErrorPage`.*, `GhostPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID LEFT JOIN `SubscribeForm` ON `SubscribeForm`.ID = `SiteTree`.ID LEFT JOIN `ArticlePage` ON `ArticlePage`.ID = `SiteTree`.ID LEFT JOIN `StaffPage` ON `StaffPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (HomepageForDomain = 'test.twizere.org') ORDER BY Sort LIMIT 1 | Table 'twizereorg_ss.SiteTree' doesn't exist
At line 386 in /sapphire/core/model/Database.php
Any ideas? I am volunteering for a charity based in Rwanda, and look at their current website:
So I am keen to get this up for them ASAP. This is my first SS site, so pardon me if the question is rather obvious...
Any help is appreciated.