Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2016-09-26 02:50:49

joebaich
Member
From: DC Metro Area and elsewhere
Registered: 2006-09-24
Posts: 507
Website

Plugin List is Empty

The plugin list page on one of my site indicates that there are none installed, yet there are umpteen of them. Any ideas?

Textpattern version: 4.5.7 (r5900)
Last update: 2015-08-18 04:03:18/2015-08-18 03:59:23
Document root: /mnt/target02/343821/www.smlcorporation.com/web/content
$path_to_site: /mnt/target02/343821/www.smlcorporation.com/web/content
Textpattern path: /mnt/target02/343821/www.smlcorporation.com/web/content/textpattern
Permanent link mode: section_title
upload_tmp_dir: /tmp
Temporary directory path: /mnt/target02/343821/www.smlcorporation.com/web/content/textpattern/tmp
Site URL: smlcorporation.com
PHP version: 5.6.20-0+deb8u1
GD Graphics Library: 2.1.1-dev; supported formats: GIF, JPG, PNG.
Server TZ: America/Chicago
Server local time: 2016-09-25 21:45:58
DST enabled?: 0
Automatically adjust DST setting?: 1
Time zone: Australia/Melbourne (36000)
MySQL: 5.5.5-10.1.13-MariaDB-1~jessie
Locale: en_GB.UTF-8
Server: Apache/2.4
Apache version: Apache/2.4
PHP server API: apache2handler
RFC 2616 headers:
Server OS: Linux 3.16.0-4-amd64
Active plugins: rvm_privileged-0.4, zem_contact_lang-4.0.3.6, zem_contact_reborn-4.0.3.20m, pap_contact_cleaner-0.1, chh_if_data-0.10, adi_contact-0.5, smd_wrap-0.10m, aks_header-0.3.6, smd_article_stats-0.23, wet_plugout-0.2, rss_admin_db_manager-4.3.1, adi_matrix-1.2, adi_image_tab-0.2, rah_external_output-1.0.4, rah_custom_feed-0.2, rah_sitemap-1.2, ebl-image-edit-2.2, soo_plugin_pref-0.2.2, adi_page_tab-0.3, abl_droploader-0.20, adi_recent_tab-0.4, bot_write_tab_customize-0.7.2, smd_where_used-0.30, smd_browse_by-0.10, adi_form_links-0.1, rah_post_versions-0.9, rah_nocache-0.4.0, glz_custom_fields-1.4.0-betam
Admin-side theme: hive 4.5.7

Offline

#2 2016-09-26 07:41:35

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: Plugin List is Empty

joebaich wrote #301734:

The plugin list page on one of my site indicates that there are none installed, yet there are umpteen of them.

Curious. I wonder what changed. So your site functions perfectly well, the plugins all run fine, and your Extensions area is populated? If so, since plugins don’t run on the Plugins panel, I wonder if the txp_plugins table is corrupted or something. Can you do a repair on it, just to be sure?


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#3 2016-09-26 12:41:43

joebaich
Member
From: DC Metro Area and elsewhere
Registered: 2006-09-24
Posts: 507
Website

Re: Plugin List is Empty

Yep,everything works as it should apart from the Plugin Panel. What has changed is the mySQL. The host upgraded to a MariaDB version from mySQL proper recently (as indicated in the diagnostics).

I get an error message: Could Not Show Table Status Because Your MYSQL Version Is Lower Than 3.23. when I try to call up the table list in the DB Manager plugin but the DB Backup seems to work OK. I get the same issue as this in another TXP site with a similar PlugIn set up but the Plugin panel is properly populated.

I did run a repair on the txp_pluins table but it didn’t solve the plugin panel issue.

Offline

#4 2016-09-26 13:01:35

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: Plugin List is Empty

joebaich wrote #301755:

Yep,everything works as it should apart from the Plugin Panel.

Freaky. All calls on that page use our bog-standard DB library, which should be MariaDB compatible. If you go much higher in PHP versions, 4.5.7 might fall over though. Can’t think of a reason it would fail only on that panel. If you temporarily switch your site to Debugging mode, does that give any clues? Anything in your server / PHP logs?

Failing that, go to your txp_plugin.php file and alter line 66 to read this:

$rs = safe_rows_start('name, status, author, author_uri, version, description, length(help) as help, abs(strcmp(md5(code),code_md5)) as modified, load_order, flags',
			'txp_plugin', '1 order by '.$sort_sql, 1);

(i.e. just add , 1 inside the last bracket) then reload the panel. Txp will (should) dump the query it’s trying to execute. Take that query and drop it in your phpMyAdmin or equivalent SQL executor, run it and see what you get back. If you get no rows, that query is the issue.

The next question would then be why. Feel free to post it here and someone might be able to shed some light on it.

If you do get rows back, then it may be the portion of the code that iterates over the result set. But we use that same construct on other panels, and if they’re fine, then it should be ok here too.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#5 2016-09-26 14:09:34

joebaich
Member
From: DC Metro Area and elsewhere
Registered: 2006-09-24
Posts: 507
Website

Re: Plugin List is Empty

Bloke wrote #301756:

If you temporarily switch your site to Debugging mode, does that give any clues?

BINGO Stef! when in debugging mode and trying to list plugins on admin side.

Internal error “Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation ‘strcmp’”
in /mnt/target02/343821/www.smlcorporation.com/web/content/textpattern/lib/txplib_db.php at line 95.
adminErrorHandler()
textpattern/lib/txplib_db.php:95 trigger_error()
textpattern/lib/txplib_db.php:320 safe_query()
textpattern/lib/txplib_db.php:258 startRows()
textpattern/include/txp_plugin.php:67 safe_rows_start()
I’m sorry. I’m afraid I can’t do that; plugin is an unsafe operation.

Been using Textpattern for 10 plus years now and you would have thought I would have realised that Debugging Mode applied to the back end too. Well we live and learn.

Offline

#6 2016-09-26 14:12:13

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: Plugin List is Empty

joebaich wrote #301759:

Illegal mix of collations

Awesome! In which case, see here for a probable fix.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#7 2016-09-26 17:29:13

joebaich
Member
From: DC Metro Area and elsewhere
Registered: 2006-09-24
Posts: 507
Website

Re: Plugin List is Empty

Bloke wrote #301760:

Awesome! In which case, see here for a probable fix.

Will do. As ever, thanks for the invaluable help.

Offline

#8 2016-09-28 04:35:42

joebaich
Member
From: DC Metro Area and elsewhere
Registered: 2006-09-24
Posts: 507
Website

Re: Plugin List is Empty

Bloke wrote #301760:

Awesome! In which case, see here for a probable fix.

Yep, that did it for me.

Offline

Board footer

Powered by FluxBB