Statamic with multi sites and eloquent messing up

[ehbfa]

Hi! I'm running into issues with Statamic after migrating an existing site to the database. The migration process worked fine. I see my database tables filled with entries. But when I open the site, the navigation is there, the styling is there, but everything is empty? So my first guess was to look at the control panel.

I could not get into the control panel, because of a missing fieldset. There was an error about the seo fieldset coming from the Peak package. That file was there, and it was converted to the database, but somehow not being loaded. So I changed the driver for blueprints to file, and got that working again.

Then I noticed I got an error when loading the cp: Call to a member function inDefaultSite() on null.

And when I went to collections, there were the 4 collections I expected. But clicking on those collections, gave nothing, just empty results/pages.

So now I'm a bit lost, how to get my content back to work normally as before migrating to the database?

[duncanmcclean]

Then I noticed I got an error when loading the cp: Call to a member function inDefaultSite() on null.

Are you able to provide the full stack trace of this error so we can see where it's coming from?

And when I went to collections, there were the 4 collections I expected. But clicking on those collections, gave nothing, just empty results/pages.

Are there any errors in the console?

[ehbfa]

I did, and did it once more just now. But that did not import anything:

php please eloquent:import-globals 0 [▓░░░░░░░░░░░░░░░░░░░░░░░░░░░] Globals imported

So I changed the driver to file for the global_sets and now I see the content in the collections, but when I visit the site, I now get a 404

[ryanmitchell]

Did you also import collections? If so check that the route for the collection migrated over correctly (in the edit collection view). I've known this not to move over correctly.

Also check that the entry uri's are correct in the database.

[ehbfa]

I did all the imports, as I wanted to be sure I had everything in the database. But seems that not all is working correctly, and I have to have some stuff on the file driver. For the global sets and fieldsets it doesn't really matter, so that's all good :)

I'm going to check for the collection entries and see how the uri's are

[ehbfa]

@ryanmitchell Sorry for the delay, but I've been able to check the database and the issue was within the page ordering in the collection. Changing the order back to normal, where home is the first page (and isn't linked to another page), fixed the issue.

Now I have another issue, but I will open a new post for that (as it is not related to this)

[ryanmitchell]

In config/statamic/eloquent-driver.php just change entries back to 'driver' => 'file', and it will load from the stache instead of eloquent.

A full stack trace on the errors would be useful to identify the problem.

[ehbfa]

I'm a bit puzzled by this answer. As changing things back to 'file' seems to be counter intuitive with wanting to switch to the database? :)

[ryanmitchell]

It was in response to

So now I'm a bit lost, how to get my content back to work normally as before migrating to the database?

[ehbfa]

Ahh, gotcha! Then I understand again :) ty!