I am experience very inconsistence behaviour with the way get_items function run.
I use this function and pass an exhibit id to it to get the first image from first item in the exhibit.
I run this function couple of weeks a go and it was perfectly do the job. Then I moved the db to another server and still all exhibits created are displayed with first image in first item in the exhibit.
However, I am experience this since last week. Every time I add a new exhibit and created pages to new exhibit and add items to these pages, I get the last item and not the first item.
If I go back to the old exhibits created and add a new page then add an item to this page, I still
get the first item from the page and not the last item that I just created.
I already released the code and we will start use it next week but I was wonder if there is a nother way I can get the first item only from an exhibit because get_items behave in consistent.
It is very important for us to keep the image used with exhibit the same all the time.
I looked at the db. I do need to join exhibit, items, section, section_pages tables to get to the first item. is there a better way?
function already done that I can use?
please help if you know another solution.