[solved] deleted status in ps_order_state & cannot recreate them -> orders are splitted

[BoKr]

dear community,

 

I ask here instead of the subforum of my native language in hope to get faster help and results.

 

The Problem is:

 

In BO under ordermangement new orders are suddenly splittet!

Best is you have a look at the attached screenshot. You see 4 orders that are actually only two of course!

 

 

What is going on here? How can it be rapidly solved?

(I grant db access to Moderators)

 

I can say that I am sure it is related to a payment modulede. Namely, MasterPayment.zip hosted via Silbersaiten.de

However, their support is not avaible.

 

But the relation is only an assumption but I can tell you that I deleted status messasges under BO status that belonged to this module.

Why?

Because we had installed v1.7, v1.8 and now 1.9.

v1.8 started to introduce new statuses and did not bother to delete the now obsolte of v1.7.

Since I am a friend of non messy things I deleted those via BO/status. Each status has a trashcan icon and is therefore allowed to be deleted.

In this case it gave an error and told me: "no can  not be deleted. it is standard status" or so.

I was now a bit confused and thought well, best is of course to totally reset the module and deinstall it!

For the matter of fact though the module was deinstalled all statuses were still there. V1.7 and V1.8/1.9.

 

HOWEVER, clicking now the trashcan a 2nd time the status was gone and deletion successful.

So, I did this for all statuses that belonged to Masterpayment.zip Module.

 

I reinstalled module and all went fine. BUT the statuses did not reappear this time!?

 

 

I thought well might be they do so when the 1st orders come in. But, they do not and all is crashed now.

 

* splitted orders

* credid card oders come in fine but splitted

* 'oders via post payment' do not come in! Though in the BO of the payment service provider they appear.

 

 

In a nutshell,

I suppose I am asking for expert help. Should I have to pay for remote support I might be willing to do so!

It is urgend.

 

PS:

Since I have backups of the DB before this mess happend I think, could it be more easy to reimplement those statuses?

PSS:

I can not install a backup since some oders came in in between and I do not know excactly when this mess started though since I can access daily DB backups via my hoster and if you tell me where to look for I could erund so to speak when those status IDs are missing.

 

thank you!

Boris

 

 

Edited February 11, 2014 by B.Köring (see edit history)

[selectshop.at]

Disable the multishipping feature on your back-office. That's all.

 

Regards

 

Conny

Edited February 11, 2014 by selectshop.at (see edit history)

[BoKr]

Good morning Connie!

 

Sounds promising. Can you please tell me where to find the option in mind?

I entered multi shipping in the search an had no hits. I am on the run to bring my daughter to the Kita

otherwise I would take more time to look deeply at this but if you could provide me the answer more quickly.

 

thanks

 

***************

EDIT

found and it was deactivated

 

 

