Page 1 of 1

Unable to view Candidates after Upgrade to 9.5.3 due to PHP 7

Posted: 11 Mar 2021, 14:14
by ementalist
Hi Team,

I have been using Open Cats since 2 years now on a shared hosting, my host has discontinued support for PHP5.6 therefore I was forced to upgrade to Open Cats 9.5.3 as my shared host only provides PHP 7.2, 7.3 and 7.4

After the upgrade, I have been unable to see the Candidates in the Candidates Home, or even in Job Orders they are not visible in the front end, data exists in the database. They are also visible in Activities, Dashboard, Report.

I am unable to pinpoint the issue to resolve this, would appreciate help and do let me know what other information would be required in order to resolve this at the earliest. This would be an urgent issue for us.

Thanks

Re: Unable to view Candidates after Upgrade to 9.5.3 due to PHP 7

Posted: 11 Mar 2021, 14:59
by cptr13
I haven't been able to get opencats to work under any circumstances. You can file this on github so the developers look at it though I believe it's being works on.

Any chance you did a backup before upgrading?

Re: Unable to view Candidates after Upgrade to 9.5.3 due to PHP 7

Posted: 11 Mar 2021, 15:13
by ementalist
Unfortunately, the person who was updating it, didn't do a backup, therefore, I'm here first time in 2 years. As far as I have tried to check, there are no errors being thrown. I'm thinking that it's unable to fetch the data somehow from the database.

Would it be of any help if I can give you access to the ATS?

Here's a screenshot of how it looks on the Candidate Page (notice it says 2 items there's more than 2250+ in the database)
Image

In a Job Order (Notice it says 3 candidates in Status Graph but none are there in the list below)
Image

Thanks

Re: Unable to view Candidates after Upgrade to 9.5.3 due to PHP 7

Posted: 11 Mar 2021, 16:22
by cptr13
No. Unfortunately I've been unable to work through similar issues. Report it on github so the devs see it.

What's your web host?

Re: Unable to view Candidates after Upgrade to 9.5.3 due to PHP 7

Posted: 12 Mar 2021, 17:37
by ementalist
Hi, I have been able to identify the issue and resolved the problem after lot of troubleshooting and testing.

The problem came down to a database issue.

Issue being, the new 9.5.3/2 has a new database table called candidate_duplicates if your older version of OpenCats does not have this(mostly may not), you will have to manually add it as doing a upgrade will not fix it(via installation wizard).

What I essentially did was installed a fresh copy of OpenCats, copied this database table to the existing database and finally now I can see the candidate list and OpenCats now runs properly as usual. Hope this helps anyone who has been having a similar issue.

Re: Unable to view Candidates after Upgrade to 9.5.3 due to PHP 7

Posted: 04 May 2021, 12:52
by aarong
Hello! Thanks ementalist! This fixed my upgrade as well. I truly appreciate you sharing your solution as this was becoming a tad frustrating since I too was working through the troubleshooting wickets. Again, thanks.

Aaron