We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 30613
    • 6 Posts
    I just noticed in the error log, that when I access the CMP this error is reported in the log. Xdbedit still works fine, TinyMCE works fine. What can the reason be behind this error?

    [2011-02-18 17:02:39] (ERROR @ /manager/index.php) style,advimage,advlink,modxlink,searchreplace,print,contextmenu,paste,fullscreen,noneditable,nonbreaking,xhtmlxtras,visualchars,media
    [2011-02-18 17:02:41] (ERROR @ /assets/components/xdbedit/connector.php) Instantiated a derived class modDocument that is not a subclass of the requested class Content
    [2011-02-18 17:02:41] (ERROR @ /assets/components/xdbedit/connector.php) Instantiated a derived class modDocument that is not a subclass of the requested class Content
    [2011-02-18 17:02:41] (ERROR @ /assets/components/xdbedit/connector.php) modTemplateVar: Attempt to set NOT NULL field caption to NULL
    [2011-02-18 17:02:41] (ERROR @ /assets/components/xdbedit/connector.php) modTemplateVar: Attempt to set NOT NULL field caption to NULL
    [2011-02-18 17:02:41] (ERROR @ /assets/components/xdbedit/connector.php) modTemplateVar: Attempt to set NOT NULL field caption to NULL
    [2011-02-18 17:02:41] (ERROR @ /assets/components/xdbedit/connector.php) modTemplateVar: Attempt to set NOT NULL field caption to NULL
    


    There is about 25 errors of the "Instantiated a derived...". I am guessing the first one is about the TinyMCE? Yet, it still works fine. The last to errors, I have no clue what they can be about.

    I am guessing that since the package still works fine, it is not an important error, but still... shocked
      • 14397
      • 14 Posts
      Quote from: gOmp at Feb 13, 2011, 05:52 AM

      Umm.. and so i thought of trying xdbedit, starting with the provided example (telephonelist).

      I’ve Downloaded all the project files zipped from github ,put them in place:

      • core\components\example
      • core\components\xdbedit

      And followed the wiki instructions:
      I. Finished the first stage (`The Installation`), all the namescape,menu,action related stuff.
      II. Going through the second stage (`Creating your own table-editor with xdbedit`), skipping steps 1-5. completing steps 6-7.
      III. Went to the `mytask` option under the components>custom-table-editor and right before my eyes, there it was: an empty custom table CMP.
      Seems very nice, looks very handy. awesome job you’ve made there Bruno, thanks.

      A small problem i came across is:
      When i was trying to add some data i couldn’t make changes and hitting the Save button didn’t fired nothing.
      I’m on 2.0.7-pl.

      Any hints?
      maybe it’s related with the `datum` tv?

      I am experiencing the same problem. Nothing is saved when I click the save button. My error log shows this:

       [2011-02-23 14:41:45] (ERROR @ /mcz_revolution/assets/components/xdbedit/connector.php) Error 42S02 executing statement: 
      Array
      (
          [0] => 42S02
          [1] => 1146
          [2] => Table 'db48294_103.modx_example_telephonedir' doesn't exist
      )


      But the table does exist in my db. I precisely followed the xdbedit installing instructions and everything looks exactly like in g0mp’s screenshots. But unlike g0mp I think I have put all files and folders in the right place. Could anyone please give me a clue what I am doing wrong. I am on 2.0.8-pl. There is a screenshot attached showing the folder structure on the server.
      Any help is greatly appreciated, thanks in advance!
        • 11076
        • 159 Posts
        @joeblow , i put everything in place. and followed the wiki tutorial step by step. tried even a fresh install over 2.0.8.
        still no success, can’t save, the save button does nothing.

        has a similar error log as you described
        [2011-02-27 10:44:44] (ERROR @ /mdx8/connectors/security/user.php) Could not get table name for class: modAccess
        [2011-02-27 10:44:45] (ERROR @ /mdx8/connectors/security/user.php) Error 42000 executing statement: 
        Array
        (
            [0] => 42000
            [1] => 1064
            [2] => 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 'AS `modAccess` WHERE `modAccess`.`principal` = 4' at line 1
        )
        
        [2011-02-28 11:18:57] (ERROR @ /mdx8/connectors/element/tv/renders.php) Could not cache context settings for mgr.
        [2011-02-28 11:20:31] (ERROR @ /mdx8/assets/components/xdbedit/connector.php) Error 42S02 executing statement: 
        Array
        (
            [0] => 42S02
            [1] => 1146
            [2] => Table 'mdx8.modx_example_telephonedir' doesn't exist
        )
        
        [2011-02-28 11:20:31] (ERROR @ /mdx8/assets/components/xdbedit/connector.php) Error 42S02 executing statement: 
        Array
        (
            [0] => 42S02
            [1] => 1146
            [2] => Table 'mdx8.modx_example_telephonedir' doesn't exist
        )
        
        [2011-02-28 11:20:31] (ERROR @ /mdx8/assets/components/xdbedit/connector.php) Could not create table `modx_example_telephonedir`
        
        SQL: CREATE TABLE `modx_example_telephonedir` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT,`name` VARCHAR(255) NOT NULL DEFAULT '',`jobtitle` VARCHAR(255) NOT NULL DEFAULT '',`region` VARCHAR(255) NOT NULL DEFAULT '1',`published` TINYINT(1) unsigned NOT NULL DEFAULT '0',`createdby` INT(10) NOT NULL DEFAULT '0',`createdon` DATETIME NOT NULL,`editedby` INT(10) NOT NULL DEFAULT '0',`editedon` DATETIME NOT NULL,`deleted` TINYINT(1) unsigned NOT NULL DEFAULT '0',`deletedon` DATETIME NOT NULL,`deletedby` INT(10) NOT NULL DEFAULT '0',`publishedon` DATETIME NOT NULL,`publishedby` INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=MyISAM
        ERROR: Array
        (
            [0] => 42S01
            [1] => 1050
            [2] => Table 'modx_example_telephonedir' already exists
        )
        
        [2011-02-28 11:20:31] (ERROR @ /mdx8/assets/components/xdbedit/connector.php) Error 42S01 attempting to create object container for class Telephonedir:
        Array
        (
            [0] => 42S01
            [1] => 1050
            [2] => Table 'modx_example_telephonedir' already exists
        )


        What MySQL Version are you using? (I’m usign 5.1.41 maybe it something to do with the version, don’t know)
          Michael Shraibman( gOmp)  | Freelance Design & Development | wink  impossible is nothing...
          • 14397
          • 14 Posts
          hello g0mp,
          my MYSQL version is 5.1.54 so this might not be the reason. I also reinstalled everything from scratch and followed all the steps but clicking the save button still doesn’t have any effect.
          I really don’t know what to do now.
            • 11076
            • 159 Posts
            Quote from: joeblow at Feb 28, 2011, 10:16 AM

            hello g0mp,
            clicking the save button still doesn’t have any effect.
            I really don’t know what to do now.
            I think it’s have something to do with the lack of TinyMCE which probably triggers the save button.
            see here:
            assets/components/xdbedit/js/widgets/xdbedit.panel.js (lines 49-51)
                ,beforeSubmit: function(o) {
                    tinyMCE.triggerSave(); 
                }
            


            so installing TinyMCE will bring it to life.
            maybe it’s worth mentioning in the wiki.
            hope it works for you.

            p.s. it’s still doesn’t explain those errors from the log about the classes & table creation and so.
              Michael Shraibman( gOmp)  | Freelance Design & Development | wink  impossible is nothing...
              • 14397
              • 14 Posts
              Wow, you are right! That did the trick.
              Thank you very much!
                • 9710
                • 24 Posts
                Quote from: Wanze at Feb 16, 2011, 03:38 PM

                [
                Thanks for your answer.
                I’m running revo 2.0.7 on a default xammp installation with mac. The project ist not yet online :/
                I made exactly the same change as you with your telephonedir-example an i’m getting the same error.
                I’ve made two screenshots, one before adding the image-tv to the name filed, the second afterwards...
                Seems that modx does not load the ExtJs stuff right? Very strange...
                At least i know it must be a specific problem... thank you! Will make more tests...

                Grüsse aus der Schweiz laugh

                Could you solve this problem? I experience the same issue with a fresh 2.0.8pl install (and 2.1 - exactly the same) and the telephondir example sad

                The image field messed up everything...

                  • 4172
                  • 5,888 Posts
                  what exactly is your issue?
                  btw. xdbedit is not tested on 2.1, yet
                    -------------------------------

                    you can buy me a beer, if you like MIGX

                    http://webcmsolutions.de/migx.html

                    Thanks!
                    • 9710
                    • 24 Posts
                    Quote from: Bruno17 at Apr 03, 2011, 03:17 PM

                    what exactly is your issue?
                    btw. xdbedit is not tested on 2.1, yet
                    Just look at the screenshots in post #60. When using an image tv, the whole layout crashes. I only changed the region tv from dropdown to image (like you did in #58) and it stopped working..

                    It a fresh install of 2.0.8pl-traditional, just for testing and developing purpose - so I could give you manager access if you want to.
                      • 4172
                      • 5,888 Posts
                      Quote from: Firebird at Apr 04, 2011, 04:18 AM

                      It a fresh install of 2.0.8pl-traditional, just for testing and developing purpose - so I could give you manager access if you want to.

                      This would be the fastest for us, I think.
                        -------------------------------

                        you can buy me a beer, if you like MIGX

                        http://webcmsolutions.de/migx.html

                        Thanks!