Multiple instances of PAYPAL constants in DB

[raamee]

Hi,

 

This is a resolution for an archived post, I've opened in the past.

 

Hope this helps someone.

 

 

 

old post:

----------------------
I somehow crashed by entire admin and store with a simple action I performed in the Admin.

I performed the following
1) entered Admin -> Configuration -> Products Listing section.
2) Changed the order value of the "Buy Now Button" to 0, thinking it will hide it in the displayed table.
3) Clicked Save.

Once I clicked save my admin crashed. I cannot access it anymore and I get the errors I've attached below. The errors continue to list many constants of MODULE_PAYMENT_PAYPAL. and the then some seemingly more important errors regarding the session cookie and headers.

My Admin is busted.
The webpage itself still shows the products, but the same errors appear at the top of the page. You can see it here: http://www.glassinac....php?page=vases

Any idea what's wrong and how to fix it?

Thanks for you help.

RaamEE.


Some the errors being displayed

Notice: Constant MODULE_PAYMENT_PAYPAL_IPN_STATUS already defined in /homepages/12/d286052379/htdocs/glasses/store/includes/application_top.php on line 91

Notice: Constant MODULE_PAYMENT_PAYPAL_IPN_ID already defined in /homepages/12/d286052379/htdocs/glasses/store/includes/application_top.php on line 91

Notice: Constant MODULE_PAYMENT_PAYPAL_IPN_API_USERNAME already defined in /homepages/12/d286052379/htdocs/glasses/store/includes/application_top.php on line 91
.
.
.
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /homepages/12/d280005379/htdocs/glassinaction/store/admin/includes/application_top.php:81) in/homepages/12/d286052379/htdocs/glasses/store/includes/classes/session.php on line 143

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /homepages/12/d280005379/htdocs/glassinaction/store/admin/includes/application_top.php:81) in/homepages/12/d286052379/htdocs/glasses/store/includes/classes/session.php on line 143

Warning: Cannot modify header information - headers already sent by (output started at /homepages/12/d280005379/htdocs/glassinaction/store/admin/includes/application_top.php:81) in/homepages/12/d286052379/htdocs/glasses/store/admin/includes/functions/general.php on line 46 

[raamee]

The resolution is:

 

I found out that in some way the DB was corrupted and contained multiple instances of the same constants MODULE_PAYMENT_PAYPAL_IPN*. Instead of 28 constants the DB contained more than 89 records of such names.

 

To resolve this, I deleted all the duplicate records and left only the 1st set of constants in the DB. I then opened the Admin UI and tried to enable the PAYPAL payment service. This failed and added new MODULE_PAYMENT_PAYPAL_IPN* constants on the ones already in the DB. The UI froze without a change to the PAYPAL payment module in the UI.

 

So I deleted the 1st set that I previously left in the DB and left the latest new set of records. I then retried enabling the PAYPAL payment module in the Admin UI and this time, the UI responded correctly. This allowed me to disable the PAYPAL payment module and continue browsing without any further errors.

 

I now can proceed and enable the PAYPAL for further work if I need it.

[MrPhil]

Just a note that the session_start() and "Cannot modify header information" errors are a consequence of the earlier error messages that were sent to the browser, and not primary problems in and of themselves. Once an error message (like Constant ... already defined) is sent, the browser cannot accept any more HTTP headers, because all the current ones have already been flushed to the browser by output (tags and text) already having been started. That's the default behavior, anyway. This can save you a lot of troubleshooting time, by knowing to ignore such error messages. You don't even need to clog up your post with those messages, as they're irrelevant.