We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 32241
    • 1,495 Posts
    SO NICE!

    Keep it up Susan. I think this will be one of those snippet that will attract more people to MODx.
      Wendy Novianto
      [font=Verdana]PT DJAMOER Technology Media
      [font=Verdana]Xituz Media
    • When I get the ShopX update finished (fully AJAX-based backend management module in the MODx Manager, separate database tables for the entire catalog, making use of the existing webuser_attributes table for persistant cart and purchasing history, completely modular code for easy adding of custom features...) I’ll tackle a similar rewrite of DocMan. Wait for it!
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 17883
        • 1,039 Posts
        fully AJAX-based backend management module in the MODx Manager, separate database tables for the entire catalog, making use of the existing webuser_attributes table for persistant cart and purchasing history, completely modular code for easy adding of custom features...

        shocked

        This rocks!
        • A lot of blood, sweat, tears, and teeth-gnashing and hair-pulling, but also a lot of fun! I love learning how to do new stuff! See this topic for a guest login to follow the progress.

          http://modxcms.com/forums/index.php/topic,3210.msg22939.html#msg22939
            Studying MODX in the desert - http://sottwell.com
            Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
            Join the Slack Community - http://modx.org
            • 15159
            • 93 Posts
            Susan,

            I am getting this error when I click "Tidy" I can’t seem to track down why. The docman is working great otherwise.

            MODx encountered the following error while attempting to parse the requested resource:
            « Execution of a query to the database failed - Unknown table ’files_perms’ in MULTI DELETE »
            SQL: DELETE FROM `modx`.files_perms USING `modx`.files_perms fp LEFT JOIN `modx`.modx_web_groups wg ON wg.webuser = fp.uid WHERE wg.webuser IS NULL
            [Copy SQL to ClipBoard]

            Parser timing
            MySQL: 0.0000 s s (0 Requests)
            PHP: 0.0809 s s
            Total: 0.0809 s s



            Also, no matter what changes I make to CSS, I can not seem to effect the appearance of DocMan at all. Is there a secret swith here somewhere?
            • As for the database error, check the database and make sure that table is there. Perhaps it didn’t get created.

              Are you editing the docman.css file in docman/style? Make sure your link to the stylesheet comes after the link to your main stylesheet.
                Studying MODX in the desert - http://sottwell.com
                Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                Join the Slack Community - http://modx.org
                • 16535
                • 5 Posts
                Hi, first i want to thanks Sottwel for this nice snippet smiley

                I’m installing it on a new MODx site, and, as it’s a french language site, i noticed a couple of glitches with the text fields in the queries : the script don’t tidy the strings to make them mysql-compatible (escaping quotes, especially). So i added some mysql_real_escape_string() function in add.php and update.php smiley

                By the way, i was having the same sql problem than jwtyler ("Tidy" function), it seems to be a MySQL bug :

                http://bugs.mysql.com/bug.php?id=4630

                So i replaced the aliases with full table names, it works smiley