double-happiness Posted January 29, 2010 Posted January 29, 2010 I am using osCommerce Online Merchant v2.2 RC2a and Easy Populate 2.76h-MS2 I have tried to update my inventory via Easy Populate (Upload and Import EP File, Update Only) but none of the images are displaying correctly, all the image urls are truncated, for example http://i563.photobucket.com/albums/ss76/double_-_happiness/AAA/A instead of http://i563.photobucket.com/albums/ss76/double_-_happiness/AAA/AntoninDvorakBerlinPhilharmonicOrch.jpg (hover your mouse cursor over to se the full path) If I try to manually update the Products Image in OSC, my browser just opens a window to browse for a file upload, which is obviously not what I want anwyay as all the jpegs are hosted externally... Any ideas please? I'm baffled, I didn't anticipate this :blink:
germ Posted January 30, 2010 Posted January 30, 2010 I am using osCommerce Online Merchant v2.2 RC2a and Easy Populate 2.76h-MS2 I have tried to update my inventory via Easy Populate (Upload and Import EP File, Update Only) but none of the images are displaying correctly, all the image urls are truncated, for example http://i563.photobucket.com/albums/ss76/double_-_happiness/AAA/A instead of http://i563.photobucket.com/albums/ss76/double_-_happiness/AAA/AntoninDvorakBerlinPhilharmonicOrch.jpg (hover your mouse cursor over to se the full path) If I try to manually update the Products Image in OSC, my browser just opens a window to browse for a file upload, which is obviously not what I want anwyay as all the jpegs are hosted externally... Any ideas please? I'm baffled, I didn't anticipate this :blink: The URL you posted: http://i563.photobucket.com/albums/ss76/double_-_happiness/AAA/A is exactly 64 characters long. From the osC install script: CREATE TABLE products ( products_id int NOT NULL auto_increment, products_quantity int(4) NOT NULL, products_model varchar(12), products_image varchar(64), products_price decimal(15,4) NOT NULL, products_date_added datetime NOT NULL, products_last_modified datetime, products_date_available datetime, products_weight decimal(5,2) NOT NULL, products_status tinyint(1) NOT NULL, products_tax_class_id int NOT NULL, manufacturers_id int NULL, products_ordered int NOT NULL default '0', PRIMARY KEY (products_id), KEY idx_products_date_added (products_date_added) ); Note this line: products_image varchar(64), Thus the image names are truncated at 64 characters. I believe that is what is happening. If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
double-happiness Posted January 30, 2010 Author Posted January 30, 2010 Hi Yes, thanks, that's well spotted but unfortunately doesn't entirely solve the problem I am having... I went into PHPMyAdmin and found the value that controls the max length for image urls - 64 as you say - and put it up to 128, then re-uploaded. The full path was now displayed in the 'edit prouduct' view but alas no images to be seen anywhere :( It seems the problem I am having is now to do with getting OSC to fetch images from an external host rather than the url length which is now resolved as I say. I tried one contribution but it didn't seem to work, perhaps because it required the url to start with www. which mine don't (http://.... only)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.