Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2013-02-20 11:45:52
- Algaris
- Member
- From: England
- Registered: 2006-01-27
- Posts: 535
Issues installing plugins
I using a clean installation of Textpattern 4.5.4 (r4919). Whenever I try to install plugins I keep receiving error messages and the plugin fails to install.
So far I’ve had problems installing cnk_versioning (using Alan’s instructions), glz_custom_fields 1.4.0-beta1 and bot_write_tab_customize. These are the errors I received:
Internal error “Data too long for column ‘version’ at row 1”. – cnk_versioning and glz_custom_fields
Internal error “Table ‘txp_db.bot_wtc’ doesn’t exist”. – bot_write_tab_customize
When I dismiss the above errors the following is displayed.
I’m sorry. I’m afraid I can’t do that. I think plugin plugin_install is no safe operation at this time.
For some reason even though I received errors bot_write_tab_customize appeared to install but I then started getting the following error message every time I visited the Write page.
I’m sorry. I’m afraid I can’t do that. I think article create is no safe operation at this time.
I’ve tried twice on my local development server with clean installs and keep getting the same results.
Edit
Upon further investigation this appears to be a cnk_versioning and glz_custom_fields issue as I’ve installed a couple more plugins without any problem.
I’ve managed to get bot_write_tab_customize, I forgot to finish the installation process.
I’ve also managed to get cnk_versioning working by using 0.1.7 and then overwriting the plugin with Alan’s modifications. Strangely enough the unmodified 0.1.7 installs without a hitch.
My Diagnostics are as follows:
Textpattern version: 4.5.4 (r4919)
Last update: 2013-02-20 11:22:40/2012-12-05 08:55:44
Document root: C:/Program Files/Apache Software Foundation/Apache2.2/htdocs (C:\Program Files\Apache Software Foundation\Apache2.2\htdocs)
$path_to_site: C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin
Textpattern path: C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern
Permanent link mode: section_id_title
Temporary directory path: C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\tmp
Site URL: caprica/daily-bulletin
PHP version: 5.3.10
GD Image Library: bundled (2.0.34 compatible); supported formats: GIF, JPG, PNG.
Server TZ: Europe/London
Server local time: 2013-02-20 11:31:56
DST enabled?: 0
Automatically adjust DST setting?: 0
Time zone: (+0)
MySQL: 5.0.91-community-nt
Locale: English_United Kingdom.1252
Server: Apache/2.2.6 (Win32) PHP/5.3.10
Apache version: Apache/2.2.6 (Win32) PHP/5.3.10
PHP server API: apache2handler
RFC 2616 headers:
Server OS: Windows NT 5.2
Admin-side theme: hive 4.5.4
Pre-flight check:
————————————
There is a problem trying to connect to the RPC server. Please, try again later.
————————————
.htaccess file contents:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#Options -Indexes
#ErrorDocument 403 default
<IfModule mod_rewrite.c> RewriteEngine On #RewriteBase /relative/web/path/
RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]
RewriteCond %{REQUEST_URI} !=/favicon.ico RewriteRule ^(.*) index.php
RewriteCond %{HTTP:Authorization} !^$
RewriteRule .* – [E=REMOTE_USER:%{HTTP:Authorization}]
</IfModule>
#php_value register_globals 0
- SVG
AddType image/svg+xml svg svgz
AddEncoding gzip svgz
————————————
Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: latin1
character_set_filesystem: binary
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\
17 Tables: OK
10 Custom fields: custom_1, custom_2, custom_3, custom_4, custom_5, custom_6, custom_7, custom_8, custom_9, custom_10 (10)
PHP extensions: Core/5.3.10, bcmath, calendar, com_dotnet/0.1, ctype, date/5.3.10, ereg, filter/0.11.0, ftp, hash/1.0, iconv, json/1.2.1, mcrypt, SPL/0.2, odbc/1.0, pcre, Reflection/$Revision: 321634 $, session, standard/5.3.10, mysqlnd/mysqlnd 5.0.8-dev – 20102224 – $Revision: 321634 $, tokenizer/0.1, zip/1.9.1, zlib/1.1, libxml, dom/20031129, PDO/1.0.4dev, Phar/2.0.1, SimpleXML/0.1, wddx, xml, xmlreader/0.1, xmlwriter/0.1, apache2handler, gd, mysql/1.0, mysqli/0.1, mhash
Apache modules: core, mod_win32, mpm_winnt, http_core, mod_so, mod_actions, mod_alias, mod_asis, mod_auth_basic, mod_authn_default, mod_authn_file, mod_authz_default, mod_authz_groupfile, mod_authz_host, mod_authz_user, mod_autoindex, mod_cgi, mod_dir, mod_env, mod_imagemap, mod_include, mod_isapi, mod_log_config, mod_mime, mod_negotiation, mod_rewrite, mod_setenvif, mod_userdir, mod_php5
pretext_data: array (
‘status’ => ‘200’,
‘id’ => ‘’,
‘s’ => ‘’,
‘c’ => ‘’,
‘context’ => ‘’,
‘q’ => ‘’,
‘m’ => ‘’,
‘pg’ => ‘’,
‘p’ => ‘’,
‘month’ => ‘’,
‘author’ => ‘’,
‘request_uri’ => ‘/daily-bulletin/9e5fc1ba7192746f924586d79571462d/?txpcleantest=1’,
‘qs’ => ‘txpcleantest=1’,
‘subpath’ => ‘\\/daily\\-bulletin\\/’,
‘req’ => ‘/9e5fc1ba7192746f924586d79571462d/?txpcleantest=1’,
)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\index.php:
r4086 (1cacaf70cbd9defaa6e21f44a4a823df)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\css.php:
r4086 (c8b264911e6ad82a71588066c133f7b6)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\css.php:
r3189 (d2b173a93393ba06195d315de47f7b62)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\import\import_b2.php:
r3997 (0b219807adeed43500ae73d50dc9c43e)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\import\import_blogger.php:
r3901 (3c5ab5b884ccd3ee713f018112143b60)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\import\import_mt.php:
r3446 (e175e6a3ffa57c3ed21721a33c2a7ccc)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\import\import_mtdb.php:
r3997 (43104a7df70524f5b64305f4d05284ed)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\import\import_wp.php:
r3997 (f4b1d8914f7041682cee5857fc4da4a2)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_admin.php:
r4092 (c5a5b7d863afa56bb10b59554b1791b4)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_article.php:
r4270 (05ef282938604e3fe403beffb7e667c6)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_auth.php:
r3964 (117a841ec286ef82644b664aa1591e44)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_category.php:
r4089 (9c0715b38872290d9dcc6097e4247a05)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_css.php:
r4090 (98363a3352a545c5c79b7c2368e1a4c6)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_diag.php:
r4192 (e14d3b00084b2a74587e0c309b169e23)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_discuss.php:
r4089 (9326426b24abcc5422403e2e9fff48e2)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_file.php:
r4089 (56a9db44164ec37b8a0d1899c6fb1e5c)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_form.php:
r4156 (306e46a796f1093fdffc675a5484adda)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_image.php:
r4089 (56fc01f0efac7654a2deb891af251085)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_import.php:
r3997 (29d60777dad6d2c25df2ccf51d64ed9f)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_link.php:
r4089 (561afab2d5e3627bc32f9f3f64d455d1)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_list.php:
r4089 (1be0b2b868e73992b078c94ab8681088)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_log.php:
r4062 (aaccee1f6e803b10425b45d91f84d0e1)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_page.php:
r4873 (1681cd54d9297d554c6e61322bf7895b)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_plugin.php:
r4062 (51761ef37ef637b7fa57d3a58e1681a7)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_prefs.php:
r4062 (7d8fd18d1ec95b0b5a715f7c425a553e)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_section.php:
r4089 (d64d4d8fc9d69b50817dac59c4588bbc)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\include\txp_tag.php:
r4095 (d7c064d2076dcad78735c1858c8b2bb8)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\index.php:
r4916 (7b72f5976df392022490a80042dd9a3c)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\jquery.js:
unknown (b8d64d0bc142b3f670cc0611b0aebcae)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\IXRClass.php:
r3394 (40f7d5f34686ecd9d259b35006a6042d)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\admin_config.php:
r3896 (3b3da76b1c304cd8f72cc2292f737113)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\class.thumb.php:
r3733 (d9a8fad9eb15619c6acf6438e02b4fa2)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\classTextile.php:
r4096 (2e201db32675f78f0eda37ebc85cb6e8)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\constants.php:
r4060 (99d81fec07cfef75e66a3a50f599ccda)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\taglib.php:
r2868 (286eac5e382bfa77ecc7953f019ea88b)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\txplib_admin.php:
r3818 (52ffa8633e95f442ec00a1a652cb2124)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\txplib_db.php:
r3752 (df0b9ae0199fbe8a6148c02ad3ad53b0)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\txplib_forms.php:
r4872 (c2ab15d7473a18ef4b55e91c879ad7a6)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\txplib_head.php:
r3989 (3f910c8f20cf421ce7b14965a88f90b0)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\txplib_html.php:
r4163 (69349d370870489aad691e993a3df20e)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\txplib_misc.php:
r4816 (b2931b48f632a6036d86d369b76ece3f)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\txplib_publish.php:
r4461 (ea3fbc11514faf38ce9027221b3db31e)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\txplib_theme.php:
r3944 (5b2e74350182e012fb05688bbf8ffd29)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\txplib_update.php:
r4020 (b71d3ecc7d549b309b1d217b87493331)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\txplib_validator.php:
r3802 (e78ec0330390a90cc6c1782af901e77f)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\lib\txplib_wrapper.php:
r2931 (ecbe1b28c8a1d897d44a4a099a15e2f9)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\publish.php:
r4461 (79818b49d8875dc42a9551ccfc0545a5)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\publish\atom.php:
r4011 (937d52579e3c46c5ecf66d3240826c9d)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\publish\comment.php:
r4058 (aa88c15e827c5eeb61c880f6e4052658)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\publish\log.php:
r3505 (b4fa399a00c6dd321fc198181e6fce4a)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\publish\rss.php:
r4011 (7dc2f4065bb1a01b936e35cbfe1029df)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\publish\search.php:
r2812 (093e236da60feda207545d45b79a11b0)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\publish\taghandlers.php:
r4058 (8b46584619b1d30dd75c79a9e4c8f627)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\textpattern.js:
r4057 (bc03389e8771a1a052de955081514079)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\theme\classic\classic.php:
r4055 (362612183fb3e4e6e33bf646a2617ca2)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_1.0.0.php:
r4011 (8fb6bf221628bee9f5d0834643ea5077)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_4.0.2.php:
r4011 (af1f41698c76adca0eb88af3e2f97001)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_4.0.3.php:
r4011 (7ef2e0b60d4a82c53283d0959e6c3105)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_4.0.4.php:
r4011 (b8bb1964b610af251f832ace40200743)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_4.0.5.php:
r4011 (92610d1ce1eab53871a93287e5589e0c)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_4.0.6.php:
r4011 (639c3164eb1bed0ee5740f4b5f7bc1f1)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_4.0.7.php:
r4011 (f21a18372d7f1263b7bb540cecc3e9a2)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_4.0.8.php:
r3057 (e4e88113d4b0ab6fd003ab62a3c29675)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_4.2.0.php:
r4011 (43397d2c07e7e54d7b69e0651bc50bc5)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_4.3.0.php:
r4011 (24accd9fb2688208d02d380b176b3989)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_4.4.0.php:
r4011 (d30851758fe93cb98ecd998a80fd41f7)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_4.4.1.php:
r4011 (ceadb82db0c5b238159e3f95937d3c56)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_to_4.5.0.php:
r4020 (2ef4d4505566b6a74ec2f1c9948c7ab5)
C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\daily-bulletin\textpattern\update\_update.php:
r4919 (683a9a82f055e7fc750cae16a9619eea)
Last edited by Algaris (2013-02-20 16:50:38)
Offline
Re: Issues installing plugins
The issue is that those plugins have long version numbers. By default a plugin’s version numbers can be 10 characters long. For glz_custom_fields the current version number is 1.4.0-beta1, which is 1 character too many.
Normally these too long values would ignored, and truncated, but you appear to be running MySQL in strict mode. In strict mode, these ‘invalid’ insert/update operations are aborted, making installing impossible.
If you come across plugins with too long version number, I would make sure to inform the developer. If you want to get these plugins installed nonetheless, there are few ways. One is to change the mode MySQL runs in, or altering txp_plugin.version column to varchar(255) that would allow it to take more than 10 characters.
I would recommend changing the mode MySQL runs in. Running it in strict mode may also cause errors elsewhere, for instance when you enter a too long value to a custom field (operation aborts, and the article isn’t saved), blocks entries from logs and so on.
Offline
#3 2013-02-22 08:59:36
- Algaris
- Member
- From: England
- Registered: 2006-01-27
- Posts: 535
Re: Issues installing plugins
Thanks for the reply Jukka this is very useful information to know.
The IT technician who setup my development server removed the entry where strict mode was specified and everything works as expected now. Is it okay to leave MySQL like this or should an actual mode be specified? I don’t know MySQL well enough to understand how the different modes work.
Offline
Pages: 1