Go to main content

Navigation menu

Textpattern CMS support forum

You are not logged in. Register | Login | Help

  1. Index
  2. » Archives
  3. » [plugin] [ORPHAN] cnk_versioning

Pages: 1 … 6 7 8 9 10 … 19

#85 2010-09-29 15:23:20

linguist
Member
Registered: 2007-11-03
Posts: 24

Re: [plugin] [ORPHAN] cnk_versioning

Hello again! Could you please help me with this. I was about to uninstall the plugin in the way you recommended when I noticed that the plugin was marked as Modified. I have no idea what was modified and why. Could this present a problem during de-installation? Thank you.

Offline

#86 2010-09-29 15:33:31

johnstephens
Plugin Author
From: Woodbridge, VA
Registered: 2008-06-01
Posts: 999
Website

Re: [plugin] [ORPHAN] cnk_versioning

It has to be modified to be used. When the plugin is initially installed, you have to edit the plugin to designate a directory for cnk_versioning to store your templates in the file system. This has no affect on the uninstall process.

Offline

#87 2010-09-29 17:35:49

linguist
Member
Registered: 2007-11-03
Posts: 24

Re: [plugin] [ORPHAN] cnk_versioning

Good to know that, thanks. Just to know a little more about what to expect, will there be some kind of dialogue during the uninstall process? I mean, questions like: Remove this? Delete that? And how to respond to them? I’m really sorry to bother you with all this, but there’s no one else I can ask. Really appreciate your help.

Offline

#88 2010-09-30 08:05:23

Algaris
Member
From: England
Registered: 2006-01-27
Posts: 535

Re: [plugin] [ORPHAN] cnk_versioning

I’m trying to use this plug-in on an IIS server (if that’s the problem I’m not sure at the moment).

When the plug-in is installed and I try to write my Pages, Forms and CSS to folders I get the following errors:

Warning: Unknown column 'file_mod_time' in 'field list' update txp_form set file_mod_time = FROM_UNIXTIME('1285833467') where 1=1 in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85 Forms were successfully written to the "/forms/" directory.

Warning: Unknown column 'file_mod_time' in 'field list' update txp_page set file_mod_time = FROM_UNIXTIME('1285833467') where 1=1 in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85 Pages were successfully written to the "/pages/" directory.

Warning: Unknown column 'file_mod_time' in 'field list' update txp_css set file_mod_time = FROM_UNIXTIME('1285833467') where 1=1 in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85 Styles were successfully written to the "/css/" directory.

When I go to view my site I get the following errors:

Warning: Unknown column 'file_mod_time' in 'field list' select name,type,IFNULL(unix_timestamp(file_mod_time), 0) as mod_time from txp_form where 1=1 in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'Links', type = 'link', form = '


\n
', file_mod_time = FROM_UNIXTIME('1285833254') in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'article_listing', type = 'article', form = '

    * \n\n ·
      \n\n

', file_mod_time = FROM_UNIXTIME('1285833254') in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'comment_form', type = 'comment', form = '\n\n\n\n \n\n \n\n\n\n \n\n \n\n\n\n \n\n \n\n\n\n \n\n \n\n\n\n\n \n\n
\n \n 	\n \n \n
\n \n 	\n \n
\n \n 	\n \n
\n \n 	\n \n
\n
 	\n \ in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'comments', type = 'comment', form = '\n\n

— · · #
', file_mod_time = FROM_UNIXTIME('1285833254') in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'comments_display', type = 'article', form = '
\">
\n\n\n\n\n
\n\n
\n\n\n\n\n\n

\n', file_mod_time = FROM_UNIXTIME('1285833254') in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'default', type = 'article', form = '\n
\n\n
\n\n\n

\n\n
\n\n
\n\n
—
\n\n

,
\n\n\n\n
\n\n', file_mod_time = FROM_UNIXTIME('1285833254') in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'files', type = 'file', form = ': \n\n []\n\n
\n:
\n: ', file_mod_time = FROM_UNIXTIME('1285833254') in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'lofi', type = 'article', form = '
#
\n\n

\n\n
\n\n
\n\n\n\n', file_mod_time = FROM_UNIXTIME('1285833254') in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'noted', type = 'link', form = '

