We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 28436
    • 242 Posts
    This is an auto-generated support/comment thread for Content History.

    Use this forum to post any comments about this addition or any questions you have regarding its use.

    Brief Description:
    Plugin to follow an document to the past.

    All suggestions and ideas are welcome. thanks!
      • 7231
      • 4,205 Posts
      Very interesting, I will be sure to test this soon. Thanks grin
        [font=Verdana]Shane Sponagle | [wiki] Snippet Call Anatomy | MODx Developer Blog | [nettuts] Working With a Content Management Framework: MODx

        Something is happening here, but you don't know what it is.
        Do you, Mr. Jones? - [bob dylan]
        • 17883
        • 1,039 Posts
        I will be sure to test this soon.

        Do it now, believe me it`s one of the best extensions ever. Aside the often requested multilanguage solution this is a perfect working versioning tool. Stefan only publishes if he is satisfied with the result, but the german community pushed him to publish this. And if you test it you will see that he never will be satisfied (erm, technical wink ).
          • 33337
          • 3,975 Posts
          This sounds cool!!

          i hope i will get some time to test this weekend.
            Zaigham R - MODX Professional | Skype | Email | Twitter

            Digging the interwebs for #MODX gems and bringing it to you. modx.link
            • 7455
            • 2,204 Posts
            I tried it but I get the following error when I want to edit a doc:

            « MODx Parse Error »
            MODx encountered the following error while attempting to parse the requested resource:
            « Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 45 »
                  SQL:  CREATE TABLE IF NOT EXISTS `modx_site_content_history`( `ch_id` int(10) unsigned NOT NULL auto_increment, `ch_doc_rev` int(10) NOT NULL default '1', `ch_doc_tplvars` text, `id` int(10) NOT NULL default '0', `type` varchar(20) NOT NULL default 'document', `contentType` varchar(50) NOT NULL default 'text/html', `pagetitle` varchar(255) NOT NULL default '', `longtitle` varchar(255) NOT NULL default '', `description` varchar(255) NOT NULL default '', `alias` varchar(255) default '', `link_attributes` varchar(255) NOT NULL default '', `published` int(1) NOT NULL default '0', `pub_date` int(20) NOT NULL default '0', `unpub_date` int(20) NOT NULL default '0', `parent` int(10) NOT NULL default '0', `isfolder` int(1) NOT NULL default '0', `introtext` text COMMENT 'Used to provide quick summary of the document', `content` mediumtext, `richtext` tinyint(1) NOT NULL default '1', `template` int(10) NOT NULL default '1', `menuindex` int(10) NOT NULL default '0', `searchable` int(1) NOT NULL default '1', `cacheable` int(1) NOT NULL default '1', `createdby` int(10) NOT NULL default '0', `createdon` int(20) NOT NULL default '0', `editedby` int(10) NOT NULL default '0', `editedon` int(20) NOT NULL default '0', `deleted` int(1) NOT NULL default '0', `deletedon` int(20) NOT NULL default '0', `deletedby` int(10) NOT NULL default '0', `publishedon` int(20) NOT NULL default '0', `publishedby` int(10) NOT NULL default '0', `menutitle` varchar(255) NOT NULL default '' COMMENT 'Menu title', `donthit` tinyint(1) NOT NULL default '0' COMMENT 'Disable page hit count', `haskeywords` tinyint(1) NOT NULL default '0' COMMENT 'has links to keywords', `hasmetatags` tinyint(1) NOT NULL default '0' COMMENT 'has links to meta tags', `privateweb` tinyint(1) NOT NULL default '0' COMMENT 'Private web document', `privatemgr` tinyint(1) NOT NULL default '0' COMMENT 'Private manager document', `content_dispo` tinyint(1) NOT NULL default '0' COMMENT '0-inline, 1-attachment', `hidemenu` tinyint(1) NOT NULL default '0' COMMENT 'Hide document from menu', PRIMARY KEY (`ch_id`), KEY `id` (`id`), KEY `ch_doc_rev` (`ch_doc_rev`) ) ENGINE=MyISAM DEFAULT CHARSET=;
                  [Copy SQL to ClipBoard]
            


            Dimmy
              follow me on twitter: @dimmy01
              • 28436
              • 242 Posts
              Hello Dimmy,

              look to the end of the message "DEFAULT CHARSET=; " No value? No idea, code looks like this


              DEFAULT CHARSET=".$modx->db->config['charset']."; 


              this variable is not exits in 9.6.1b.

              alternatively run this dump against you db
              CREATE TABLE IF NOT EXISTS `".$modx->db->config['table_prefix']."site_content_history`(
                `ch_id` int(10) unsigned NOT NULL auto_increment,
                `ch_doc_rev` int(10) NOT NULL default '1',
                `ch_doc_tplvars` text,
                `id` int(10) NOT NULL default '0',
                `type` varchar(20) NOT NULL default 'document',
                `contentType` varchar(50) NOT NULL default 'text/html',
                `pagetitle` varchar(255) NOT NULL default '',
                `longtitle` varchar(255) NOT NULL default '',
                `description` varchar(255) NOT NULL default '',
                `alias` varchar(255) default '',
                `link_attributes` varchar(255) NOT NULL default '',
                `published` int(1) NOT NULL default '0',
                `pub_date` int(20) NOT NULL default '0',
                `unpub_date` int(20) NOT NULL default '0',
                `parent` int(10) NOT NULL default '0',
                `isfolder` int(1) NOT NULL default '0',
                `introtext` text COMMENT 'Used to provide quick summary of the document',
                `content` mediumtext,
                `richtext` tinyint(1) NOT NULL default '1',
                `template` int(10) NOT NULL default '1',
                `menuindex` int(10) NOT NULL default '0',
                `searchable` int(1) NOT NULL default '1',
                `cacheable` int(1) NOT NULL default '1',
                `createdby` int(10) NOT NULL default '0',
                `createdon` int(20) NOT NULL default '0',
                `editedby` int(10) NOT NULL default '0',
                `editedon` int(20) NOT NULL default '0',
                `deleted` int(1) NOT NULL default '0',
                `deletedon` int(20) NOT NULL default '0',
                `deletedby` int(10) NOT NULL default '0',
                `publishedon` int(20) NOT NULL default '0',
                `publishedby` int(10) NOT NULL default '0',
                `menutitle` varchar(255) NOT NULL default '' COMMENT 'Menu title',
                `donthit` tinyint(1) NOT NULL default '0' COMMENT 'Disable page hit count',
                `haskeywords` tinyint(1) NOT NULL default '0' COMMENT 'has links to keywords',
                `hasmetatags` tinyint(1) NOT NULL default '0' COMMENT 'has links to meta tags',
                `privateweb` tinyint(1) NOT NULL default '0' COMMENT 'Private web document',
                `privatemgr` tinyint(1) NOT NULL default '0' COMMENT 'Private manager document',
                `content_dispo` tinyint(1) NOT NULL default '0' COMMENT '0-inline, 1-attachment',
                `hidemenu` tinyint(1) NOT NULL default '0' COMMENT 'Hide document from menu',
                PRIMARY KEY  (`ch_id`),
                KEY `id` (`id`),
                KEY `ch_doc_rev` (`ch_doc_rev`)
              ) ENGINE=MyISAM  DEFAULT CHARSET=".$modx->db->config['charset']."; 


              replace the prefix and charset variable with your settings.

              You are a russian? right? The languagefile is related to the manager-language. If no file found, the german.php will be used.
              You can set the english file to default in ch.plugin.php on line 36 ( include_once $_ch[’path’].’/lang/german.php’; )

              adios stefan

              EDIT: And thanks a lot for testing.
                • 7455
                • 2,204 Posts
                ok exelend works good now,

                only the styling is messing up the original fields all td’s get borders.

                Dimmy
                  follow me on twitter: @dimmy01
                • This is a very cool Plugin. I was just thinking that this was necessary to have. I love it! smiley

                  The only think it needs is some JS/CSS to show the changes in the diff view. If you haven’t tried this to you should.
                    Author of zero books. Formerly of many strange things. Pairs well with meats. Conversations are magical experiences. He's dangerous around code but a markup magician. BlogTwitterLinkedInGitHub
                    • 17883
                    • 1,039 Posts
                    If you haven’t tried this to you should.

                    Afair it`s on the way smiley
                      • 28436
                      • 242 Posts
                      Hey guys,

                      Quote from: MadeMyDay at Oct 16, 2008, 07:29 PM

                      If you haven’t tried this to you should.
                      Afair it`s on the way smiley

                      yes it is! this weekend i will upload an update.

                      ciao, Stefan