Server 500 error after GJ 3.0.1 update

Hello,

I just recently updated to the most current version of GroupJive 3.0.1. Following the installation, I got a error message that said:

1054 - Unknown column 'b.parent' in 'where clause' SQL=SELECT a.* FROM `jml_groupjive_groups` AS a LEFT JOIN `jml_groupjive_categories` AS b ON b.`id` = a.`category` WHERE ( a.`user_id` = '42' ) AND ( ( a.`category` = '7' ) OR ( b.`parent` = '7' ) ) ORDER BY a.`ordering` ASC

After searching the Forums, I saw a suggestion to ensure there are no duplicate users in GJ Groups. Indeed, there were a few duplicates. I removed those and started the upgrade again. There were no signs of errors during this installation.

When I try to login from the frontend, however, I am unable to without getting an error message. After pushing the "login" button, I get browser message of Server error 500. Details given are:

he website encountered an error while retrieving www.endodonticacademy.org/index.php/cblogin/login . It may be down for maintenance or configured incorrectly.

If I refresh the page, it comes up just fine and logged in as if the error never existed.

I suspect this could be a database error, but I really do not know how to fix it.

Any suggestions?

You've something installed that's out of date trying to use GJs database. Ensure the GJ module is up to date and CB Auto Actions (if used) is up to date.

If you're using the CBSubs GroupJive integration you'll need to unpublished or possibly delete it at this time as it's not up to date for GJ 3.x at this time (you can use CB Auto Actions to create categories/groups or join groups based off subscription if needed).

Thank you for the attention.

I did have the GJ CBsubs integration installed. I disabled, and then deleted it and both changes had no effect on the problem. I still get the Server 500 message.

In case I didn't communicate very well- The site only has this problem during login. After I refresh the error page, I am able to navigate the site (even the GJ section) without any errors at all. It appears to only be a problem with the login process.

Any other suggestions/ideas?

Ensure CB Auto Actions is up to date as well if installed as it can interact with GJ.

Back on this topic... I ended up needing to revert to a backup because I could not fix the issue and our organizations meeting was coming up.

I then attempted the upgrade on a backup site and got the same error. Only this time there is a 500 error that takes the whole site down. Any attempt to access the frontend or backend results in a 500 error. I can't access any of the admin areas to try to fix plugins, uniinstall modules, etc.

I'm glad this isn't on the main site. At this point, how would I even get to the point where I could diagnose the problem and fix it? The GJ upgrade has not been a smooth one for me! Suggestions?

Jon

I can't understand how GJ could possibly cause this. It doesn't touch users, login process, nothing. My guess is you may have something installed interacting with GJ that's not up to date and causing the fatal error.

Ensure all your CB plugins and Joomla extensions are up to date. Then enable debug mode and maximum error reporting in Joomla global configuration. Now install GJ to see if it is successful and if it's not you should see fatal errors on screen. If not check server error log for any fatal errors around the time of install.

Please note CBSubs GJ integration is not compatible with GJ 3.x. CB Auto Actions must also be updated to work with latest GJ. If GJ Auto integration is installed then uninstall it as it's not compatible (GJ will do this automatically on install, but could be failing in your case).