Drupal problems and miss-features

Beware that Drupal has several miss-features and bugs as any product. Some may be fixed in later versions and we will enumerate by version to be sure to remove any confusion.

• Version 4.6
  • Create Content - import images
    From the admin account, this will upload images with several miss-feature and defaults improper for public display. Manua repair is needed thereater to fix this so, use at your own risk (or automate changes in a cron).
    
    • When importing, the images are first not published and not promoted. To fix this, you need to access the database and use the following command:
      mysq> UPDATE node SET promote=1 WHERE promote=0 AND type='image';
      mysql> UPDATE node SET status=1 WHERE status=0 AND type='image';
    • nodes do not have the proper access protection information which will prevent image sharing. There were no options to fix this in image import. So, two manual steps are needed ; the first command needs to be piped to an external file (let's call it bla.txt)
      mysql> SELECT node.id FROM node LEFT OUTER JOIN node_access ON node.nid=node_access.nid WHERE node_access.nid IS NULL;
      % cat bla.txt | grep '|' | awk '{print "INSERT IGNORE INTO node_access VALUES("$2",0,\"og_group\",1,0,0);"}' >insert.mysql
      mysql> source insert.mysql;
  • administer - settings - filemanager
    The filemanager HTML field Public file system url is terribly miss-leading. What you see in there is NOT what you have set. The best recommendation is to
    • fill all the other field and leave this one empty
    • Click the [Save Configuration] button.
    • Clear the box again and enter something like http://drupal.star.bnl.gov/STAR/files (for a path ending with files)
    • Click the [Save Configuration] button.
    • Verify a previously attached document that it is really recoverable ...