I have just set up a new Revo (2.2.10) site for a client. Because some of their old data
might be needed I have copied over their site content and template variable information from their Evo site directly in the database. This imported ok and I made sure all the db fields were there - which they seem to be. In the site tree in the manager I see everything. I have put old site pages into a new container in the tree called 'OLD PAGES' so that I can bring back any pages in need to. At the top level I have created six new pages as I would normally. Viewing the pages is fine: chunks work, templates work snippets work. For some reason Wayfinder returns nothing and the array created by running $modx->getChildIds(0,1); is empty too. I have installed 'Breadcrumbs' and that does show the path ok. After trying yo view a page I see this in the error log:
[2013-10-08 16:58:09] (ERROR @ /index.php) Encountered empty IN condition with key id
[2013-10-08 16:58:09] (ERROR @ /index.php) Error 42000 executing statement:
Array
(
[0] => 42000
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
)
Any ideas? All resources are set as published and should 'show in menu'.