.
', file_mod_time = FROM_UNIXTIME('1285833254') in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'plainlinks', type = 'link', form = '
', file_mod_time = FROM_UNIXTIME('1285833254') in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'popup_comments', type = 'comment', form = '\n\n\n \n \n \" />\n\n\n\n
\n\n
\n\n\n', file_mod_time = FROM_UNIXTIME('1285833254') in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'search_results', type = 'article', form = '
\n\n

\n\n

\n\n

\n\n
', file_mod_time = FROM_UNIXTIME('1285833254') in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_form set name = 'single', type = 'article', form = '
\n

\n\n
\n\n
\n\n', file_mod_time = FROM_UNIXTIME('1285833254') in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' select name,IFNULL(unix_timestamp(file_mod_time), 0) as mod_time from txp_page where 1=1 in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_page set name = 'archive', user_html = '\n\n\n \n\n \n\n \" />\n\n \n \n\n \n\n \n\n\">\n\n\n
\n

    * \n
    * \n
    * \n
      \n 

\n
\n\n
\n\n\n
\n

    * \n
    * \n
    * \n in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

      Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_page set name = 'error_default', user_html = '\n\n\n \n\n \n\n \" />\n\n \n \n\n \n\n\n\n\n
      \n
          o \n
          o \n
          o \n
            \n \n
      \n\n
      E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

      Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_page set name = 'old_default', user_html = '\r\n\r\n\r\n \r\n\r\n \r\n\r\n \" />\r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\nfront\">\r\n\r\n\r\n
      \r\n
          o \r\n
          o \r\n
          o \r\n E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

            Warning: Unknown column 'file_mod_time' in 'field list' select name,IFNULL(unix_timestamp(file_mod_time), 0) as mod_time from txp_css where 1=1 in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

            Warning: Unknown column 'file_mod_time' in 'field list' insert into txp_css set name = 'default', css = 'LyogYmFzZQ0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0gKi8NCg0KYm9keSB7DQoJbWFyZ2luOiAwOw0KCXBhZGRpbmc6IDA7DQoJZm9udC1mYW1pbHk6IFZlcmRhbmEsICJMdWNpZGEgR3JhbmRlIiwgVGFob21hLCBIZWx2ZXRpY2EsIHNhbnMtc2VyaWY7DQoJY29sb3I6ICMwMDA7DQoJYmFja2dyb3VuZC1jb2xvcjogI2ZmZjsNCn0NCg0KYmxvY2txdW90ZSwgaDMsIHAsIGxpIHsNCglwYWRkaW5nLXJpZ2h0OiAxMHB4Ow0KCXBhZGRpbmctbGVmdDogMTBweDsNCglmb250LXNpemU6IDAuOWVtOw0KCWxpbmUtaGVpZ2h0OiAxLjZlbTsNCn0NCg0KYmxvY2txdW90ZSB7DQoJbWFyZ2luLXJpZ2h0OiAwOw0KCW1hcmdpbi1sZWZ0OiAyMHB4Ow0KfQ0KDQpoMSwgaDIsIGgzIHsNCgltYXJnaW46IDAgMCAxNXB4IDA7DQoJcGFkZGluZzogMCAxMHB4Ow0KCWZvbnQtd2VpZ2h0OiBub3JtYWw7DQp9DQoNCmgxLCBoMiB7DQoJZm9udC1mYW1pbHk6IEdlb3JnaWEsIFRpbWVzLCBzZXJpZjsNCn0NCg0KaDEgew0KCWZvbnQtc2l6ZTogMS40ZW07DQp9DQoNCmgyIHsNCglmb250LXNpemU6IDFlbTsNCglmb250LXN0eWxlOiBpdGFsaWM7DQp9DQoNCmhyIHsNCgltYXJnaW46IDJlbSBhdXRvOw0KCXdpZHRoOiAzNzBweDsNCgloZWlnaHQ6IDFweDsNCgljb2xvcjogIzdhN2U3ZDsNCgliYWNrZ3JvdW5k

Added bc. for better code display -Gocom

Thanks Gocom I was having trouble with that.

Last edited by Algaris (2010-09-30 08:53:01)

Offline

#89 2010-09-30 17:54:42

the_ghost
Plugin Author
From: Minsk, The Republic of Belarus
Registered: 2007-07-26
Posts: 907
Website

Re: [plugin] [ORPHAN] cnk_versioning

Did you make “install” from admin-side -> presentation -> versioning? If YES, check txp_pages\forms\css if they have file_mod_time column.

Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?

Offline

#90 2010-10-01 07:48:23

