Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
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
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
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
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
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
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
Offline
Offline
Pages: 1