Forums / General Questions / Image File Name Length How To Change?

Image File Name Length How To Change?

Locked

Started by kenaniah on 18 Jul 2006, 3:07 AM · Views: 3,683

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
18 Jul 2006, 3:07 AM
#1
kenaniah avatar

kenaniah

Zen Follower

Join Date:
Jun 2005
Posts:
111
Plugin Contributions:
0

Image File Name Length How To Change?

Hello, It appears in the 1.3 versions that the image file names have been limited to 60 characters for their length. Could someone direct me to the location where I can change this back to the previous versions length?

Thank you,

Michael

18 Jul 2006, 3:08 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Image File Name Length How To Change?

Images are stored in the products table in the products_image field ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

18 Jul 2006, 3:13 AM
#3
kenaniah avatar

kenaniah

Zen Follower

Join Date:
Jun 2005
Posts:
111
Plugin Contributions:
0

Re: Image File Name Length How To Change?

Thanks Linda. I have increased a few field lengths and this may have been one of them.

:)

7 Aug 2009, 5:48 PM
#4
jshope avatar

jshope

New Zenner

Join Date:
Nov 2005
Posts:
1
Plugin Contributions:
0

Re: Image File Name Length How To Change?

Is there a reason the image name is kept to 64 characters in the database? (I'm running the latest 1.38a) I ran across this problem because I want to use more descriptive names for the image files as well as the subfolders.

If you use subfolders to organize your images, the length of the subfolder name is included as part of the allowed 64 character length of the image file name. Is there any reason that I shouldn't switch the product_images field to allow 128 or even 256 characters? How would this be handled when upgrading in the future? I think it would be just a matter of changing the fields length again before uploading the previous versions database?

Any advice is appreciated,
~jim

7 Dec 2011, 3:43 PM
#6
robert9241 avatar

robert9241

New Zenner

Join Date:
Aug 2011
Location:
Florida
Posts:
4
Plugin Contributions:
0

Re: Image File Name Length How To Change?

My personal resolution to this problem was to go into MySQL under my stores database. In the left panel of the screen there are two listings one is information_schema and the other is the name of the database. Click on the plus sign to the left and the list of tables will open. Then I found the products table and clicked on it. This opened up a list of tables in the right panel. I found the one listed as product_image, located the icon for change and clicked it, then edited the field "length/values". I put 256 I haven't seen any major issues yet. Though I am new to this arena and do not consider myself an authority on this subject. I am merely passing on my resolution and if there are better suggestions I do welcome them.

13 Mar 2012, 2:18 PM
#7
sunrisecc avatar

sunrisecc

New Zenner

Join Date:
Oct 2011
Location:
Toronto, Ontario
Posts:
9
Plugin Contributions:
0

Re: Image File Name Length How To Change?

In 1.5, I have altered the schema and changed the field size to 128 from 64. Field name = products_image.

Seymour