Algaris
Member
From: England
Registered: 2006-01-27
Posts: 535

Re: [plugin] [ORPHAN] cnk_versioning

Thanks for the reply Victor.

Sorry I should have made that more clear. Yes I installed it from the admin-side -> presentation -> versioning.

Do you mean in the database? I’ve checked the txp_pages\forms\css tables and can’t see the file_mod_time column. All I can see are the entries for the standard Pages, Forms and CSS that come with a clean install.

I guess the other thing I should mention is that this is a clean install with just hak_tinymce running along side cnk_versioning.

—Edit—

I decided to try uninstalling the plug-in from presentation -> versioning to see if I could try reinstalling it again and revived the following error:

Warning: Can't DROP 'file_mod_time'; check that column/key exists ALTER TABLE txp_form DROP `file_mod_time` in E:\Inet\ross\textpattern\lib\txplib_db.php on line 85

Deinstallation aborted

Last edited by Algaris (2010-10-01 08:04:48)

Offline

#91 2010-10-01 08:10:01

the_ghost
Plugin Author
From: Minsk, The Republic of Belarus
Registered: 2007-07-26
Posts: 907
Website

Re: [plugin] [ORPHAN] cnk_versioning

can you run such sql commands (one-by-one) (via phpmyadmin, for example) and show here the result?

show columns from txp_css;
show columns from txp_form;
show columns from txp_page;

Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?

Offline

#92 2010-10-01 08:42:22

Algaris
Member
From: England
Registered: 2006-01-27
Posts: 535

Re: [plugin] [ORPHAN] cnk_versioning

It was a little difficult trying to copy and paste a table into a readable form for the forum so I just copied the Field names. I hope that’s okay.

SHOW COLUMNS FROM txp_css;

name
css

SHOW COLUMNS FROM txp_form;

name
Type
Form

show columns from txp_page;

name
user_html

Last edited by Algaris (2010-10-01 08:42:55)

Offline

#93 2010-10-01 08:58:50

the_ghost
Plugin Author
From: Minsk, The Republic of Belarus
Registered: 2007-07-26
Posts: 907
Website

Re: [plugin] [ORPHAN] cnk_versioning

Yok, you tried to unistall plugin – but it dropped an error, because while deinstallation it tries to delete column file_mod_time. But you don’t have such column. Try again press install at plugin’s page and watch if there are any errors or good messages.

Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?

Offline

#94 2010-10-01 09:29:38

Algaris
Member
From: England
Registered: 2006-01-27
Posts: 535

Re: [plugin] [ORPHAN] cnk_versioning

Whooo! That worked, thanks for your help.

Offline

#95 2010-10-04 20:10:42

johnstephens
Plugin Author
From: Woodbridge, VA
Registered: 2008-06-01
Posts: 999
Website

Re: [plugin] [ORPHAN] cnk_versioning

linguist wrote:

Good to know that, thanks. Just to know a little more about what to expect, will there be some kind of dialogue during the uninstall process? I mean, questions like: Remove this? Delete that? And how to respond to them? I’m really sorry to bother you with all this, but there’s no one else I can ask. Really appreciate your help.

Here’s a live report of an actual uninstall:

  1. Backing up: The dialogs involved in this depend on what method you use.
  2. Go to the “Preferences” tab under “Admin”. Make sure the site’s production status is set to “Live”, and click the “Save” button if you make any changes. Status message: Preferences saved
  3. Go to the “Plugins” tab under “Admin”. Activate cnk_versioning. Status message: Plugin cnk_versioning updated.
  4. Go to the “Versioning” tab under “Presentation”. Click “Deinstall” to run the uninstall script. Click “Yes, I really want to deinstall”. Status message: Deinstallation was successful
  5. Go to the “Plugins” tab under “Admin”. Deactivate cnk_versioning. Status message: Plugin cnk_versioning updated. Delete cnk_versioning. Browser dialog: Are you sure? Select “OK”. Status message: Plugin cnk_versioning deleted.

That’s all.

Offline

#96 2010-10-11 13:24:47

linguist
Member
Registered: 2007-11-03
Posts: 24

Re: [plugin] [ORPHAN] cnk_versioning

Johnstephens, thank you for your help.

Offline

Pages: 1 … 6 7 8 9 10 … 19

  1. Index
  2. » Archives
  3. » [plugin] [ORPHAN] cnk_versioning

Board footer

Powered by FluxBB