X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Forum FAQs and guides (https://forum.x-cart.com/forumdisplay.php?f=30)
-   -   getting pics out of db (https://forum.x-cart.com/showthread.php?t=8438)

mark_d 02-04-2005 08:38 AM

Hello all,

I'm trying to get the images to be stores NOT IN FILES directory,

I want the here.


So, the directory for the images is at the same directory level as x-cart.

I see how I can change the template files to display the to the customer. BUT, why does the full paths that are asked (durring import, products and detail images) for not being used, if they HAVE to be in the x-cart/FILES directory, why ask for the full path?

Also, I did a complete install of the V4.0.11 and the config.php had that extra last line feed inthe config.php - no one fix that for how many versions..??

Any input/direction/enlightenment would be greatly appreciated.


rjcbear 02-04-2005 09:23 AM


When you are importing your images using a cvs file X-cart uses the path to find and load the images into the DB. Once they are loaded in the DB they get assing a name that has to do with your product number and after you take them out of your DB they will be named as follows:

t_######.jpg for thumbnails
d_#####.jpg for detailed images

I hope this will help you

Kind regards,

mark_d 02-04-2005 09:29 AM

My images were never in the database - I CANT toooo many for even for temp (10MB database size limit) So I want to import right into the file system.

But, thanks, I think what I needed to know is that (if I am correct?)

The paths asked at import ARE ONLY for importing and NOT for displaying?
In other words;

The full path to images specified durring product and detail image import, are ONLY to read and insert BLOB into the database when 'Stored in database' option is used.

Am I understanding correctly?


Danielle 02-06-2005 07:44 PM

OK, I followed the first post exactly, but everything failed...anyone have any ideas???


Dybbuk 02-24-2005 08:12 AM


Originally Posted by cotc2001
Ok i've found out that it just won't export from the database to the filesystem BUT if i delete all detailed images from products and then change the image location and then upload a detailed image it WILL then place it into the file system.

Very, Very strange


I had exactly the same problem affecting the thumbnail directory having already added images to the database.

The only way I could remove thumbnail images from the database in order to set up an image file directory was to install phpMyAdmin and truncate the xcart_thumbnails table in mysql. This cleared the images and allowed me to change the image location in xcart from database to file directory.

Works fine now.


Danielle 02-24-2005 02:15 PM

And then you had to reupload all your pics right???

Danielle 02-27-2005 08:31 AM

Can someone help me with this? I am trying to switch my pics to the file system, but they keep saying failed. My permissions are 777. I really do not want to have to reupload all my pics as I have a TON. Does anyone know I make the switch?


Danielle 02-27-2005 08:46 AM

Whew OK I finally got them to move and it says success. BUT, the images are all still in my database. I tried the optimize table thing suggested earlier in this thread and it did nothing. Even worse, I tried deleting a few of the images from the database manually, and now the thumbnail isn't showing. I looked and all the images are in the file system like they're supposed to be. Why aren't they showing on the product?


balinor 02-27-2005 08:49 AM

Make sure they successfully transferred. You should now have images in your Files directory, and the Images location should say File System.

Danielle 02-27-2005 08:55 AM

Yep, the images are in the folders in the file system and the image location says file system. It all worked perfectly except that the images are still coming from the database, because if I delete an image in the database, it makes the product image disappear.

All times are GMT -8. The time now is 10:42 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.