XAMPP and images

By andre75 on 5 Oct 2005 at 03:45 UTC

I have developed a new site on XAMPP 1.4.15 on Linux and uploaded it.
I have then added some content to the online site.
Since I was going to do some work, I downloaded the database and overwrote my local one.
Now when I open up my site, all the image thumbnails that were posted within the texts are gone.

Does anyone know a solution to this?

Thanks
Andre

Comments

I'm not familiar with XAMPP

styro commented 5 October 2005 at 04:05

but could you give some more details about how your site was set up and what you did?

eg What modules were you using for file uploads and images? What was overwriting what? etc

--
Anton

Yep

andre75 commented 5 October 2005 at 06:12

Um,

well my local site is in a subfolder in the htdocs directory of xampp.
I used image and img_assist modules to create the images.
Strangely, I can upload a database from my local site to the remote site and everything works fine, when I go the other way it fails.
I dumped all database entries of my local database and imported the remote one, then the problem showed up. When I dump it again and load the previously (now outdated) local backup it works.
When i open the database with a texteditor this is what I see:

src="files/images/image.jpg"  --local database
src="../../files/images/image.jpg"  --remote database

So I am wondering why the path got updated one way but not the other way.

I am using XAMPP for Linux. It is a collection of tools (Apache, Perl, PHP ...) and scripts (phpMyadmin, ...)
I am using phpMyadmin to upload the database to the remote server and I am usint it for the local server too.

Andre

-------------------------------------------------
http://www.aguntherphotography.com

Are those paths...

styro commented 5 October 2005 at 06:42

you list part of the HTML source in the node content? They kind of look like it. If you manually enter an img tag into your site, can you load images from one of those paths?

Are both your local and remote servers using XAMPP? Are they both using the same subdirectory of htdocs? I assume they are both using the same public/private downloads setting.

Does just using the image module without img_assist make any difference? You might have to upload some new images to test that.

I suspect it might be something to do with the way you are dumping and restoring the databases with phpmyadmin, but I don't really know enough about that to help you more sorry.

--
Anton

Check the settings for the file locations

bonobo commented 5 October 2005 at 06:42

for the site at ?q=admin/settings

and for the image module at ?q=admin/settings/image

Make sure they are the same for both sites.

Also, check permissions on the directories -- it could be that with one Apache config, you have permissions to access the pictures, and on the other you don't.

Also, check the drupal and apache logs for any errors that might correspond to this problem, and post that info here.

I hope this helps.

Cheers,

bonobo

-------
http://www.funnymonkey.com
Tools for Teachers

-------
http://www.funnymonkey.com

Here is some more info.

andre75 commented 6 October 2005 at 03:13

I suspect it might be something to do with the way you are dumping and restoring the databases with phpmyadmin, but I don't really know enough about that to help you more sorry.

Thats what I think too. The remote server is not running xampp, thats only for local design. As I understand it, the path to the pictures in the sql file is wrong.

Make sure they are the same for both sites.

They are, as the remote site initially was a uploaded copy of the local site (I uploaded via ftp)
Unless the ftp chages permissions per default, that should not be a problem. What should the permissions of the files directory be so that I can check? What are the other permissions (I would like to know for security reasons)

Here is a short excerpt from my error_log:

http://localhost/drupal/north_america/u_s_a/california/bodie_california
[Tue Oct 04 20:38:29 2005] [error] [client 127.0.0.1] File does not exist: /opt/lampp/htdocs/files, referer: http://localhost/drupal/north_america/u_s_a/california/bodie_california
[Tue Oct 04 20:38:29 2005] [error] [client 127.0.0.1] File does not exist: /opt/lampp/htdocs/files, referer: http://localhost/drupal/north_america/u_s_a/california/bodie_california
[Tue Oct 04 20:38:35 2005] [error] [client 127.0.0.1] File does not exist: /opt/lampp/htdocs/files, referer: http://localhost/drupal/
[Tue Oct 04 20:38:35 2005] [error] [client 127.0.0.1] File does not exist: /opt/lampp/htdocs/files, referer: http://localhost/drupal/

Thanks for your help guys. I really appreciate the advice.

Andre
-------------------------------------------------
http://www.aguntherphotography.com

I could

andre75 commented 8 October 2005 at 22:38

I could really use some help. Doesn't anyone have another suggestion? The problem seems to be with XAMPP and Drupal.

-------------------------------------------------
http://www.aguntherphotography.com

Two things

bonobo commented 8 October 2005 at 22:50

1. Make sure you are running php4 and not php5. PHP5 has some glitches. This probably has nothing to do with your issue, but it is a good thing to check nonetheless.

2. RE:

src="files/images/image.jpg" --local database
src="../../files/images/image.jpg" --remote database

You could try editing the .sql file from the db dump (getting rid of ../../). This might correct the path to the file.

Hope this helps.

Cheers,

bonobo

-------
http://www.funnymonkey.com
Tools for Teachers

-------
http://www.funnymonkey.com

XAMPP and Images

bobby-1 commented 8 October 2005 at 23:16

This is a known issue with XAMPP, see http://www.apachefriends.org/f/ . A lot of different solutions. Seems to be a popular topic. It doesn't effect me, so no reccomendations.

This is a known issue with

andre75 commented 10 October 2005 at 20:56

This is a known issue with XAMPP, see http://www.apachefriends.org/f/ . A lot of different solutions. Seems to be a popular topic. It doesn't effect me, so no reccomendations.

Seems I am blind. I couldn't find any. I posted my own
http://www.apachefriends.org/f/viewtopic.php?t=13833
but I would still appreciate if you could point me to a solution.
This problem is getting worse, as my site and my local copy start drifting appart more and more.
I tried replacing the path ../../files with files in the sql file, but that did not work. I had even more problems afterwards.

It seems I am the only one having this problem. Is noone else testing their site locally with xampp?

Andre

-------------------------------------------------
http://www.aguntherphotography.com

I am testing my site locally with xampp

bonobo commented 10 October 2005 at 21:12

and am not having any of these issues -- sorry.

bonobo

-------
http://www.funnymonkey.com
Tools for Teachers

-------
http://www.funnymonkey.com

Xampp Forum and Images

bobby-1 commented 11 October 2005 at 00:20

Here are a few of the threads.

This is just from the first 3 pages under search for images. There are many adittional postings, but they are not in English.

Please post your fix. I will be addressing the same issue myself soon. Just have to many other things to figure out at the moment.

Image path wrong

andre75 commented 12 October 2005 at 05:56

Hi Bobby,

the posts you found are all related to images not being displayed due to some apache misconfiguration. I changed my httpd.conf file as they suggested. Didn't make a difference.
I am not sure if we have a little misunderstanding. I am able to display images. I can not synchronize my local database to the one on the server, since the PATH to the images will be wrong in the database that I download. Strangely it works the other direction.

So I guess the question is, why the database on the remote site has a different path (they are both relative but different).

I finally got it running. I deleted every occurance of ../../ in my database and most important i flushed the cache tables. Wonder why I couldn't read that somewhere?

Andre

-------------------------------------------------
http://www.aguntherphotography.com

XAMPP and images

Comments

I'm not familiar with XAMPP

Yep

Are those paths...

Check the settings for the file locations

Here is some more info.

I could

Two things

XAMPP and Images

This is a known issue with

I am testing my site locally with xampp

Xampp Forum and Images

Image path wrong

I finally got it running. I deleted every occurance of ../../ in my database and most important i flushed the cache tables. Wonder why I couldn't read that somewhere?

New forum topics

News items

Our community

Documentation

Drupal code base

Governance of community