Topic-icon Help, first database errors caused by JFB, now site down after removal

Active Subscriptions:

None
Hey guys,
I have not had a working JFBConnect for several months, today, I decided to upgrade it, and I got a database error in the Joomla backend. In an attempt to fix it, i uninstalled JFBConnect... but during the uninstall, my my site crashed, and it is still down. Neither frontend nor backend show up... the site is statusselect.com

Cheers,
Stausselect
The topic has been locked.
Support Specialist
Not sure what could have caused that. We haven't heard of any database errors before that cause the site to not work. Most occur during installation and are due to unwritable directories.

As for your current dilemma, if you run the following queries on your database, it should disable all of the JFBConnect plugins. Hopefully, that will allow you to get into the admin area again.

UPDATE xxx_extensions SET enabled = 0 WHERE element = "jfbcsystem";
UPDATE xxx_extensions SET enabled = 0 WHERE element = "jfbconnectuser";
UPDATE xxx_extensions SET enabled = 0 WHERE element = "jfbconnectauth";

Change the xxx in each statement to your database prefix.

After you're back up, a couple of questions:
Do you know what version you were using before you upgraded?

What wasn't working before today (with the old version)? That will help narrow down the original cause.

Sorry for the trouble, but we'll get you going,
Alex
The topic has been locked.
Active Subscriptions:

None
It didn't work... and I had issues where it would not redirect nor login for quite a while. It worked great back in 1.6, but since around 1.7 it has caused issues. Right now I am on 2.5 beta 2. The backend was working, until I upgraded to the latest version of JFBConnect today, at which point, I got this error message:

"Unknown column 'mpublished' in 'where clause' SQL=SELECT m.id, m.parent_id, m.title, m.menutype FROM `jos_menu` AS m WHERE `mpublished` = 1 ORDER BY m.menutype, m.parent_id, m.ordering"

I then proceeded to uninstall JFBConnect, which caused a blank screen... it didn't give me a completion verification screen. That is when the site stopped working.
The topic has been locked.
Support Specialist
JFBConnect doesn't touch the jos_menu table during installation or uninstallation. There are things that Joomla does behind the scenes, but we're not in control of that. It sounds like that's an issue with Joomla 2.5 beta 2. We'd done some testing with beta 1, but not extensive tests, and we're certainly not recommending that anyone use JFBConnect (on a production site) with Joomla 2.5 yet.

Did the SQL queries I sent help get into the admin area?

Thanks,
Alex
The topic has been locked.
Active Subscriptions:

None
No, unfortunately it did not help.
The topic has been locked.
Support Specialist
A little more investigation.. it looks like your site was affected with the bug below in Joomla 2.5 b2:
code.joomla.org/gf/project/joomla/tracke...racker_item_id=27702

It's been fixed in the now available RC1 release. I'm not sure what problems may be on your site now with a partial install (or uninstall) of JFBConnect, but upgrading to RC1 may help. I'm hoping you have a backup of your site from before the upgrade as well, as that may be necessary.

Alex
The topic has been locked.
Active Subscriptions:

None
Thanks for the heads up :)
The topic has been locked.
Support Specialist
Something else you can try to at least diagnose the error is to edit your configuration.php file and change the following values:
public $error_reporting = 'maximum';
public $gzip = '0';
With those settings, it's possible that a PHP error will show up on the front end to let you know why the page won't load. It's no guarantee that will help though, depending on what extensions you have installed (especially for 'optimization' type stuff).. but hopefully.

Alex
The topic has been locked.