I think I have to take the shop offline ((

Edited February 11, 2014 by B.Köring (see edit history)

[selectshop.at]

You unselected

 

Voreinstellungen > Bestellungen > Erlaube Multi-Shopping = Nein ?

 

All new orders should now not splitted anymore. You tested ? The one already splitted you cannot undo.

Edited April 16, 2016 by selectshop.at (see edit history)

[BoKr]

Multishop is deactivated. Sad to know that the splitted orders cannot be undone but I can live with that since I noticed after deinstalling Masterpayment Module new orders that come in are not splitted anymore.

 

So the culprit in question has to do with order status mess up that came to living due to installing

PS1.49 with Masterpayment 1.7

updating to

PS1.54 with Masterpayment 1.8 new order status and old ones remained in BO causing visual disturbancy

updating to

PS1.562 with Masterpayment 1.9 nothing changed

 

Then my deletion via /BO/status of the statuses in mind after resetting and deinstalling the Masterpayment Module.

Follwing the clean restinstall of Masterpayment 1.9 but noticing that the order statuses were not put back into the /BO/status section!

 

In a nutshell, I must have messed up oder status handling due to (the normal deletion - since there are trashcan icons in /BO/Status) my deletion of oder statuses of a module I deinstalled (in order to reinstall it).

 

Difficult to explain but on the otherhand something normal any shop user might do to get a clean /BO/status section. What shall shop employees do with 25+ order statuses? ...

 

Right now I could make sure that the Module coder tries to fix it or have a look at the situation. At least that is what I was told. We will see.

 

 

I am a bit relaxed now since the double /splitted order phenomenon stopped after deinstalling this module. Otherwise I had asked you and any expert here to have a look at a back DB of the shop and to 'transfer' the oder status data from the backup into the live DB in the hope of cure.

If that is possible.

PS: Is it possible to 'beyond'-compare different backups of a phpmyadmin DB for quick error finding?

[selectshop.at]

Sorry, but I cannot give you further help on this. I'm not using Masterpayment.

[selectshop.at]

PS: Is it possible to 'beyond'-compare different backups of a phpmyadmin DB for quick error finding?

Yes it is, but I don't know any free tool for this. About 2.000 $ the one I know.

[BoKr]

Well,

 

I understand that very well that 99% of all users in this forum do not use Masterpayment.

However, now that I know that I won't be able to repair the DB merely by doing comparisson between old but working backup DB and live DB with missing Oderstates

I need to know what excactly happen when I or any other PS admin deletes an order state via /BO/orders/status!

 

Because when it is the case that only some tables are being deleted or emptied in ps1_order_state_lang and perhaps ps1_order_state then I could create them manually again.

 

I repeat the initial issue: The module does no more create its status:

	$this->createOrderState(
			'PS_OS_MASTERPAYMENT',
			'Awaiting MasterPayment payment',
			'lightblue',
			array(
				'unremovable' => true,
				'send_email'  => false,
				'delivery'    => false,
				'logable'     => false,
				'invoice'     => false
			)
		);
		
		$this->createOrderState(
			'MASTERPAYMENT_INVOICE_APPROVED',
			'Invoice Payment Approved',
			'#DDEEFF',
			array(
				'unremovable' => true,
				'send_email'  => false,
				'delivery'    => false,
				'logable'     => true,
				'invoice'     => true
			)
		);
	
		return true;
	}
	
	private function createOrderState($conf_name, $name, $color, $additional_params = false) {
		if ( ! Configuration::get($conf_name)) {
			$orderState = new OrderState();
			$orderState->name = array();
	    
			foreach (Language::getLanguages() as $language) {
				$orderState->name[$language['id_lang']] = $name;
			}
			
			$orderState->color       = $color;
			$orderState->hidden      = false;
	    
			if (is_array($additional_params) && sizeof($additional_params)) {
				foreach ($additional_params as $additional_param_name => $additional_param_value) {
					if (property_exists($orderState, $additional_param_name)) {
						$orderState->{$additional_param_name} = $additional_param_value;
					}
				}
			}
	    
			if ($orderState->add()) {
				Configuration::updateValue($conf_name, (int)$orderState->id);
				
				return true;
			}
			
			return false;
		}
		
		return true; // Already exists

Please anybody who knows about this try to help us. The agency that should support this module does simply not respond on suppport.

[BoKr]

Just an humble idea but does it make sense to change the above functions or the ones resonsible in the module to check "whether there are traces of earlier statuses"?

 

I mean that is obviously the case now. When I install the module it checkes for oder status and thinks they already exist.

But in a certain way they don't. See screenshot:

 

So, if some one nice helps me to take this function out the module would for certain reinstall its order statuses. Probably with new IDs but that should be very much ok, doesn't it?

 

All I need at the moment are the oder status / status IDs the modules knows which then and I hope all would be functional again.

 

Image one: live DB with missing IDs 15 & 15  and 22&23 I think

Image two: backup DB

 

 

ADDITON: SOLVED

TechSavvy of the PSP Masterpayment merged/updated missing fields into table and all seems fine at the moment.

 

PS:

What a crazy day. And beware never delete an order status in BO manually that you did not create your self despite the fact that it is possible via trashcan icon

Edited February 11, 2014 by B.Köring (see edit history)

[OliB]

I have some addition when somebody is searching for this.

 

Third party payment modules likely save the order state in three different tables.

 

First:      ps_order_state

Second: ps_order_state_lang

AND:      ps_configuration

 

By cklicking the trashcan the state is deleted in ps_order_state and ps_order_state_lang but not in the ps_configuration table.

When you then try to reinstall the module, the installation process looks at

if ( ! Configuration::get($conf_name))

and says "Fine my order state is allready installed in the configuration table, Then I don´t need to install it again in the order_state and order_state_lang tables"

Edited July 28, 2014 by OliB (see edit history)