No records found after upgrade to JoomlaResearch 3.1 Beta

[Gavin]

Dear All,

Updated to Joomla Research 3.1 Beta.... all of my publications show in the back-end... but on the front end, it shows as "No Records Found"..

Any ideas folks?

[Luis Galárraga]

Hello Gavin,

It is known bug. In the upcoming days I will publish the corrections. Which version did you have before?

Best,

Luis

--
You received this message because you are subscribed to the Google Groups "J!Research Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jresearch-supp...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Gavin]

Dear Luis,

I was running with Joomla 3.x so was it the 3.0 alpha release? It was the first download of the version that supported Joomla 3.x

Would appreciate any thoughts on how to resolve this.

Kind Regards,

Gavin

[Luis Galárraga]

Hi,

Sorry for the delay. While I have solved this issue in the beta, I am still fighting with some bugs whose fixes I plan to include in the next version. Could you send me your file administrator/components/com_jresearch/models/publications.php?

Best,

Luis

[Gavin]

Here you go :) Many thanks!

[Luis Galárraga]

Hi,

I made a mistake in my request. I actually need your file components/com_jresearch/models/publications.php? Specifically the line 49:

The right content should be:

$query->leftJoin('#__jresearch_publication_researcharea AS ra ON pub.id = ra.id_publication');

but I suspect your file may have something like

$query->leftJoin('#__jresearch_publication_research_area AS ra ON pub.id = ra.id_publication');

If so, just make sure it looks like in the first line. Let me know if that solves the issue. In any case J!Research 3.1 stable will solve the issues with the table name.

Best,

Luis

--

[Gavin]

Hey Luis,

Please find my file attached. The file seems to check out and has the right line of code, but still does not work :(

Welcome any more ideas!

Gavin

[Luis Galárraga]

It seems fine. Then maybe your table is named differently. May I also see the file administrator/components/com_jresearch/install/install.mysql.utf8.sql ? Could you check file administrator/components/com_jresearch/install/install.mysql.utf8.sql for the line CREATE TABLE IF NOT EXISTS `#__jresearch_publication_researcharea`.

Is it research_area or researcharea? If it is the latter then the problem is caused by a different reason. Could you send me a dump of the database?

Best,

Luis

[Gavin]

Dear Luis,

As you will see from the attached file, there are two entries with research_area....

Thanks for this, you are doing a terrific job! It is such a great extension.

Very best wishes,

Gavin

CREATE TABLE IF NOT EXISTS `#__jresearch_research_area` (

CREATE TABLE IF NOT EXISTS `#__jresearch_research_area` (

[Luis Galárraga]

The names of the tables are ok, so the problem has a different origin. May I have admin access to check?

[M. A.]

My publications are not showing up either. Unfortunately, I have this on my firewalled site. Weird thing is if I hit the "reset" button in the frontend filters, the publications appear in the order of oldest to newest. 

[Luis Galárraga]

Hi,

Gavin's problem was a configuration issue. Go to the configuration of your menu item for the list of publications and verify the option " filter by year" is empty. In his case and for some unknown reason, it was set to "1". This version offers the option of showing only the publications of a single year (including the current year). Let me know if this solves the issue.

Best,

Luis

[Gavin]

Dear Luis,

An observation which might be useful...
I've just tried to display publications list in tabular view, and I see that I have the same problem of "No Records Found". I'm not worried as the tabular view isn't that useful for me, but I thought it was an observation that might be of use.

[Luis Galárraga]

Hi Gavin,

Thanks! I have honestly not tested the tabular view in detail so I will have a look at it before the release in order to fix potential issues.

Best,

Luis

[M. A. Ladd]

I think you meant "Published on year(s)" was set to 1. When I cleared it and saved, the setting switched to -1

[Luis Galárraga]

Yes, -1 should work. Does it?

[M. A. Ladd]

Sorry, should have put that in my answer - yes, changing the setting fixed it.