View Single Post
Old September 29th, 2008, 12:17 PM   #1 (permalink)
websissy
Member
Verified Customer
 
Join Date: Aug 2005
Location: Socorro, NM
Posts: 54
Unhappy Upgraded from v2.42 - 3.03: Images vanish, database damaged

Hello, Chuck,

Well, like the user who reported this problem: Upgrade problem from version 2.5 to 3.2, I tried to upgrade from 2.42 to 3.03 over the weekend. In fact, when it ended up broken and screwed up the first time, I restored from my backup, double-checked everything and tried again. But in the end the results were the same.

Here is a detailed list (with examples) of the problems I found after the upgrade to a classifieds system that was running fine before:

Images associated with each classified through the bigimage columns in the product table (i.e. the ad image and thumbnail and any additional images but NOT those that were embedded in the BODY of the ad using UBB Code) had all disappeared after the upgrade. That means I get no image thumbnails anywhere in the classifieds. I have attached an example of what my category page now looks like for categoory 31.

I note here that during this upgrade the script tries to move ad-associated images from the classifieds/data/ad# directories into "Thumb" and "Large sub-directories INSIDE the /data/ad# directories; but it does not do the same things with the category level data directories. It's the names of images in the category-level directories that seem to be damaged here. The script seems to be messing up image names. Here's an example of the way the image names in the category 31 data directory looks after the upgrade:

Code:
Content visible to verified customers only.
and here is an example of what the image name in the html code for ad 41 (which is in category 31) looks like after the upgrade (notice what happened to the image name for 153TomeGallery.jpg):

Code:
Content visible to verified customers only.
And for the record, here's the mysql query I ran and the way the classifieds database products table row for ad 41 looks after the upgrade:

mysql> select id, bigimage from ppcl_products where id = 41;
Code:
Content visible to verified customers only.
Obviously, I did nothing to cause this (that I KNOW of anyway). Clearly the script went wrong somehow.

In addition to the above issues, I had the same experience as the poster in the other thread I referenced. My config-int.php and config-inc.php files did not get updated even though both files were double-checked before the upgrade to ensure their permissions were 777.

Also, related to the problem the other user reported with getting php errors because things weren't where the program expected them to be, I discovered that the paths to where things were supposed to be in the options section and the config section in the classfieds admin pages had all been wiped out. Once I repaired those paths and set them right again, my template (which had also vanished) and my page headers and footers all-reappeared.

I hope this helps you figure out what went wrong. If I can answer any further questions, please don't hesitate to call me directly at 575-838-0784. In the meantime, I'm going to wait a couple of hours before I use my backup to roll my classifieds back and reinstall the older version.

Thanks! Let me know if I can help, please!

P.S. For some reason, the attachment didn't take so I'm adding it here instead.
Code:
Content visible to verified customers only.

Last edited by websissy; September 29th, 2008 at 12:32 PM.
websissy is offline   Reply With Quote