Page 2 of 3

Re: [RELEASED] - 0.7.9 File Upload

Posted: Thu Oct 16, 2008 9:15 pm
by robgtheengineer
I moved the htaccess and got the following result clicking your link:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@123picturethis.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

Re: [RELEASED] - 0.7.9 File Upload

Posted: Thu Oct 16, 2008 9:17 pm
by robgtheengineer
Error log is not changed, but i did see this in it:

DBD::mysql::st execute failed: No database selected at /home/capemb/public_html/cgi-bin/opencart_file_upload.cgi line 53., referer: http://123picturethis.com/index.php?con ... ile_upload?

Re: [RELEASED] - 0.7.9 File Upload

Posted: Thu Oct 16, 2008 10:41 pm
by randomfactor
robgtheengineer wrote: Error log is not changed, but i did see this in it:

DBD::mysql::st execute failed: No database selected at /home/capemb/public_html/cgi-bin/opencart_file_upload.cgi line 53., referer: http://123picturethis.com/index.php?con ... ile_upload?
OK, that's progress.

Check the values of the settings starting at line 29 in /home/capemb/public_html/cgi-bin/opencart_file_upload.cgi:

Code: Select all

my $dbdsn = "DBI:mysql:database=Your_Database:host=localhost";
my $dblogin = "Your_Db_User";
my $dbpassword = "Your_Db_Password";
You have to modify "Your_Database", "localhost", "Your_Db_User", and "Your_Db_Password".

Are the values correct?

Re: [RELEASED] - 0.7.9 File Upload

Posted: Fri Oct 17, 2008 3:08 am
by robgtheengineer
DBI was not enabled on my server. I enabeled it and am still getting the error.

Re: [RELEASED] - 0.7.9 File Upload

Posted: Fri Oct 17, 2008 3:36 am
by robgtheengineer
Check out my site again, I made progess, still not working though.

Re: [RELEASED] - 0.7.9 File Upload

Posted: Fri Oct 17, 2008 4:32 am
by randomfactor
robgtheengineer wrote: Check out my site again, I made progess, still not working though.
It would make it easier if you would include a short explanation of what is not working.  I went thru the order process on your site and got all the way through checkout until the "Place Order" confirmation.  When I tried to place the order, I received this error:

Code: Select all

Warning: rename(/home/capemb/public_html/cust_upload/ade73d349531b13418a0e3a78dc92406/Water_lilies_300d
pi.jpg,/home/capemb/public_html/cust_upload/order-48F79-F0D5F-FFA89/Water_lilies_300dpi.jpg) [function.rename
]: Permission denied in /home/capemb/public_html/catalog/extension/product_option/upload.php on line 133

Warning: Cannot modify header information - headers already sent by (output started at /home/capemb/public_htm
l/catalog/extension/product_option/upload.php:133) in /home/capemb/public_html/library/environment/response.php
 on line 23
Does this directory exist on your server now: /home/capemb/public_html/cust_upload/order-48F79-F0D5F-FFA89

It's odd that it can create the session directory under cust_upload, but not the order directory.

Re: [RELEASED] - 0.7.9 File Upload

Posted: Fri Oct 17, 2008 5:05 am
by Qphoria
Googled that rename permission thing and found this..

http://www.codingforums.com/showthread.php?t=149133

not sure if it helps

[FIXED] - IE upload stall

Posted: Fri Oct 17, 2008 1:55 pm
by randomfactor
robgtheengineer wrote: Check out my site again, I made progess, still not working though.
I've been working on this for a while and I think I've discovered the problem.  The version of jQuery packaged with v0.7.9 is not the latest.  A newer version seems to correct the problem.  The most amazing part of this whole thing is that firefox ran just fine with the older version of jQuery.

Anyway, the solution is to replace .../catalog/javascript/ajax/jquery.js with the file in the zip attached to this message.

Re: [RELEASED] - 0.7.9 File Upload

Posted: Fri Oct 17, 2008 2:02 pm
by bruce
jquery lives at admin\javascript\ajax\jquery.js as well in OpenCart

File rename problem

Posted: Fri Oct 17, 2008 2:45 pm
by randomfactor
randomfactor wrote:

Code: Select all

Warning: rename(/home/capemb/public_html/cust_upload/ade73d349531b13418a0e3a78dc92406/Water_lilies_300d
pi.jpg,/home/capemb/public_html/cust_upload/order-48F79-F0D5F-FFA89/Water_lilies_300dpi.jpg) [function.rename
]: Permission denied in /home/capemb/public_html/catalog/extension/product_option/upload.php on line 133

Warning: Cannot modify header information - headers already sent by (output started at /home/capemb/public_htm
l/catalog/extension/product_option/upload.php:133) in /home/capemb/public_html/library/environment/response.php
 on line 23
I think that the reason your site gets this error and mine does not has to do with sticky bits on directories.  Of course, I can't see what the values of the access permissions are on your site, but it would explain the error if the owner of the server process isn't also the owner of the file being moved (renamed).

So, I think the solution would be to set umask down when creating directories under the cust_upload directory.  I'll give that a try.

Re: [RELEASED] - 0.7.9 File Upload

Posted: Fri Oct 17, 2008 7:20 pm
by Qphoria
OH
MY
GAWD  ;D

updated jquery is planned as part of the next build when 0.7.9 gets finalized. :)

Re: [RELEASED] - 0.7.9 File Upload

Posted: Fri Oct 17, 2008 7:53 pm
by robgtheengineer
My site is working great now, thank you for all the support!  I will post a list of the problems I had and the solutions later, thanks again!

Re: [RELEASED] - 0.7.9 File Upload

