coppermine-gallery.com/forum

Support => Older/other versions => cpg1.1.X Support (standalone) => Topic started by: Trev98 on October 20, 2003, 06:48:41 PM

Title: Images upload, don't display
Post by: Trev98 on October 20, 2003, 06:48:41 PM
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.
Title: Images upload, don't display
Post by: Trev98 on October 21, 2003, 09:37:05 AM
No ideas?
Title: Images upload, don't display
Post by: Zarsky on October 21, 2003, 03:20:04 PM
spaces work on my end...what OS and is your host running under?  Do you know what file system they are using?
Title: Images upload, don't display
Post by: Trev98 on October 21, 2003, 08:36:36 PM
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.
Title: Images upload, don't display
Post by: Joachim Müller on October 22, 2003, 09:13:29 AM
give us a test account of a user who is allowed to upload, so we can test...

GauGau
Title: Images upload, don't display
Post by: Trev98 on October 22, 2003, 10:55:52 AM
OK -

username: coppermine
password: cop790

thanks!
Title: Images upload, don't display
Post by: Joachim Müller on October 22, 2003, 10:50:47 PM
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
Title: Images upload, don't display
Post by: Trev98 on October 22, 2003, 11:33:21 PM
It didn't show correctly, but the file uploaded. I'm not sure how much you need dumped, but here's the beginning structure:
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:

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);