Jamroom 5.3 Beta Kickoff
Announcements
soaringeagle:i just rebooted the server
tmp is only 6% used
i know it worked fine till the core update
i see
- Change: "_item_id" included if not specified in return_keys parameter to jrCore_db_search_items()
so your saying this is run at the end of th search items and the change _item_id included if not in return key..
it seems likely this is the cause..no?
That's not related. In a jrCore_db_search_items() call you can specify the "return_keys" that you want - this lets you get a subset of keys from the item instead of ALL the item keys. This is used in a few places in JR, but it's not related to your query issue. What this change did is just make it if you do NOT specify "_item_id" in your return_keys array, it is added for you (this is needed by event listeners and it was easy to forget to ask for it, so it is automatic).
The only REAL changes that I believe could have affected you were that some queries have some additional JOIN conditions now (this fixed the pagination issue you reported) - but that's not a problem here because we are already PAST that portion of the search items call - you're getting hung up on a query that it should not be getting hung up on.
Not sure what to recommend to you - roll back to 5.3.0b3 if it was working, or earlier if you can.
If you get a chance, send an email to support [at] jamroom [dot] net with a place where I can download a DB dump of your system (if that is OK with you) - I will load it up here tomorrow on my dev server and put it through it's paces to see if it is a DS issue or something else.
Thanks!