Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls
 

getting pics out of db

 
Reply
   X-Cart forums > Forum FAQs and guides
 
Thread Tools Search this Thread
  #1  
Old 07-13-2004, 11:51 AM
 
Joshshift Joshshift is offline
 

Advanced Member
  
Join Date: Apr 2004
Posts: 53
 

Default getting pics out of db

this may seem like a dumb question, but i was wondering if i could get a walkthrough on this. i have read all the posts concerning this and couldnt get a real straight answer. i have all my images in my database and want to put them in a "file system" how can i do this, i saw no option in phpmyadmin to do so. am i missing it? i have phpmyadmin version 2.4.0 and mysql version 4.0.20. im really lost on this, any info would be greatly appreciated.

Thanks in advance,

Josh
Reply With Quote
  #2  
Old 07-13-2004, 01:38 PM
  rjcbear's Avatar 
rjcbear rjcbear is offline
 

X-Adept
  
Join Date: Jun 2004
Location: Alabama,U.S.A
Posts: 503
 

Default Re: getting pics out of db

Quote:
Originally Posted by Joshshift
this may seem like a dumb question, but i was wondering if i could get a walkthrough on this. i have read all the posts concerning this and couldnt get a real straight answer. i have all my images in my database and want to put them in a "file system" how can i do this, i saw no option in phpmyadmin to do so. am i missing it? i have phpmyadmin version 2.4.0 and mysql version 4.0.20. im really lost on this, any info would be greatly appreciated.

Thanks in advance,

Josh

Josh,

here, is how to do it.

do not use phpMyadmin.

1.- Login into your store admin section.
2.- Make sure you create the folders on your server for the Thumbnails and the Detail Images and giving the proper permission if you have a UNIX server.
3.- Select "Images location"
Product thumbnails
4.- Store images in "File system"
5.- Type the path of your thumbnails (i.e. ../xcart/files/thumbnails)
Detailed product Images
6.- Store images in "File System"
7.- Type the path of your detail images (i.e. ../xcart/files/details)
8.- Select "Submit" buttom
9.- now create a file name ".htaccess" in the folder that has your Thumbnails and details Images as well.
10.- the htaccess file should have the following line of code
Code:
Allow from all
11.- Make sure the file you created does not have any extention if it does rename it.
12.- upload the .htaccess file to both of your folders where your images are.

and that will do it. If you have any question please drop me a line

Kind regards,
Ricky
__________________
X-CART Gold version 4.0.14 & 4.1.11
Apache Version 1.3.29 (Unix)
EWDHosting-Quality X-cart Hosting
We will always sell you the right shoe and the left one is free.
Reply With Quote

The following user thanks rjcbear for this useful post:
bibi (10-26-2010)
  #3  
Old 07-13-2004, 02:35 PM
 
Joshshift Joshshift is offline
 

Advanced Member
  
Join Date: Apr 2004
Posts: 53
 

Default

thank you very much for your insightful walkthrough ricky.

Thanks,
Josh
Reply With Quote
  #4  
Old 07-13-2004, 02:43 PM
  rjcbear's Avatar 
rjcbear rjcbear is offline
 

X-Adept
  
Join Date: Jun 2004
Location: Alabama,U.S.A
Posts: 503
 

Default

Glad it help you. and maybe some other ones will need it too.

Kind regards
Ricky
__________________
X-CART Gold version 4.0.14 & 4.1.11
Apache Version 1.3.29 (Unix)
EWDHosting-Quality X-cart Hosting
We will always sell you the right shoe and the left one is free.
Reply With Quote
  #5  
Old 08-19-2004, 12:43 PM
 
Aragorn Aragorn is offline
 

Member
  
Join Date: Mar 2004
Location: UK
Posts: 23
 

Default Re: getting pics out of db

Hi rjc,

This is great... I'm also a "newbie"...

Have tried to do this... but I keep getting the message...

Warning: fopen(_htm/home/maxtarco/public_html/store/files/master/t_3.jpg): failed to open stream: No such file or directory in /home/maxtarco/public_html/store/admin/images_location.php on line 136

Warning: Cannot modify header information - headers already sent by (output started at /home/maxtarco/public_html/store/admin/images_location.php:136) in /home/maxtarco/public_html/store/include/func.php on line 181


but I'm not sure what this means or what I'm doing wrong.

All my image files (like 8416.jpg) are located in .../store/files/master

Also... I've uploaded my products in a product file with the .jpg file name in the thumbnail field.


Can you help?

thanks,

Aragorn





Quote:
Originally Posted by rjcbear
Quote:
Originally Posted by Joshshift
this may seem like a dumb question, but i was wondering if i could get a walkthrough on this. i have read all the posts concerning this and couldnt get a real straight answer. i have all my images in my database and want to put them in a "file system" how can i do this, i saw no option in phpmyadmin to do so. am i missing it? i have phpmyadmin version 2.4.0 and mysql version 4.0.20. im really lost on this, any info would be greatly appreciated.

Thanks in advance,

Josh

Josh,

here, is how to do it.

do not use phpMyadmin.

