Store not recording all Orders

[kellianderson]

Hi there,

 

I received an email from Paypal yesterday, notifying me that payment had been received for an order placed in my store. It doesn't specify what items were ordered — just the buyers address, item cost, and shipping amount, Because the shipping amount was included I know that the order was placed through the OS Commerce shop.

 

However, there is no record of this transaction in my "orders" in the OS Commerce admin. What's up with this? And how can I prevent it from ever happening again?

 

This is the first time this has happened — all previous orders placed through Paypal have gone through just fine.

 

Thanks so much,

 

Kelli

[ms-signs]

Hi there,

 

I received an email from Paypal yesterday, notifying me that payment had been received for an order placed in my store. It doesn't specify what items were ordered — just the buyers address, item cost, and shipping amount, Because the shipping amount was included I know that the order was placed through the OS Commerce shop.

 

However, there is no record of this transaction in my "orders" in the OS Commerce admin. What's up with this? And how can I prevent it from ever happening again?

 

This is the first time this has happened — all previous orders placed through Paypal have gone through just fine.

 

Thanks so much,

 

Kelli

 

 

I had the same problem, I went into the contribution site and found one with directions on some changes that have to be done in your pay pal account. I dont remember th name of the contribution but search "pay pal"

[mcoops]

Hi Kelli,

 

Did you find a solution for this problem as I have the same issue. Paypal notifies me of a receipt with my shop name as the item but my shop has no order details.

 

Mark

[kellianderson]

I haven't found a solution yet. However, I will search for the "Pay pal " post and see if I find anythng (and report back.)

 

Kelli

 

Hi Kelli,

 

Did you find a solution for this problem as I have the same issue. Paypal notifies me of a receipt with my shop name as the item but my shop has no order details.

 

Mark

[♥toyicebear]

Install and use PayPal IPN

[kellianderson]

Great, Thanks so much for the advice, OK, I installed the Paypal IPN, according to the directions in the accompanying html file.

 

However, now the customer side of the online shop is not loading at all:

http://www.thebiblechurchofchrist.org/shoponline/catalog/

 

 

I get this error:

 

"Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory."

 

Any clues?

 

Thanks again,

Kelli

 

 

Install and use PayPal IPN

[kellianderson]

…And I've changed all mentions of register_globals to "on" in the php.ini files and the htaccess file and it still doesn't work (is giving me the message "Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory.".)

 

So I would definitely warn against installing the Paypal IPN thing, since it seemed to just have broken my store.

 

-Kelli

 

Great, Thanks so much for the advice, OK, I installed the Paypal IPN, according to the directions in the accompanying html file.

 

However, now the customer side of the online shop is not loading at all:

http://www.thebiblechurchofchrist.org/shoponline/catalog/

 

 

I get this error:

 

"Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory."

 

Any clues?

 

Thanks again,

Kelli

[spooks]

…And I've changed all mentions of register_globals to "on" in the php.ini files and the htaccess file and it still doesn't work (is giving me the message "Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory.".)

 

So I would definitely warn against installing the Paypal IPN thing, since it seemed to just have broken my store.

 

-Kelli

 

Pity that, you should have been warned in the install, after all enabling register_globals is a security risk, the reason its disabled in the first place.

 

:blink: :blink: :blink:

[kellianderson]

OK, I am really desperate at this point. I have removed all of the Paypal IPN module files from my store. I have switched the register_globals to "off" in all php files and in the.htaccess.

 

But my store is still broken:

http://thebiblechurchofchrist.org/shoponline/catalog/

 

Still says:

"Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory."

 

Oh, I really regret opening this can of worms.

 

How can I get myself out of this mess and have the store work again? Maybe I should "restore database" in the database backup manager?

 

I will try this, lose all of my order data, but it will be worth it is the store can get back online.

 

Very sadly,

Kelli

 

 

 

 

…And I've changed all mentions of register_globals to "on" in the php.ini files and the htaccess file and it still doesn't work (is giving me the message "Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory.".)

 

So I would definitely warn against installing the Paypal IPN thing, since it seemed to just have broken my store.

 

-Kelli

[kellianderson]

OK, I just restored my database using the Database Backup Manager. This made no difference at all. register_globals has officially ruined my holiday weekend. If anyone has any advice on how I can get rid of this error message and make the store work again, I would really appreciate it

 

OK, I am really desperate at this point. I have removed all of the Paypal IPN module files from my store. I have switched the register_globals to "off" in all php files and in the.htaccess.

 

But my store is still broken:

http://thebiblechurchofchrist.org/shoponline/catalog/

 

Still says:

"Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory."

 

Oh, I really regret opening this can of worms.

 

How can I get myself out of this mess and have the store work again? Maybe I should "restore database" in the database backup manager?

 

I will try this, lose all of my order data, but it will be worth it is the store can get back online.

 

Very sadly,

Kelli

[spooks]

Something must have been changed that you hav`nt reverted.

 

Have you checked all the .htacces for any changes there.

 

Some options, the better hosts make a daily backup of your site, you could ask for that to be restored.

 

You could trey enabling register_globals to problem is found, this should do that I think:

 

From your Site Manager, login to File Manager, then click the "Up one directory" button until the "Current Directory:" reads "/".

Then click on the "etc" directory. Then click on the pencil to the right of the "php.ini" file.

At this point you will want to look for the "register_globals" directive, and you will just change the value to either Off or On

 

Have you checked all the .htacces for any changes there.

[spooks]

You could check this post:

 

http://www.oscommerce.com/forums/lofiversion/i...hp?t159596.html

[kellianderson]

Thanks, Sam. Well before I started out on this Paypal IPN thing, I believe that all of my register_globals (in the php and in the .htaccess) were set to "off." I think. It was whatever the default is for oscommerce.

 

So I had changed them all to "on."

 

Now I've gone through and changed them all to "off" again.

 

I don't understand whether registers_global needs to be "off" or "on" — do you know? If I could figure this out for sure, I could hunt for all instances of this phrase.

 

I called godaddy an they can revert some of my files, but it will be 200$ and Im not even sure that will work.

 

Do some of the registers_global need to be on and some off??

 

Thanks agian,

Kelli

 

Something must have been changed that you hav`nt reverted.

 

