error mysql database

[ellenropa]

Hi me again.
I have buy a dutch webshop, all works fine, but when I want to submit a image. I get a error. I have contact the dutch webshop, they told me that my hostin Powweb dont give permission to submit images into the database.
They told me that its better that I'm looking for another hosting.
But my question is how can I fixed this problem
Ellen

[IanS]

In order for others to be able to help, can you give any error messages or other indication of the problem other than 'don't give permission'?

Uploading large images can be a problem as scripts time-out after 60 seconds - is this the issue. Currently Powweb are having problems with MySql databases. Is this the problem? You need to say more for others to help diagnose the issue.

[YvetteKuhns]

but when I want to submit a image. I get a error....permission to submit images into the database.

Check the permissions of the folder to which the images are being stored on your web host server. It should be inside the htdocs folder and probably named images. The permissions should be 755 or possibly 777, depending on the shopping cart script you are using.

You may also need to edit your php.ini file in the control panel, but I would check the web server first.

[HalfaBee]

It is most likely the tmp dir is not set to a valid dir.

the setting in php.ini needs to be
upload_tmp_dir = /home/users/web/bxxxx/pow.yourusername/tmp

The correct path can be found here http://members.powweb.com/member/settings.bml
under document root.
Make a dir at the same level as htdocs and call it tmp.

[YvetteKuhns]

It is most likely the tmp dir is not set to a valid dir.

Reread this:

all works fine, but when I want to submit a image. I get a error.

If everything else works, I don't think it is the tmp directory that is the problem.

[HalfaBee]

Maybe nothing else uploads images.

[ellenropa]

Okay, I tried to explain, when I want a small photo upload,
he say invalid photograph, only jpg. But this is jpg.
I have mail the manager from the Dutch shop, he told me Powweb give no permission for uploading images to database.
I have rename the folder 777, All works fine, only the images.

[Croc Hunter]

Unless you're using a remote connection (highly unlikely) you can upload images to a database at Powweb no problem. I do. Any script that requires 777 is a poorly written script. 755 should work, if not I wouldn't use it.

Giving us a link to your upload page might help.

[ellenropa]

the folder are on 777,
and still the same problem
http://www.proef.ellenspsp.com/winkelmanager/admin/admin.php?action=add_product&PHPSESSID=481145221132ed4de7d43851ba956985

Ellen

[Croc Hunter]

I see, have you done all of what was suggested above?
Are you using; (account-username).powwebmysql.com in your config file?

[ellenropa]

yes all have done
the dutch men told that powweb its not allowed images
i dont know what to do now
http://www.proef.ellenspsp.com/winkelmanager/status.php
everthing is okay

[ellenropa]

I dont know how to edit the ini.php
I logged in and click on the edit button and save
but still the same problem

[HalfaBee]

Well if you did that, you know how to edit php.ini. :)

Did you change the path to your own path info and create the tmp dir?

You might need to do the same for the session dir as well.

[ellenropa]

okay now I know the ini.php
I use already this pad /home/users/web/b2078/pow.<removed>/htdocs
how create a tmp dir?

[Croc Hunter]

/home/users/web/b2078/pow.username/htdocs

Is not correct. Go back and change /htdocs to /tmp (keep your real username).

/home/users/web/b2078/pow.username/tmp

Then goto Services> SiteTools> FileManager> scroll to bottom "Enter folder name to create:" type in tmp and click "New Folder"

[ellenropa]

I can change the path into tmp
But i create a folder tmp
must i put all the stuf for the webshop into that folder tmp

[Croc Hunter]

No!! Don't move your files.

So your path and tmp folders are as we instructed?

It still doesn't work..

[HalfaBee]

No, working files need to be in htdocs or dirs in htdocs.

[ellenropa]

yes I have write a issue to the support center
I dont have answer yet
Ellen

[YvetteKuhns]

I remember having to edit the php.ini file to upload images on another website hosted here. There was indeed a permissions problem with the image files themselves.

By editing the php.ini file, we could change the permssions as they were uploaded instead of logging into the FTP server to manually change the permissions (which is what we did to identify the problem).

[Petra]

Powweb does allow images in the databases.
I had a shope for a while and never had a problem uploading images.

I can not help you with your problem I am affraid but I know you get help here.
Petra

[dmacminn]

yes, but watch the permissions... lots of scripts don't set them correct once they are done doing the upload and they get set to 600 or some other weird setting ... sometimes you need to add an additional line to set (chmod) the file permissions to the correct value...

[YvetteKuhns]

Did you see the images on the web server? Can you view the image when typing www.yourdomain.com/imagepath/imagename.jpg ? Can you change the permissions to view the image already on the server?

I still think the problem is the permissions, because I personally had this problem two years ago. The images were uploaded, but they were not the correct permissions, so we could not view them. We edited the php.ini file AND possibly changed the php script to upload and change permissions (chmod) to see the image.

[entrecon]

Images in the database?

Are you talking about uploading the images and storing the binary data in a database? If this is the case than you won't be able to see the image using a path like Yvette has laid out. The problem might be how the binary data is stored in the database field and/or the code used to retrieve it.

[YvetteKuhns]

You are storing the image path in the database and the image file itself on the server, right?