1.- Login into your store admin section.
2.- Make sure you create the folders on your server for the Thumbnails and the Detail Images and giving the proper permission if you have a UNIX server.
3.- Select "Images location"
Product thumbnails
4.- Store images in "File system"
5.- Type the path of your thumbnails (i.e. ../xcart/files/thumbnails)
Detailed product Images
6.- Store images in "File System"
7.- Type the path of your detail images (i.e. ../xcart/files/details)
8.- Select "Submit" buttom
9.- now create a file name ".htaccess"
10.- the htaccess file should have the following line of code
Allow from all
11.- Make sure the file you created does not have any extention if it does rename it.
12.- upload the .htaccess file to both of your folders where your images are.

and that will do it. If you have any question please drop me a line

Kind regards,
Ricky
__________________
==========================
Current version: xCart Gold 4.0.11 [unix]
iMac - running Leopard / PC - running XP Prof.
Reply With Quote
  #6  
Old 08-19-2004, 01:45 PM
  rjcbear's Avatar 
rjcbear rjcbear is offline
 

X-Adept
  
Join Date: Jun 2004
Location: Alabama,U.S.A
Posts: 503
 

Default

Quote:
Warning: Cannot modify header information - headers already sent by (output started at /home/maxtarco/public_html/store/admin/images_location.php:136) in /home/maxtarco/public_html/store/include/func.php on line 181
I had that occured to me once and the way i was instructed to fix it was to go to the "func.php" file and make sure there was no blank spaces after the las "}" in the line. I took them out and did not have the problem any more.


Quote:
Warning: fopen(_htm/home/maxtarco/public_html/store/files/master/t_3.jpg): failed to open stream: No such file or directory in /home/maxtarco/public_html/store/admin/images_location.php on line 136
with regards of the above are you trying to import your products or your detail images?

kind regards?
Ricky
__________________
X-CART Gold version 4.0.14 & 4.1.11
Apache Version 1.3.29 (Unix)
EWDHosting-Quality X-cart Hosting
We will always sell you the right shoe and the left one is free.
Reply With Quote
  #7  
Old 09-25-2004, 02:18 PM
 
Jason @ streetwerke Jason @ streetwerke is offline
 

Member
  
Join Date: Aug 2004
Posts: 21
 

Default

Good tip from rjcbear.

People need to understand that for some reason, X-Cart thought it would be really funny to have the default .htaccess file include the text:

Code:
Deny From All

So, you must change it or create a new file. I simply edited it, and copied it to my two image folders (Thumbnails & Detailed Images) that I have created under the .../xcart/files/ directory.

Also, you won't see the .htaccess files on most FTP programs. They are hidden files. I have to use my Control Panel File Manager application (off of my hosted server) to see them.
__________________
Jason
streetwerke.com
X-Cart 4.0.11 Gold(AOM/Pconf/GiftReg/Affiliate)
MySQL 4.0.24-standard
PHP 4.3.11
Reply With Quote
  #8  
Old 10-07-2004, 08:06 AM
 
cotc2001 cotc2001 is offline
 

X-Man
  
Join Date: Feb 2003
Location: Shrewsbury, UK
Posts: 2,351
 

Default

Arggghh this is driveing me crazy!!

I've followed the instructions to the letter.

chmod folders (thumb & full) in files
removed the deny from all .htaccess file
uploaded allow access from all to both the thumb and full folders

set file location to use filesystem

set location to usr/home/xxxxxx/public_html/files/images/full/ (xxx being the account name on my server)

click submit

and I get

Code:
LOG CREATED: 2004-10-07 17:06:08 Product detail images Location: FS usr/home/xxxxxx/public_html/files/images/full/d_5.jpg - Failed usr/home/xxxxxx/public_html/files/images/full/d_6.jpg - Failed usr/home/xxxxxx/public_html/files/images/full/d_7.swf - Failed usr/home/xxxxxx/public_html/files/images/full/d_10.jpg - Failed

then click on the continue link from the error log and although the same file location is still in the input box the datbase or file selection drop down has reverted back to database

The stupid thing is that i've got it working for the thumbnails (dont ask me how) but not for the detailed images

Following on from the above, i just changed the category icons to filesystem and that worked fine as well, the only problem im having this with is the detailed images

This is on version 4.0.3
__________________
x-cart 4.0.5 (live and heavily modded)
Server: freebsd
Reply With Quote
  #9  
Old 10-07-2004, 08:52 AM
  rjcbear's Avatar 
rjcbear rjcbear is offline
 

X-Adept
  
Join Date: Jun 2004
Location: Alabama,U.S.A
Posts: 503
 

Default

Quote:
The stupid thing is that i've got it working for the thumbnails (dont ask me how) but not for the detailed images

Following on from the above, i just changed the category icons to filesystem and that worked fine as well, the only problem im having this with is the detailed images

Did you check your permission codes? I think the BD is having trouble writing to the folder you specify.

Hope this will help.

Kind regards
Ricky
__________________
X-CART Gold version 4.0.14 & 4.1.11
Apache Version 1.3.29 (Unix)
EWDHosting-Quality X-cart Hosting
We will always sell you the right shoe and the left one is free.
Reply With Quote
  #10  
Old 10-07-2004, 09:03 AM
 
cotc2001 cotc2001 is offline
 

X-Man
  
Join Date: Feb 2003
Location: Shrewsbury, UK
Posts: 2,351
 

Default

yup checked, doubled checked, triple checked.

deleted the directory

recreated it, chmod 777 using wsftp

still no go
__________________
x-cart 4.0.5 (live and heavily modded)
Server: freebsd
Reply With Quote
Reply
   X-Cart forums > Forum FAQs and guides



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 03:04 PM.

   

 
X-Cart forums © 2001-2020