500 - Internal Server Error when adding products via EasyPopulate

Zen Cart Version 1.3.8a

No addons installed

Windows Server 2008 with IIS7

Personally hosted

I just installed Zen Cart this weekend and have been slowly creating a CUSTOM template and learning from the forums and FAQs how to change the look of the cart with great success. I have run into a few problems but have been able to work through them by researching them.

However, I have run into a snag and cannot find anything that has helped me yet. When I add a new Category I receive an HTTP error 500, but the category is created. So I didn't think anything of this, but now when I try to add a new product, when I click the preview button I receive a 500 - Internal server error "There is a problem with the resource you are looking for, and it cannot be displayed.

The URL in the address box is "http://www.leathernights.com/catalog/admin/product.php?cPath=1_6_21&product_type=1&action=new_product_preview

Also, I receive the same error when I try to add a Manufacturer

I thought it was a permission problem, but it appears they are set OK.

Any thoughts or suggestions will be greatly apprecated.

The site can be seen at http://www.leathernights.com/catalog

It is still in process so please excuse the un-finished look.

Thanks
Doug

As you'll see in the "similar threads" links below, this is a common problem when the webserver has certain rules in place intended to stop spammers and hackers from causing problems on your site, and then you come along and need to do something legitimately similar to what they might try, such as including a URL in one of the form fields on the page you're submitting.

So, in the case of your products and manufacturers, are you filling in the "URL" field? If so, try leaving that blank and see if that helps. If so, talk to your hosting company to find a way around the security rules that are blocking you from submitting that information.

Either way, the "500" error is one that never displays its real cause on-screen ... the real details are only known by the webserver, recorded in its logs. So, you'll usually have to ask your hosting company for the details that are in the logs ... and then with those details, work with the hosting company to find a suitable workaround.

DrByte,

Thanks for the quick reply it is appreciated. I have done some more researching and I have found a more specific error.

Just a little more info on my setup. I am hosting the webserver in my data center, (I am a data center manager) so I have console access to this server, I am certain that there are no accessive blocking going on the server. I have scored the log files and they only give me the 500 error, nothing more specific.

However I managed to get a browser running on the actual webserver without friendly HTTP error message and I received this

"PHP Warning: Unknown: open_basedir restriction in effect. File (c:\windows\TEMP) is not within the allowed path(s): (c:\inetpub\wwwroot) in Unknown on line 0 PHP Warning: File upload error - unable to create temporary file in Unknown on line 0"

I have checked my php.ini file and the open_basedir is set to c:\inetpub\wwwroot, so where is the scripts getting the c:\windows\TEMP path from?

my php.ini file in located in c:\PHP

Thanks again
Doug

dscheck:

I have checked my php.ini file and the open_basedir is set to c:\inetpub\wwwroot, so where is the scripts getting the c:\windows\TEMP path from?
Good question.
Probably the PHP configuration settings (php.ini) for the default location for uploaded files (probably triggered by you trying to upload images for products/categories/manufacturers).

SO I change the default upload directory in the php.ini file and that got rid of the first error, but I'm still receiving the

"PHP Warning: File upload error - unable to create temporary file in unknown on line 0"

I will continue to work on the php.ini file. If anyone has any ideas on this error let me know

Thanks
Doug

Solved this problem. Had to empty the open base_dir setting in php.ini

I am having a similar problem when I try to add products using the Easy Populate upload. I initially tried to upload approx 10,000 items. I received the "500 - Internal Server Error", however it did upload approx 6,000 of the items. I cannot seem to get it to work for the rest. I have even tried a few test uploads of just 1 item and it still does not work. I am hosted through GoDaddy and I cannot figure out how to correct this problem. I am fairly new to Zen Cart, so any feedback would be greatly appreciated.

One more thing, I do not have any URLs anywhere in my upload file, only HTML code in the product descriptions.

I am suddenly getting 500 errors after 10 successful inserts of 300 products per txt file. No matter what I do I get 500 error message now and I changed nothing! Strange. I've tried starting from scratch, it wont do files it had before. Totally stuck. Anyone have an idea? :frusty:

dscheck can you tell us more about what you added to your php.ini ? exactly what text?

As I said earlier in this thread, the "cause" of the "500" error will be shown in your server's errorlog.

I was having the same problem with my hosting company. Running SQL 5 They told me that the timeout limit was set to 60 seconds and that was causing the 500 error as well as my SQL limits were maxing out as I did the uploads. My work around was to reinstall zencart and easy populate. After that just upload 1000 records per hour tx sizes of 300 but i start doing 2 500 txt files each hour today. So far it is working for me. Not sure if you getting same error for same reason but i did find this to work for me.

Good Luck

Fredrick

pce.photography:

my SQL limits were maxing out as I did the uploads
If your host is so underpowered that they can't give you larger or unlimited query limits, you might be able to work around that limitation use this approach: http://www.zen-cart.com/forum/showthread.php?t=24089

discprodonline:

I am having a similar problem when I try to add products using the Easy Populate upload. I initially tried to upload approx 10,000 items. I received the "500 - Internal Server Error", however it did upload approx 6,000 of the items. I cannot seem to get it to work for the rest. I have even tried a few test uploads of just 1 item and it still does not work. I am hosted through GoDaddy and I cannot figure out how to correct this problem. I am fairly new to Zen Cart, so any feedback would be greatly appreciated.

i'm having the same issue with easy populate. it manage to upload the first two files of 4000 items completely, and subsequent files couldn't be loaded in entirety, often only 2000+ out of 4000 items got uploaded.

any advice?

Did anyone ever find a solution to the 500 errors....I am haveing them as well when I try to access product details, attributes, categories in store or admin.

This thread is part of the "Installing On A Windows Server" forum, and Windows servers don't recognise .htaccess file instructions because they only apply to Apache servers.

Vger

Raynegsc:

Did anyone ever find a solution to the 500 errors....I am haveing them as well when I try to access product details, attributes, categories in store or admin.