I have installed the 5.x-3.1 version whit all support modules, but i have this error:

user warning: Colonna sconosciuta 'fstatus' in 'field list' query: dbfm_build_dir_list SELECT fid, fpath, fname, fauthor, fsize, fstatus, fversion, fnewver, fmime, flastmod, fimagesize, fwaccess, fraccess FROM dbfm_file WHERE fparent = 1 in C:\Programmi\EasyPHP 2.0b1\www\drupal\includes\database.mysql.inc on line 172.

What i have to do?
I'm not a programmer and I don't understand this language, please help me :)

Comments

rooey’s picture

rooey commented

Double check you have the right versions of the required modules installed and that you are using PHP5.

rooey’s picture

rooey commented
Title: I have an error » unknown column 'fstatus' in 'field list' query dbfm_build_dir_list
rooey’s picture

rooey commented

I've checked the installer and the fstatus column is defiantly present. Disable DBFM, uninstall it, and re-enable it again.

matteo82’s picture

matteo82 commented

I have checked and all is right, and my PHP is 5.2.0, Drupal is 5.7,
MySQL is 5.0.27, Apache/2.2.3 (Win32), dbfmgreybo 5.x-2.0, Tabs 5.x-0.6, Javascript tools 5.x-0.6, dapi 5.x-1.0

I have done all you say, but i still have this error.

rooey’s picture

rooey commented

open a mysql prompt and run the command:

desc dbfm_file;

send the results back here.

M.

matteo82’s picture

matteo82 commented

ok....

Campo Tipo Null Predefinito
fid int(10) No
uid int(10) No 0
fpath varchar(255) No
fname varchar(255) No
fsize int(10) No 0
fmime varchar(255) No
ftitle varchar(255) No
fdesc text Sì NULL
fkeywords text Sì NULL
fcreatedate datetime No changed from the original int(11)
flang int(2) No 0
fversion int(10) No 0
fnewver varchar(30) Sì
flastmod datetime No
fparent int(10) No 0 the parent fid, a directory id
fimagesize varchar(16) No 0 holds image size as a text string
fimageh int(4) No 0
fimagew int(4) No 0
fdown int(4) No 0 a bit generous with the size!
fauthor varchar(50) No
fclass int(2) Sì NULL
fdistribution int(4) No 0
fwaccess int(1) No 0
fraccess int(1) No 0
fchild int(10) No 0
fblobmod datetime No
fmd5 varchar(32) No

rooey’s picture

rooey commented

I don't know quite how you've ended up with this schema.

run this manually in mysql:

DROP TABLE IF EXISTS `dbfm_file`;
CREATE TABLE `dbfm_file` (
  `fid` int(10) NOT NULL auto_increment,
  `uid` int(10) NOT NULL default '0',
  `fpath` varchar(255) 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,
  `fcreatedate` datetime NOT NULL COMMENT 'changed from the original int(11)',
  `flang` int(2) NOT NULL default '0',
  `fversion` int(10) NOT NULL default '0',
  `fnewver` varchar(30) default '',
  `flastmod` datetime NOT NULL,
  `fparent` int(10) NOT NULL default '0' COMMENT 'the parent fid, a directory id',
  `fimagesize` varchar(16) NOT NULL default '0' COMMENT 'holds image size as a text string',
  `fimageh` int(4) NOT NULL default '0',
  `fimagew` int(4) NOT NULL default '0',
  `fdown` int(4) NOT NULL default '0' COMMENT 'a bit generous with the size!',
  `fauthor` varchar(50) NOT NULL default '',
  `fclass` int(2) default NULL,
  `fstatus` int(4) unsigned default NULL,
  `fkeywords` text,
  `fdistribution` int(4) unsigned NOT NULL default '0',
  `fwaccess` int(1) unsigned NOT NULL default '0',
  `fraccess` int(1) unsigned NOT NULL default '0',
  `fchild` int(10) NOT NULL default '0',
  `fblobmod` datetime NOT NULL,
  `fmd5` varchar(32) NOT NULL,
  PRIMARY KEY  (`fid`),
  UNIQUE KEY `fid` (`fid`),
  KEY `fpath` (`fpath`),
  KEY `fparent` (`fparent`)
) ENGINE=MyISAM AUTO_INCREMENT=17480 DEFAULT CHARSET=utf8;
matteo82’s picture

matteo82 commented

Good, it's all ok now, tanks very much :)

matteo82’s picture

matteo82 commented
Status: Active » Fixed
Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.