Have you checked all the .htacces for any changes there.

 

Some options, the better hosts make a daily backup of your site, you could ask for that to be restored.

 

You could trey enabling register_globals to problem is found, this should do that I think:

 

From your Site Manager, login to File Manager, then click the "Up one directory" button until the "Current Directory:" reads "/".

Then click on the "etc" directory. Then click on the pencil to the right of the "php.ini" file.

At this point you will want to look for the "register_globals" directive, and you will just change the value to either Off or On

 

Have you checked all the .htacces for any changes there.

[kellianderson]

Hmm… I don't have an "etc" directory anywhere in my site. Could this be the problem?

 

-k

 

Something must have been changed that you hav`nt reverted.

 

Have you checked all the .htacces for any changes there.

 

Some options, the better hosts make a daily backup of your site, you could ask for that to be restored.

 

You could trey enabling register_globals to problem is found, this should do that I think:

 

From your Site Manager, login to File Manager, then click the "Up one directory" button until the "Current Directory:" reads "/".

Then click on the "etc" directory. Then click on the pencil to the right of the "php.ini" file.

At this point you will want to look for the "register_globals" directive, and you will just change the value to either Off or On

 

Have you checked all the .htacces for any changes there.

[spooks]

Hmm… I don't have an "etc" directory anywhere in my site. Could this be the problem?

 

-k

 

 

Could mean your host wont allow register globals off, sorry I don`t have enough experiance with this issue to say what exactly is required.

 

There is this contrib that might help:

 

http://www.oscommerce.com/community/contributions,2097

[kellianderson]

In my .htaccess files I changed this line from "Off" to:

#php_flag register_globals On

 

And in my php.ini files (I have two of them , one on the root and one in "catalog") I have changed off to:

 

register_globals on

 

 

No dice…same old error message. So I am now going to try turning them all to "off" again and see if it reconsiders its stance. Maybe this is a problem completely distinct from the php.ini and the .htaccess files?

 

-k

 

 

 

 

Hmm… I don't have an "etc" directory anywhere in my site. Could this be the problem?

 

-k

[kellianderson]

Phew! The store now appears to be working again.

 

My scripting in the php was incorrect. In the php file, rather than

 

register_globals on

 

I needed:

register_globals = On

 

This is what happens when a non-programmer tries to code things.

 

-----

 

Then I ran into an additional problem with the permissions for the configure.php file. THe oscommerce forum recommends that the cmode be set to 644. However, I continued to get the error message until I changed the cmode to 444.

 

------

 

So there ya go: beware of Paypal IPN! :) I'm going to embrace this minor glitch in the system. In return, I get to keep my store.

 

Thanks for your help Sam!

 

-k

 

 

In my .htaccess files I changed this line from "Off" to:

#php_flag register_globals On

 

And in my php.ini files (I have two of them , one on the root and one in "catalog") I have changed off to:

 

register_globals on

 

 

No dice…same old error message. So I am now going to try turning them all to "off" again and see if it reconsiders its stance. Maybe this is a problem completely distinct from the php.ini and the .htaccess files?

 

-k

[spooks]

Glad you`ve got things back, I was surprised at your host wanting $200 for a partial restore, mine provided a full restore a while back for no charge!

 

Perhaps you should consider moving?

 

I get hosting through a UK reseller, but it originates from http://liquidweb.com/

 

:)

[kellianderson]

Well, my client set up the hosting with godaddy, unfortunately. They seem to nickle and dime just a bit.

 

For anyone else who has read through this post, I ultimately found that you can edit your prefs in Paypal to automatically send the customer back to your store (thus triggering the checkout_success.php file)

 

Go to paypal and login, then > My Account > Profile > Website Payment Preferences

 

Here put Auto return to "ON"

and put in the full URL for your checkout_success.php file

 

Will be something like this:

 

http://www.yoursite.com/catalog/checkout_success.php

 

Cheers,

k

 

Glad you`ve got things back, I was surprised at your host wanting $200 for a partial restore, mine provided a full restore a while back for no charge!

 

Perhaps you should consider moving?

 

I get hosting through a UK reseller, but it originates from http://liquidweb.com/

 

:)

[ATise]

If you are still trying to locate your orders you might want to try this mod it's a quick fix until you can get the IPN to work right. Most of the wrk for the IPN must be done on paypals side.

 

http://addons.oscommerce.com/info/3694

[omarts]

I think there are so many posts with this one issue - someone should roll this into stnadard osCommerce next release.

 

So, one solution to customers purchasing but not coming back to store web site and the order not registering into the database is that you pass on the items information to paypal. Hence, when you get paypal email, it has details on what your customer bought and what was tax/shipping etc. So, even if they do not ocme back to the store, both they and the store owner email from paypal has all the information.

 

See following thread - it has all the information:

http://www.oscommerce.com/forums/index.php?sho...stered&st=0

 

I will also post an upate on passing on itemized details to paypal to that thread soon.