Posted: Fri Oct 17, 2008 10:30 pm
by randomfactor
Qphoria wrote: OH
MY
GAWD  ;D
There is a pretty good chance that I over-expressed myself there.  Sorry.

Re: [RELEASED] - 0.7.9 File Upload

Posted: Sat Oct 18, 2008 6:38 pm
by bruce
nah, I think you have expressed the "aha" moment of revelation perfectly  ;)

[PATCHED] - 0.7.9 File Upload

Posted: Mon Oct 20, 2008 12:49 am
by randomfactor
A patch release is available for the File Upload contribution.

It is too large (288K) to attach to this message, so I have made it available at http://home.comcast.net/~randomfactor/f ... 081019.zip.

This patch corrects the following problems:
  • Error when adding item with no options to cart
  • Error when copying image file from session directory to order directory and directory sticky bit is set
  • Stall when Url alias setting is used
  • Stall when uploading with Internet Explorer (jquery.js version)
  • Updated installation instructions
If you install this patch over a prior release, follow the instructions to customize the opencart_file_upload.cgi script and copy it to the cgi-bin directory with correct access permissions.

Re: [RELEASED] - 0.7.9 File Upload

Posted: Tue Nov 11, 2008 1:06 pm
by lildaveycross
Okay, so after messing with this for too long, I've decided to ask for help.

I seem to be having problems with the cust_upload folder. No matter where I put it (open cart main directory, root folder, etc), with or without the .htaccess file, and even if I CHMOD it to 777, I get an internal server 500 error when uploading a photo.

I know that it's the cust_upload folder that's causing the problem, because if I change my directory settings in opencart_file_upload.cgi to

my $opencart_upload_dir = "cust_upload";

...then the upload works by creating a cust_upload folder directly in the cgi-bin folder, and putting the file there. The problem with this is that I don't really want the cust_upload folder to be in my cgi-bin, AND when I do it this way the "Image Preview" doesn't work.

here's my test site
http://elementalshop.com/printing/index ... oduct_id=4

Any ideas?

Thanks

Re: [RELEASED] - 0.7.9 File Upload

Posted: Tue Nov 11, 2008 10:58 pm
by randomfactor
There is a bit of complexity to do with the location of the cust_upload directory because two systems (PHP and Perl cgi-bin) must agree on its location.

On the PHP side, the location is determined by making cust_upload a sibling directory to your DIR_DOWNLOAD directory as determined by your top-level config.php file.  The path is computed by replacing the string "download" with "cust_upload".  You wouldn't have the string "download" more than once in your path string, would you?

On the Perl side, the location is set in the opencard_file_upload.cgi script that you edit.  Please provide an absolute file path in the $opencart_upload_dir setting at line 27:

Code: Select all

# set these values for your site
my $opencart_upload_dir = "/srv/www/htdocs/Your_Store/cust_upload";
my $max_upload = 12582912; # set this to max file size in bytes
my $dbdsn = "DBI:mysql:database=Your_Database:host=localhost";
my $dblogin = "Your_Db_User";
my $dbpassword = "Your_Db_Password";
What environment are you running on?  I haven't attempted to run the file upload extension on windows yet.  That's an experiment for another day.

Re: [RELEASED] - 0.7.9 File Upload

Posted: Wed Nov 12, 2008 4:32 am
by lildaveycross
Thanks for the quick reply, let's see...
randomfactor wrote: You wouldn't have the string "download" more than once in your path string, would you?
Nope.
randomfactor wrote: Please provide an absolute file path in the $opencart_upload_dir setting at line 27:
Absolute paths do not work. Neither do relative paths for that matter. I get the Internal Server 500 error regardless if it's something like "http://elementalshop.com/printing/cust_upload/" or something like this "/public_html/elementalshop/printing/cust_upload"...The only way I can get it to upload is if I just put "cust_upload" which puts a folder inside the cgi-bin.

randomfactor wrote: What environment are you running on?  I haven't attempted to run the file upload extension on windows yet.  That's an experiment for another day.
Operating system Linux
Apache version 2.2.9 (Unix)
PHP version         5.2.6
MySQL version 5.0.45
Perl                    5.8.8


...let me know if you come up with anything. I'll keep messing with it.

Thanks!

Re: [RELEASED] - 0.7.9 File Upload

Posted: Wed Nov 12, 2008 8:54 am
by randomfactor
lildaveycross wrote:
Absolute paths do not work. Neither do relative paths for that matter. I get the Internal Server 500 error regardless if it's something like "http://elementalshop.com/printing/cust_upload/" or something like this "/public_html/elementalshop/printing/cust_upload"...The only way I can get it to upload is if I just put "cust_upload" which puts a folder inside the cgi-bin.
It seems that you and I share a difference of definition for "absolute path".  I am not referring to an HTTP Url.  Rather, I am referring to the linux file path to your opencart directory on the host server.  Each environment may be different, but one way that might help to identify the absolute path is to sift through the values returned from http://elementalshop.com/printing/admin ... erver_info (Same as the Admin > Configuration > Server Info menu item of your opencart administrator view.)

In my environment, the value for absolute path is given in the _ENV["DOCUMENT_ROOT"] variable (well towards the bottom of the page).  On my testing server, the value is /srv/www/htdocs/store, so the absolute path I put in opencart_file_upload.cgi is /srv/www/htdocs/store/cust_upload.

Does this make sense?

Re: [RELEASED] - 0.7.9 File Upload

Posted: Wed Nov 12, 2008 10:04 am
by lildaveycross
THAT WORKED PERFECTLY!

You were right. I was thinking Absolute URL, not Absolute Path

Thank you so much.