WordPress – deactivate plugins from db

Wordpress plugin issues

Sometimes it may be necessary to deactivate plugins, but you can’t access the administrative menus to do so. usually down to a flaky plugin that not only fails to work, but leaves garbage that causes wordpress to throw a hissy fit.

In the table wp_options, under the option_name column (field) find the active_plugins row
TO deactivate ALL plugins, change the option_value field to: a:0:{}.  Hopefully this should intially bring your site back to life, and you can gradually activate each plugin until you find the offending one (that causes your site to fall over),

Here is an example from the option record:-

a:11:{i:0;s:31:”autocompleter/autocompleter.php”;i:1;s:48:”classipress-ajax-post-sort/wp-ajax-post-sort.php”;i:2;s:21:”cpmobile/cpmobile.php”;i:3;s:21:”exec-php/exec-php.php”;i:4;s:43:”image-sizes-manager/image-sizes-manager.php”;i:6;s:30:”premium-gallery/sp-gallery.php”;i:7;s:40:”related-ads/related-posts-thumbnails.php”;i:8;s:35:”si-contact-form/si-contact-form.php”;i:9;s:25:”user-photo/user-photo.php”;i:10;s:41:”wordpress-importer/wordpress-importer.php”;}

To remove reference to a plugin, that you already know is the likely problem, simply remove the whole entry (terminated by a “;”).  The blue highlighted text illustrates a complete plugin entry.

sig.ma

The idea here is that users describe characteristics of their search target, instead of relying entirely on content keywords. The easiest way to get an idea of what it is doing (or trying to do!) is search on your name/company and add 1 or more words to give it a little focus. For instance I searched on jaffamonkey qa, which generated result below.

So many lotteries …

Robert Popper (the co-creator of Look Around You, and general modern comedy guru), calling guy behind one of those “you have one $688,000 in spanish lottery” scams …

… a little while back I received a letter saying that I had physically won 615,810 Euros in the Spanish Lottery. Congratulations! So I phoned the man, a gentleman by the name(s) of Don Luis Lopez to find out how I could get all my winnings…

http://www.bbc.co.uk/blogs/comedy/2009/11/robin-cooper-week.shtml

HowSociable?

howsociable_wordpress1What Keith Barrett would call “just a bit of fun”.   It searches a lot of major social networking/bookmarking sites for occurences of search term (i.e. your name or ID).  I was interested to finds my ID appears on sites I signed up to, but never used, such as ecademy and ning.  But sometimes interesting to find out where you have been mentioned!  Needs to cover a load more sites though.

HowSociable? – Brand Visibility Metrics

E.ON – Power and Gas

Although the English service record has always been particularly poor, utilities companies seem to employ people with part of their brains missing.  I recently moved into new flat, and dutifully informed Eon of the change of tenant.  I now get two bills regularly twice a week – one billed to The Occupier for bill prior to me moving in, and one also addressed to “The Occupier” for subsequent bill.  Now it seems to me that they have obviously received my details, as the date up to, and date from, on the bills tallies.  Maybe they are hoping I will pay both bills to save them administration.  Must be so complicated changing one name to another – obviously is for a UK company, especially lazy inept parasitic ones like Eon.

BT also step up to the mark on this one, but in a manner intended to confuse and worry you enough to pay up regardless.  They are a far more shameless bunch of idiots, and in process of taking them to court, as we cannot allow companies to feel they can bully – that is simply plain cowardice on their part.

Actually I am missing the point – you want to screw more money out of your customers – apply unreasonable inflation-busting charges, keep the intimidation letters flowing, and hire idiots to administer – pure credit-crunch brilliance!  It worked for The Tube, National Rail, etc.  Incompetence should be rewarded, and now is in the UK – welcome to world of “Nathan Barley”, an oft referenced comedy from the very astute Chris Morris (and Charlie Brooker).

I am not too churlish not to wish all a happy new year, so Happy New Year Eon and BT! ….. you bunch of morons.

Last.fm & APML

Tastebroker provide a service to translate you Last.fm details into APML format.

http://tasteBroker.org/music/jaffamonkey

Sample Output

<?xml version="1.0" ?>

<APML xmlns="http://www.apml.org/apml-0.6" version="0.6">
<Head>
  <Title>music taste for jaffamonkey</Title>
  <Generator>Created by TasteBroker.org</Generator>
  <DateCreated>2007-11-25T00:56:16</DateCreated>
  </Head>
<Body defaultprofile="music">
<Profile name="music">
<ImplicitData>
<Concepts>
  <Concept key="electronic" value="1.0" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="electro" value="0.9251824" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="techno" value="0.39781022" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="electronica" value="0.35036492" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="detroit" value="0.2609489" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="dance" value="0.12591241" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="idm" value="0.12043796" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="detroit techno" value="0.10766424" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="synthpop" value="0.10036495" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="seen live" value="0.08211679" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="House" value="0.07664234" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="Electroclash" value="0.074817516" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="Favorite" value="0.05109489" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="Acid" value="0.045620438" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="Disco" value="0.045620438" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="alternative" value="0.040145986" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="elitectro" value="0.032846715" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="Analog" value="0.032846715" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="electronic music" value="0.031021899" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  </Concepts>
  </ImplicitData>
<ExplicitData>
<Concepts>
  <Concept key="Drexciya" value="1.0" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="Underground Resistance" value="1.0" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="Dynamix II" value="1.0" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="Polarius" value="1.0" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="Vitalic" value="1.0" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="Japanese Telecom" value="1.0" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  <Concept key="Alden Tyrell" value="1.0" from="tastebroker.org" updated="2007-11-25T00:56:16" />
  </Concepts>
  </ExplicitData>
  </Profile>
  </Body>
  </APML>

displayname = ‘jaffamonkey’; limit = 10
tagcloud_title = “My Interests”;
apml_url = “http://www.cluztr.com/users/jaffamonkey/feeds/apml/&#8221;;