Hi,
I got SS up and running on my dev machine, tagged in SVN and doing automated deploys via Capistrano to my staging machine. I didn't install SS on staging machine at all, just copied files and db over. All was well.
I've now added new code, modules, page types, etc. re-tagged in SVN and redeployed. The Capistrano deploy went fine and the files look ok on the staging end. However, now when I run http://<project>.staging/dev/build/flush=1 to rebuild the db and check my deploy, I get an error:
[23-Sep-2009 10:00:18] Error at var/www/<project>/releases/20090923085107/sapphire/core/model/MySQLDatabase.php line 401: Couldn't run query:
SELECT `SiteTree`.*, `GhostPage`.*, `Page`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `Article`.*, `Recipe`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName
FROM `SiteTree`
LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID
LEFT JOIN `Page` ON `Page`.ID = `SiteTree`.ID
LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID
LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID
LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID
LEFT JOIN `Article` ON `Article`.ID = `SiteTree`.ID
LEFT JOIN `Recipe` ON `Recipe`.ID = `SiteTree`.ID
WHERE (HomepageForDomain REGEXP '(,
^) *<project>\.staging *(,|$)') ORDER BY Sort LIMIT 1 | Table '<project>.Page' doesn't exist (http://<project>.staging/Security/login)
My mysql log shows this:
77 Connect <project>@192.168.1.x on
77 Init DB <project>
77 Query SHOW TABLES
77 Query SHOW FULL FIELDS IN `Permission`
77 Query SHOW COLLATION LIKE 'utf8_general_ci'
77 Query SHOW FULL FIELDS IN `Member`
77 Query SHOW FULL FIELDS IN `Permission`
77 Query SHOW FULL FIELDS IN `Member`
77 Query SELECT `SiteTree`.*, `GhostPage`.*, `Page`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `Article`.*, `Recipe`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `Page` ON `Page`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `Article` ON `Article`.ID = `SiteTree`.ID LEFT JOIN `Recipe` ON `Recipe`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(,|^) *<project>\.staging *(,|$)') ORDER BY Sort LIMIT 1
It's failing because it's calling tables that haven't been built yet. If I copy over my dev db it's all fine.
Any ideas why it's not building the tables??