After Upgrade - no images...: WSN Support

WSN Support » WSN Gallery » After Upgrade - no images... » After Upgrade - no images...

After Upgrade - no images...

Version: 4.1.5
Example URL: http://www.nativespeakers.lv/dpalbums3

After Upgrade - no images...

jeremy71
Member

Usergroup: Customer
Joined: Jan 19, 2006
Total Topics: 6
Total Posts: 17

Posted 09/10/08 - 11:49 PM:	#1
Hi, After weeks of database wrestling, attachment uploading and general swearing Ive managed to update from a very early version to 4.1.5. The upgrade.php script didnt seem to work properly and the site is in Latvian so there is always problems with fonts and encodings but Ive got it to a stage where it should be working.... it almost is, categories are ok, image listings are there the only thing missing are the actual images. Ive added a new image ( post upgrade) and it seems to show up correctly ( have a look on the site) but the others arent showing at all. Ive turned on debug, regenerated everything, attachments tree is off, tried almost everything I can think of. Here is a dump of the two last entries on the links table. To my eye they look exactly the same ( the first one, 4090, is from existing image list and 4091 is the test I uploaded after upgrade). The image for 4090 IS in the attachments folder - http://www.nativespeakers.lv/dpalbums3/attachment.... I cant for the life of me figure out what is wrong.... please help....thanks (4090, 'Melno parâde.', 'Jânis no Lingenas DP nometnes diençja Bikeburgâ. Bijuðie latvieðu leìionâri un ìimnâziju beiguðie zçni atrada darbu un diençja angïu militârâs sardþu un transporta vienîbâs. Parastâ valodâ ðîs vienîbas tika sauktas par melno vienîbâm vai „melniem” jo viòi valkâja angïu armijas formas nokrâsotas melnas.', 0, 0, 1, 172, 0, '', 1216607842, 2, 0, 0, 258, '69.14.152.77 ', '258 ', 1217032855, 'regular', 'scan001211.jpg', 'scan0012.jpg', '', 0, '', 48545, 498, 750, '', 0, 0, 0, 0, 0, '69.14.152.77', 0, 0, 0, '', '', 0, '\|\|\|\|\|\|', 0, '', '', '2', 'V. Mucenieks', '2155 Minnetonka Blvd, Greenwood, MN, 55331, ASV', 'Angïu zona', 'Vîri formas tçrpos stâv ierindâ.', 'Ðîs bildes un stâsts ir no Jâòa Leitis albuma un piezîmçm. Jânis no Dikïu pagasta kaºa beigâs nonâca gûstâ Itâlijâ. Pçc atlaiðanas no gûsta apmetâs Zçdorfas, Bodenteichas un Dedelosdorfas DP nometnçs, kur satika un apprecçja Annu Mucenieks ar ìimeni, bijuðâ latvieðu leìionâra Mucenieka atraitni, kurð mira no gûstâ iegûtâs slimîbas. Vçlâk Jânis ar ìimeni dzîvoja Lingenas DP nometnçs un diençja angïu zonas sardþu vienîbâ Bikeburgâ. 1951. gada 6. jûnijâ, kad legâli atïâva Amerikâ ieceïot bijuðiem latvieðu leìionâriem, Jânis Leitis ar ìimeni ieradâs ASV. ', '', 'Darbs, peïòa\|\|\|melno vienîbas', 'Otrais Jânis Leitis.', '', '', '', '23', '7', '2008', 'Edgars', '', '', '', '', '952-474-3493', '', '', '1948. gadâ.', '', '', '', 7, '\|\|\|4\|\|\|', 0, 0, '', '', 0, '', '', 0, '', 0, 0, 0, '', '', '', '', 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 0, '', 0, '', 0, '', 'http://www.nativespeakers.lv/dpalbums3/memberlist.php?action=profile&id=0', '', 0, 0), (4091, 'Test', '', 0, 0, 1, 136, 0, '', 1221114140, 0, 0, 0, 1, '', '', 1221114140, 'regular', 'dsc0015994d6.jpg', 'DSC00159.JPG', '', 0, '', 41348, 0, 0, '', 0, 0, 0, 0, 0, '62.84.16.203', 0, 0, 0, '', '', 0, '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 6, '', 0, 0, '', '', 0, '', 'admin', 0, '', 0, 0, 1221114140, '1', '', '', '', 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 0, '', 0, '', 0, '', 'http://www.nativespeakers.lv/dpalbums3/memberlist.php?action=profile&id=1', '', 0, 0);

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6339

Posted 09/11/08 - 02:35 PM:	#2
Looking at your HTML source, there's simply no <img src> trying to call an image. This suggests that it doesn't see anything in the database. To give useful advice I'd have to know what version you were upgrading from, but from some ancient versions you may need to run the attachments importer which the upgrade linked to at the end of the first run. You can go back to it manually by visiting attachimport.php. I just checked that for you and it seems to not change anything, though. Go into phpmyadmin and click on the wsngallery_attachments table, then go to the "browse" tab. How many records does it show? Is that the number of images you expect to have? If so, check if the filename field is filled in for them. If not, run this SQL: SELECT * FROM wsngallery_links WHERE filename != ''; Does that give any results? 'scan001211.jpg', 'scan0012.jpg' This part of your record suggests that attachimport.php didn't run successfully -- when it runs, it's supposed to remove the file names from the wsngallery_links table after transfering them to the wsngallery_attachments table. I can't recall which version needed attachimport.php, but it was several years ago so it's possible the file has broken since then. I'll try to test it but I don't know what version number I should be testing. Also, turn debug mode off -- images won't load with debug mode on and there are no mysql warnings involved so it's not helping. Please try to stay within a year of current, it's virtually impossible to ensure that upgrades are easy beyond that timeframe. Though I'm going to be writing an importer to handle everything from the pre-4.1 era the same as if it were importing from another script, soon. Edited by Paul on 09/11/08 - 02:41 PM
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.

Please login or register.