Image URLs too long for dB field

Submitted by ChrisNBC on Fri, 2013-08-16 09:57 in Price Tapestry

Hi David,

Now the mobile data feeds are loading, I have come across an issue...I have noticed that when I load the o2 feed that the image URL is so long it sometimes extends beyond the 255 characters available in the table field. I wondered if this is something you have come across before and if there is a simple fix to get around this issue?

Thanks in advance.

Regards
Chris

Hi Chris, Apply the

Submitted by support on Fri, 2013-08-16 10:53

Hi Chris,

Apply the following dbmod.php script to convert to VARCHAR(1024)

<?php
  require("includes/common.php");
  $sql = "ALTER TABLE `".$config_databaseTablePrefix."products`
            CHANGE `image_url` `image_url` VARCHAR(1024) NOT NULL default ''";
  database_queryModify($sql,$result);
  print "Done.";
?>

Cheers,
David.
--
PriceTapestry.com

Thanks David, that's fixed

Submitted by ChrisNBC on Fri, 2013-08-16 17:16

Thanks David, that's fixed it!...

Have a good weekend.
Regards
Chris