Thread

I ran into something recently and I can’t figure out what’s wrong—

In switching from local server to staging server, I usually Export the DB from local and import into Staging. It’s worked great so far.

Recently I wanted to Export the DB from the staging—because changes had been made there—and wanted to import to Local. It worked, but for some reason when I go to a certain template page for one channel - no entries are listed (they just so happen to coincide with the channel I added entries to on the staging server).

A look into Content/Edit reveals those entries to be there. If I call the entry with the full URL (http://site.com/channel_temp/section/entry_title) I get the entry just like I should. http://site.com/channel_temp/section which should reveal all those entries listed out - reveals nothing (just the exp:channel tag - the rest of the temp is fine)

Now here’s the strange part - if I go ahead and re-export that DB and re-import it into the staging server—all the entries show up as expected!

When switching servers I use Deeploy Helper to help me quickly change all the paths and that seems to be working fine - no problems.

In addition the DB I download from the staging server is 7.1MB, the one I export from local—which is supposed to have the same info is only 6.7MB

What could be causing this issue?

Hi J,

Could it be a difference in your server time zone settings?  Try adding show_expired_entries=“yes” to the channel entries tag in question and see if it appears in your local setup.

Cheers,
John

Hi J,

I like John’s idea. Also, are the entries still in exp_channel_data after the import?

And 2 suggestions:
1) Take Deploy Helper out of the picture and follow “Moving ExpressionEngine to Another Server” after you’ve imported the database. Just to be sure.

2) Use the Focus Lab Master Config instead. It will make your life a little easier than Deploy Helper.

~

I have a version of the Master Config already setup, though was having difficulties with some of the paths - that’s why I use Deeploy.

Did some more testing last night and it’s even weirder - basically reverted back to an older version of the DB. Then added back in the 10 entries on my local server - the template for all the entries worked flawlessly until the very last one. As soon as I Open that last one, when I go to display channel/section_temp I get nothing…

...but only on the local server.

Checking the staging server, if I go to Open up that last entry, all 10 entries display fine. On the local I need to set that last entry to Closed in order to see the entire listing.

It’s not a time zone setting problem as these are all brand new entries, yet I still experience the same issue.

Checking the staging server, if I go to Open up that last entry, all 10 entries display fine. On the local I need to set that last entry to Closed in order to see the entire listing.

Ok, that’s a pretty good clue. There is likely a configuration difference between the local and staging server. PHP version, MySQL setup or something like that. There is something special about that 10th entry that is knocking things out on your local server.

Does anything stand out?

~

OK.

Local PHP is 5.1.44, Staging PHP is 5.1.41

The local PHP extension is mysql, staging PHP extension is mysqli

That’s the only difference I can tell right off. Not really sure what I’m supposed to be looking for.

Very weird - doing more experimentation - it’s just this one channel. New entries on other channels work fine.

OK—I found the conflict. Took the channel:entries tag and put it into its own test template and all entries show up as expected. Debugging it seems like it gets tripped up using Stash. Not sure exactly what the conflict is or why it would be conflicting with my local setup (maybe something to do with MAMP, who knows). I guess I’ll go talk to the guy behind that to see what’s what,

thanks for your help!

Hi J. Hull,

Fantastic! Glad to see you got it sorted out!

If you need anything else, just let us know.

~