Followed README steps to the letter, unable to locate any links to admin/settings/webfm but was able to go to that path. However, page displays nothing but "settings" in bold and two buttons for Save and Reset.

Drupal 4.7.6
Apache 2.0.55
PHP 4.4.2-1.1
5.0.24a-Debian_9-log

Also, in the README, lines 38-39 say to create the two directories within the 'File system path' directory, and my assumption is that these directories are parallel to one another. Is this correct?

Comments

robmilne’s picture

robmilne commented

I cannot explain why you don't see the settings page properly - not an issue that has come up before. Try flushing the various caches as well as the menu cache (go to admin/menu to renew menu cache). You might want to try uninstalling and reinstalling the module.

The two directories are parallel (one is db controlled, the other is not - don't put one into the other).

silurius’s picture

silurius commented

Thank you for the super-quick response. I unchecked the module, saved modules, uploaded the webfm dir back into the modules directory (overwriting everything), refreshed modules, rechecked webfm, saved, and ran update.php just for the heck of it. Problem unchanged. Also, before I saw your response and did these things (but after the original problem) I noticed that when I navigated from the admin area back to the front page, I got an error I hadn't seen before:

user warning: Table 'registrar.drupal_webfm_file' doesn't exist query: SELECT * FROM drupal_webfm_file f INNER JOIN drupal_webfm_attach a ON f.fid = a.fid WHERE a.nid = 1 ORDER BY a.weight in /var/www/examplesite/includes/database.mysql.inc on line 121.

robmilne’s picture

robmilne commented

Does drupal work without webfm (the 'examplesite' in the url has me concerned)? If you have access to mysql (either phpmyadmin or cmdline), does the webfm_file table exist? If not then the install failed and you may have to build the webfm tables by hand.

silurius’s picture

silurius commented
Title: No admin/settings/webfm link & no settings options on page » Tables webfm_file & webfm_attach weren't created

Oh yes the site does actually work fine outside of wfm. It's practically brand-new as far as the database go. I actually only edited that text in my post above (but neglected another edit - see if you can find Waldo).

And no, that table did not get created. That must be the cause. Does this SQL look correct for manually setting that up (grabbed from webfm.install & inserted my own table prefix)?

CREATE TABLE {drupal_webfm_file} (
        fid int(10) NOT NULL auto_increment,
        uid int(10) NOT NULL default '0',
        fpath longtext NOT NULL,
        fname varchar(255) NOT NULL default '',
        fsize int(10) NOT NULL default '0',
        fmime varchar(255) NOT NULL default '',
        ftitle varchar(255) NOT NULL default '',
        fdesc text NOT NULL,
        fcreatedate int(11) NOT NULL default '0',
        flang varchar(16) NOT NULL default '',
        fpublisher varchar(255) NOT NULL default '',
        fformat varchar(255) NOT NULL default '',
        fversion int(10) NOT NULL default '0',
        PRIMARY KEY (`fid`)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      db_query("CREATE TABLE {drupal_webfm_attach} (
        nid int(10) NOT NULL default '0',
        fid int(10) NOT NULL default '0',
        list tinyint(4) NOT NULL default '0',
        weight int(10) NOT NULL default '0',
        PRIMARY KEY (`nid`,`fid`)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;
silurius’s picture

silurius commented
Title: Tables webfm_file & webfm_attach weren't created » Better SQL

I mean:

CREATE TABLE {drupal_webfm_file} (
        fid int(10) NOT NULL auto_increment,
        uid int(10) NOT NULL default '0',
        fpath longtext NOT NULL,
        fname varchar(255) NOT NULL default '',
        fsize int(10) NOT NULL default '0',
        fmime varchar(255) NOT NULL default '',
        ftitle varchar(255) NOT NULL default '',
        fdesc text NOT NULL,
        fcreatedate int(11) NOT NULL default '0',
        flang varchar(16) NOT NULL default '',
        fpublisher varchar(255) NOT NULL default '',
        fformat varchar(255) NOT NULL default '',
        fversion int(10) NOT NULL default '0',
        PRIMARY KEY (`fid`)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
CREATE TABLE {drupal_webfm_attach} (
        nid int(10) NOT NULL default '0',
        fid int(10) NOT NULL default '0',
        list tinyint(4) NOT NULL default '0',
        weight int(10) NOT NULL default '0',
        PRIMARY KEY (`nid`,`fid`)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;
silurius’s picture

silurius commented
Title: Better SQL » No admin/settings/webfm link & no settings option on page

Whoops, replacing original title (treated this as a standard Drupal forum post).

robmilne’s picture

robmilne commented

If your mysql is 4.1:

CREATE TABLE webfm_file (
fid int(10) NOT NULL auto_increment,
uid int(10) NOT NULL default '0',
fpath longtext NOT NULL,
fname varchar(255) NOT NULL default '',
fsize int(10) NOT NULL default '0',
fmime varchar(255) NOT NULL default '',
ftitle varchar(255) NOT NULL default '',
fdesc text NOT NULL,
fcreatedate int(11) NOT NULL default '0',
flang varchar(16) NOT NULL default '',
fpublisher varchar(255) NOT NULL default '',
fformat varchar(255) NOT NULL default '',
fversion int(10) NOT NULL default '0',
PRIMARY KEY (`fid`)
)DEFAULT CHARSET=UTF8;

CREATE TABLE webfm_attach (
nid int(10) NOT NULL default '0',
fid int(10) NOT NULL default '0',
list tinyint(4) NOT NULL default '0',
weight int(10) NOT NULL default '0',
PRIMARY KEY (`nid`,`fid`)
)DEFAULT CHARSET=UTF8;

If the db is 4.0 leave out the 'DEFAULT CHARSET=UTF8' bits.

The other alternative is to remove all references to webfm in the system table and try the install file again.

silurius’s picture

silurius commented

Aha, for whatever reason, dropping the tables, deleting the references from the system table, and re-enabling the module did the trick. Oh and my MySQL is 5.0.24a-Debian_9-log.

robmilne’s picture

robmilne commented
Status: Active » Closed (fixed)