Print

[Trev98]

I have a problem where images with spaces uploaded to the gallery don't display (they get the dreaded X pic from IE). I checked the directories and the files exist. Is there a fix to this? Thanks.

[Trev98]

No ideas?

[Zarsky]

spaces work on my end...what OS and is your host running under?  Do you know what file system they are using?

[Trev98]

Hi - someone else uploaded a file with spaces and no pic...hmm. My host (Freeservers) is running Linux with PHP v. 4.1.2. I'm not sure which file system they're using.

[Joachim Müller]

give us a test account of a user who is allowed to upload, so we can test...

GauGau

[Trev98]

OK -

username: coppermine
password: cop790

thanks!

[Joachim Müller]

I just uploaded a pic with a space in the filename, but I can't see the result, because you have activated admin approval. If it doesn't show correctly, could you show us the dump of this particular db entry (use phpMyAdmin)?

GauGau

[Trev98]

It didn't show correctly, but the file uploaded. I'm not sure how much you need dumped, but here's the beginning structure:

Code: [Select]

CREATE TABLE `cpg11d_pictures` (
  `pid` int(11) NOT NULL auto_increment,
  `aid` int(11) NOT NULL default '0',
  `filepath` varchar(255) NOT NULL default '',
  `filename` varchar(255) NOT NULL default '',
  `filesize` int(11) NOT NULL default '0',
  `total_filesize` int(11) NOT NULL default '0',
  `pwidth` smallint(6) NOT NULL default '0',
  `pheight` smallint(6) NOT NULL default '0',
  `hits` int(10) NOT NULL default '0',
  `mtime` timestamp(14) NOT NULL,
  `ctime` int(11) NOT NULL default '0',
  `owner_id` int(11) NOT NULL default '0',
  `owner_name` varchar(40) NOT NULL default '',
  `pic_rating` int(11) NOT NULL default '0',
  `votes` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `caption` text NOT NULL,
  `keywords` varchar(255) NOT NULL default '',
  `approved` enum('YES','NO') NOT NULL default 'NO',
  `user1` varchar(255) NOT NULL default '',
  `user2` varchar(255) NOT NULL default '',
  `user3` varchar(255) NOT NULL default '',
  `user4` varchar(255) NOT NULL default '',
  `url_prefix` tinyint(4) NOT NULL default '0',
  `randpos` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pid`),
  KEY `pic_hits` (`hits`),
  KEY `pic_rate` (`pic_rating`),
  KEY `aid_approved` (`aid`,`approved`),
  KEY `randpos` (`randpos`),
  KEY `pic_aid` (`aid`),
  FULLTEXT KEY `search` (`title`,`caption`,`keywords`,`filename`)
) TYPE=MyISAM AUTO_INCREMENT=86 ;


And here's the specific dump of your upload:

Code: [Select]

INSERT INTO `cpg11d_pictures` VALUES (85, 14, 'userpics/10052/', 'fruit 5.jpg', 5820, 8913, 223, 171, 1, 20031022154950, 1066855728, 52, 'coppermine', 0, 0, 'Just a test', 'testing, please delete', '', 'NO', '', '', '', '', 0, 0);